Analytics 2

Completed Posted 11 months ago Paid on delivery
Completed Paid on delivery

We are looking to transform a CSV into something more useful for the project owners. Our ask is that a script/workflow will be created to automatically create 9 data tabs in an XLSX workbook and 9 stats tabs from the input CSV. The data tabs will be sorting/filtering the main CSV dataset into 9 smaller sets. The stats tabs will be identical in nature, just one stats tab for each of the 9 XLS workbook tabs. A small handful of charts and infographs will be required as well. This entire process should be automated and not require any administrative effort other than running the script.

End result is that the project owners should then be able to open a Word DOC/template, point to one of the transformed XLS files, and MSFT Word would then output 9 reports - one from each of the stats tabs in the XLS workbook. This should be a Word Ribbon-Bar style of add-in, python script, or MSFT Power Automate workflow that would allow the project owner to select the XLS then the script/app/workflow would output 9 word documents to a directory. Again, this entire process should be automated and require no administrative action other than selecting the proper XLS file and the directory to write the reports to.

Ideally, the transformation script/application/workflow will run on Windows 10/11.

Excel Excel VBA Power Automate Python Word

Project ID: #36671268

About the project

10 proposals Remote project Active 11 mos ago

Awarded to:

schoudhary1553

My name is Sandeep and I am a Fullstack developer with 7 years of experience in the field. I specialize in web scraping, web automation, coding useful scripts and more. I understand you are looking to transform a CSV More

$220 USD in 5 days
(611 Reviews)
8.5

10 freelancers are bidding on average $238 for this job

dvcontact

Dear Sir, Are you looking for a solution to transform a CSV into something more useful for the project owners and automatically create 9 data tabs in an XLSX workbook and 9 stats tabs from the input CSV? I am Smith, an More

$140 USD in 7 days
(81 Reviews)
7.1
Giovanni704

Hi there! As I have read, I see you need help creating an automated script to transform a CSV file into a structured XLSX workbook with 9 data tabs and corresponding stats tabs and I could help you! I'm a professiona More

$30 USD in 1 day
(60 Reviews)
6.9
datascientist90

I understand you are looking for someone to help you transform a CSV into something more useful for the project owners and that a script/workflow will be created to automatically create 9 data tabs in an XLSX workbook More

$250 USD in 7 days
(28 Reviews)
6.6
SIBTEHASSANBUTT

Greetings, I understand that you are seeking a professional with expertise in data visualization and dashboard creation using Power BI. As a data expert with extensive experience in Power BI, I possess the necessary s More

$250 USD in 2 days
(39 Reviews)
4.9
nuraishahrazak

Hello there! So you want to transform your CSV data into reports in MS word. I believe I'm the right person for this project. From your description it seems that there will be 2 tasks/users- one that/who will generat More

$160 USD in 7 days
(1 Review)
2.7
janaabdullah

Hello, its Jana Ahmad. I am a Python developer with a strong background in computer programming(EXCEL ADVANCE), a huge knowledgeable in software engineering practice, and a great statistical skills. Also, a Performan More

$200 USD in 7 days
(2 Reviews)
1.7
Diemunus

Hello! I'm interested in your project, my current job as a data analyst is to transform csv files containing millions of entry into a standard format to be easily processed and analyzed. All through automation, althou More

$140 USD in 7 days
(0 Reviews)
0.0