I will automate your excel and CSV reports with python
About this Gig
Still rebuilding the same report every week? Share a sample Excel or CSV file and the output you want. I'll build a Python script that applies your agreed rules and produces a consistent report each time you run it.
I can standardize columns and dates, merge files, flag duplicates, check required fields and validate totals. You receive the source code, a tested example output and short instructions for running it again. Standard and Premium also include an exceptions report so you can review flagged rows.
Basic covers one file layout. Standard combines up to three files sharing one layout. Premium covers up to three different file layouts. Each package covers one output workflow. For APIs, cloud scheduling or a custom interface, message me first for a separate quote.
I can work in English or Spanish. Please share a fictional or anonymized sample.
Technology:
Excel
•
Python
FAQ
What do you need from me to get started?
Please share a fictional or anonymized input file, a sample of the desired output or its column list, and the rules you want the script to follow.
What counts as one rule?
A rule is one transformation or check, such as standardizing a date column, flagging duplicates by invoice number or checking a total against an expected amount.
How do I run the automation after delivery?
You receive Python 3 source code and instructions for running locally. Tell me whether you use Windows, macOS or Linux when you order. Hosting, scheduled jobs and a custom interface can be quoted separately.

