I will clean and standardize your messy excel data with power query

India

I speak Telugu, English, Hindi

Accounting

I am a Record-to-Report professional with 4.6 years of accounting experience specializing in month-end close, journal entries, and Blackline reconciliations. I have a proven track record in SAP migrat...
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

Expertise:

Data manipulation

•

Data upload

•

Data validation