I will automate your excel and CSV reports with python
Data Analyst Engineer, Excel, SQL Server, Python and Power BI
About this Gig
Still copying, merging and checking spreadsheets every week?
I will build a reusable Python script that turns your recurring Excel or CSV process into a clear, repeatable workflow.
Examples:
- Combine recurring sales, stock or operational files
- Validate required fields and identify duplicates
- Apply agreed calculations and business rules
- Compare two datasets and flag missing or mismatched records
- Generate an Excel or CSV report with an exception file
You receive the Python source code, setup instructions and a tested example using the agreed sample data.
Packages cover one workflow, up to 50,000 rows per input file and the listed number of input formats and rules. Excel inputs must be .xlsx; CSV inputs must have a consistent structure.
Please contact me before ordering and share an anonymized sample, your current steps and the expected output.
Database/API connections, scheduled execution, scanned PDFs, desktop interfaces and cloud deployment require a separate scope. Revisions cover adjustments within the agreed requirements.
Technology:
Excel
•
Google Sheets
•
Python
FAQ
What should I send before ordering?
Please send anonymized input samples, your current manual steps, the rules to apply and an example of the expected output.
Will I receive reusable code?
Yes. You receive the Python source code and instructions so you can run the workflow again with files using the agreed structure.
Do I need Python installed?
Yes. The standard delivery is a Python script with setup and running instructions. Please tell me your operating system before ordering.
Can you connect to SQL Server or an API?
This can be assessed separately. Please contact me first so we can agree on access requirements, scope and pricing.
Will the script run automatically on a schedule?
Scheduled execution is not included in the standard packages. It can be assessed after reviewing your environment.
What does a revision include?
A revision includes adjustments within the agreed workflow. New input formats, additional rules or new integrations require a separate agreement.

