Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate your recurring excel reports with python or vba macros
Data Science and AI Bachelor Data Analyst
I am a Bachelor in Data Science and Artificial Intelligence with a focus on data analysis, automation, and information visualization to support decision-making. I have academic and practical experienc...
About this Gig
Still building the same Excel report every week by hand? I will turn it into a script that does it for you.
I build Python and VBA tools that read your source spreadsheets or CSV exports, clean and calculate the data, and produce a formatted Excel report (or PDF/HTML) the same way every cycle.
What I can automate:
- Merging and cleaning multiple Excel or CSV files
- Calculations, KPIs, grouped summaries and pivot refreshes
- Formatted output: styles, conditional formatting, charts
- One report per region, product or team from a single source
- Fixing, cleaning up or extending existing VBA macros
- Driving Excel from Python (win32com) when macros must stay
Stack: Python, pandas, openpyxl, VBA, win32com, PowerShell.
Every delivery includes the source code, a short run guide and a sample output built from your data. Before ordering, send me a message with a sample file (dummy data is fine) so I can confirm scope and package.
Custom work is yours; reusable base code is licensed to you for unlimited internal use.
Technology:
Excel
•
Python
•
VBA
•
PowerShell
FAQ
Python or VBA: which one will you use?
It depends on your environment. VBA is great when everything lives inside Excel and users cannot install Python. Python is better for larger data, multiple files and PDF/HTML output. I will recommend one after seeing your file.
Do I need to install anything?
For VBA, no: you get an .xlsm file. For Python, I provide a requirements file and a step-by-step run guide, and can package a simple one-click runner.
Can you fix my existing macro?
Yes. The Basic package covers a small fix. Larger rewrites fit Standard or Premium. Send the file first so I can review it.
Is my data safe?
You can share dummy or anonymized data. I only need the structure (columns, sheets, layout) to build the tool.
Can you use a PDF as input?
Only system-generated PDFs (exported from Excel, ERP or similar). Scanned or photographed PDFs are not accepted in the starting packages.
Do you have an example I can see?
Yes, a demo project with fictional data: an Automated Sales Report in Excel that turns a raw sales CSV into a formatted workbook with KPI cards, a monthly trend, a region pivot and native charts. See the gallery images.
Will it work next month with new data?
Yes, that is the goal. The tool is built for recurring use: you drop the new files in and run it again.
Can we have a call?
All communication is written, through Fiverr messages. You get clear written updates at each step, and every question gets a written answer, so nothing is lost and you can check it later.
