I will do excel data cleaning, google sheets formulas and data entry
Data and Automation Specialist
About this Gig
Duplicate rows, dates stored as text, broken VLOOKUPs, four exports that should be one file, a report you rebuild by hand every month.
Send it to me. You get it back clean, working and ready to use.
WHAT I FIX
Duplicates, blanks and inconsistent entries, with a note on how many I removed.
Broken formulas: VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, ARRAYFORMULA.
Dates stored as text, converted to real dates that sort correctly.
Multiple files merged into one dataset with consistent columns.
Pivot tables, charts and summary dashboards.
The monthly repeat work, automated with a macro or Apps Script.
Excel, Google Sheets and CSV, including conversion between them.
Your original file is never overwritten. You get a clean copy plus notes on every change, and your data is deleted after delivery on request.
Not sure which package fits? Send the file first and I will tell you what it needs before you order.
FAQ
My data is confidential. Can you still work on it?
Yes. Send a sample with names or figures replaced and I will build against that, then apply the same fix to your real file. I delete all files after delivery on request.
My file is bigger than 10,000 rows. What then?
Message me with the row count and I will send a custom offer. Large files are usually still fast, because the work is scripted rather than done by hand.
Do you work in Google Sheets as well as Excel?
Both, plus CSV. I can also convert between them and rebuild formulas that break in the move, which is where most conversions go wrong.

