I will clean, deduplicate and organise your messy spreadsheet data
I turn websites and pdf into clean organised spreadsheets
About this Gig
Send me your messy spreadsheet, get back one you can actually use.
Duplicates, half-empty rows, dates in five different formats, names in ALL CAPS,
trailing spaces, "N/A" vs blank vs "-" I'll sort all of it.
What I fix: duplicate rows, inconsistent formatting (dates, phone numbers,
currency, text case), extra spaces and hidden characters, columns that need
splitting or merging, mismatched category labels, and I'll flag the rows that
have real problems (missing key data, impossible values) so you can decide what
to do with them.
You get: a clean Excel file and a CSV, the original left untouched, and a
short note listing exactly what was changed. On Premium I'll also merge several
files into one clean master sheet.
Send a sample first and I'll tell you what I'd do with it before you order.
Technology:
Excel
•
Google Sheets
•
Python
•
RStudio
•
VBA
•
Alteryx
FAQ
What formats do you accept?
Excel (.xlsx, .xls), CSV, Google Sheets. Tell me if it's somewhere else.
Will you change my data?
Only formatting and duplicates. I never invent or delete real values without asking — anything questionable gets flagged, not removed.
My file is huge / very messy
Send it over, I'll quote a custom package.
Can you merge several files?
Yes, that's the Premium package.

