I will clean, convert and automate your excel data with vba and power query
WFM and Reporting Manager, n8n, AI agents, Excel VBA, WordPress fixes
About this Gig
Messy spreadsheets, PDF tables or reports you rebuild by hand every week? I clean, convert and automate your Excel data so it is accurate and ready to use.
What I can do:
- Clean data: remove duplicates, fix dates/numbers, split or merge columns, standardize text
- Convert PDF, CSV or text exports into structured Excel tables
- Build formulas (XLOOKUP, SUMIFS, dynamic arrays) and Power Query transformations
- Automate repetitive tasks with VBA macros: one click instead of hours of copy-paste
- Create a simple dashboard with pivot tables and charts
Why me:
I have 10+ years building reporting and workforce management files for large contact centers, working daily with Excel, VBA, Power Query, Power BI, SQL and Python. I know how to build files that other people can actually maintain.
You get a clean, tested Excel file, plus short instructions for any macro or query so you can refresh it yourself.
Please message me before ordering with a sample of your file so I can confirm the right package.
Your data stays confidential and is deleted after the order on request.
FAQ
Which Excel version do I need?
Microsoft 365 or Excel 2016+ on Windows is best. VBA macros have limits on Mac and don't run in Excel Online or Google Sheets; tell me what you use and I'll adapt.
Can you convert scanned PDFs?
Text-based PDFs convert accurately. Scanned PDFs need OCR and may need manual checks, so please send a sample first and I'll confirm feasibility and scope.
Is my data kept confidential?
Yes. I only use your files for your order, don't share them, and can delete them after delivery. You can also send anonymized sample data.
Can I get the result in Google Sheets?
Cleaning, formulas and conversions can be delivered in Google Sheets. VBA macros are Excel-only; for Sheets, ask me about an alternative before ordering.
What if my file is bigger than the package?
Send me the file or a sample first. I'll recommend the right package or send a custom offer, so there are no surprises.
