I will automate excel and CSV reports with a tested python script
Automation and Digital Services Specialist
About this Gig
Turn repetitive Excel and CSV work into a reusable Python script.
I can automate file merging, duplicate removal, column mapping, format cleanup, agreed calculations and report generation.
You receive Python source, requirements.txt, setup/run instructions, a sample output and a short record of checks against your agreed examples.
Basic: 1 input, 1 output, up to 3 rules and 10,000 rows.
Standard: up to 2 inputs, 1 report, 5 rules and 50,000 total rows.
Premium: up to 3 inputs, 1 report, 8 rules and 100,000 total rows.
Inputs must be CSV or XLSX with up to 20 columns per file. A rule is one agreed transformation or calculation. Missing or ambiguous data is flagged rather than guessed.
Please message me with representative files, desired output and operating system before ordering so we can agree the scope.
AI-assisted coding, executed and reviewed against supplied examples. Packages cover local Python scripts. APIs, web scraping, GUI apps, VBA, hosting and ongoing operation require a separate quote.
Technology:
Excel
•
Python
Expertise:
Data manipulation
•
Data validation
•
Transformation
FAQ
What counts as one automation rule?
One rule is one agreed transformation or calculation, such as removing duplicates by a chosen key, mapping columns, merging by a key, standardizing a date format or calculating one report field. We agree the rules and expected output before work starts.
Do I need Python, and what will I receive?
Yes. These packages provide a local Python script, not a standalone app. You receive source code, requirements.txt, setup/run instructions, sample output and check notes. Tell me your operating system and Python version if known; the tested Python version will be documented.
How are the output and revisions checked?
I execute the script against your representative files and compare the output with the agreed rules and expected examples. Revisions correct the original agreed scope; new rules, formats or integrations require a separate quote. Missing or ambiguous data is flagged for your decision.
