I will automate excel and google sheets with vba and python
Automation and AI Workflows for Excel, Python and Web Scraping in Japan
About this Gig
Are you copying data between spreadsheets by hand every week? Stop.
I build custom scripts that do it for you - merging files, cleaning up formats, calculating summaries, and generating a finished report in one click.
WHAT I CAN AUTOMATE
- Combining dozens of Excel files into one summary sheet
- Cleaning inconsistent data (dates, names, units, merged cells) - included, not extra
- Automatic calculations, pivot-style summaries, and charts
- Scheduled reports in Google Sheets (runs by itself)
HOW I WORK (what you actually get)
1. Before I start: a short requirements sheet so we agree on the exact spec
2. Working code plus a README and a plain-English guide to run it yourself
3. An edge-case test report (empty rows, duplicates, odd dates, large files)
4. 14 days of free bug-fix support after delivery
We build automation tools for small businesses every week - messy real-world data is what we deal with daily.
Please message me with your files (or dummy-data samples) before ordering so I can quote accurately.
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
•
PowerShell
FAQ
Do you need my real data?
No. A small sample with dummy values is enough for me to build and test the script.
What if the script stops working later?
I fix bugs free of charge for 14 days after delivery. Just send me a message.
Can I run it myself without any programming knowledge?
Yes. Every delivery includes a plain-English guide written for non-programmers.
Excel or Google Sheets?
Both. I work with Excel and VBA, and with Google Sheets and Apps Script. Tell me which you use.

