I will automate excel and CSV reports with a reusable python script
Python Automation Digital Solutions Motion Graphics Logo Animation
About this Gig
Tired of rebuilding the same Excel reports?
I will create a reusable Python script that turns your Excel or CSV files into a clean, organized report. Run it again whenever you have new files with the same structure.
Depending on your package, I can:
- Clean data and remove duplicates
- Standardize dates and number formats
- Combine up to 3 Excel/CSV files
- Apply agreed calculations and business rules
- Generate a formatted Excel report
- Add an Excel dashboard with up to 5 KPIs and 3 charts
Example: combine sales files, calculate revenue by product, and create an Excel summary with charts.
Every package includes Python source code and setup instructions. Python and the required libraries must be installed to run the script. A Windows app, automatic scheduling, API connections, and website downloads require a separate quote.
Please message me with sample files and an example of your desired output before ordering. I will confirm the scope, file size, compatibility, and suitable package.
Please remove sensitive information from sample files.
Technology:
Excel
•
Python
My Portfolio
FAQ
What file formats do you work with?
I work with Excel (.xlsx) and CSV files. Please send anonymized samples before ordering so I can check the structure, file size, and required processing. Other formats or complex workbooks need a separate review.
Can you customize the dashboard and calculations?
Yes, within the agreed package scope. Standard includes up to 5 processing rules. Premium adds an Excel dashboard with up to 5 KPIs and 3 charts. Please provide your calculation rules and an example of the desired output before ordering.
Will I receive the source code?
Yes. Every package includes the Python source code, a list of required libraries, and setup and usage instructions. You can reuse the script with new files that follow the agreed structure.
Do I need Python installed to use the automation?
Yes. The standard delivery requires Python and the listed libraries. I provide setup instructions; you do not need VS Code. A standalone Windows application may be available through a custom offer. Please confirm your operating system before ordering.
Is my data kept confidential?
I use your files only to complete your project. I will not publish them or include them in my portfolio without your permission. Please provide anonymized samples whenever possible. If your project has specific confidentiality requirements, discuss them with me before ordering.
Will the script work with future files?
Yes, provided future files follow the agreed structure, column names, and formats. Changes to the input layout or business rules may require a separate update. Automatic scheduled runs are not included in the standard packages.
What is included in a revision?
Revisions cover adjustments within the agreed requirements. New features, extra input files, or changes to the original workflow may require a custom offer. Fixing errors in my implementation of the agreed requirements does not use up your included revisions.

