I will clean and standardize your messy excel data with power query
About this Gig
Is your Excel file full of messy data? I will clean, standardize and organize it so it is ready for reports, analysis or system upload.
What I fix:
- Extra and non-breaking spaces, inconsistent capitalization
- Mixed date formats converted to real Excel dates
- Amounts stored as text (currency symbols, brackets, "k" shorthand)
- Phone, email and ID formats
- Spelling variants in cities, departments, statuses and categories
- Duplicate, blank and repeated header rows
- Combined columns split into separate ones
What you get:
- A clean, formatted Excel file
- Nothing guessed: missing or invalid values are flagged, not filled in
- Standard and Premium include an Exceptions sheet and README of my assumptions
- Premium adds a Power Query workflow that re-cleans your next export in one click
Rows are counted per file. Message me before ordering if your file is large or complex and I will send a custom offer.
Technology:
Excel
•
Google Sheets
•
Other
FAQ
What file types do you accept?
Excel (.xlsx), CSV, and Google Sheets links.
Is my data safe?
I use the files only for the order and delete them after delivery.
What if the data has missing values?
I flag them in the Exceptions sheet rather than guessing.

