Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean and automate your data with power query
About this Gig
Professional Data Cleaning & Transformation | Excel Power Query
Is your raw data a mess? Mixed date formats, duplicate records, inconsistent categories, invalid emails, missing values everywhere? I'll turn it into clean, analysis-ready data using advanced Power Query.
What I Clean: Dates (multiple formats unified) Text (trim, proper case, special characters) Duplicates (exact + near-duplicate removal) Missing values (N/A, null, blanks standardized) Categories (variant spellings mapped to canonical values) Emails, phones, zip codes (validated & formatted) Currency symbols & mixed data types Outlier detection & flagging
What You Get: Cleaned, formatted Excel file (filters, headers, typed columns) Before/after data quality summary Premium: Full transformation log + reusable Power Query M-code
Why Me: I can transform messy, real-world datasets from multiple source systems (Shopify, Amazon, POS, CRMs). Every step is documented and reproducible no black-box cleaning.
Formats: .xlsx, .csv, .tsv Tools: Excel Power Query (M-Code)
Send me a sample of your messy data and I'll give you a free assessment of what needs fixing.
My Portfolio
FAQ
What file formats do you accept?
I work with .xlsx, .csv, and .tsv files. If your data is in Google Sheets, just export it as .xlsx or .csv and send it over. I'll deliver the cleaned file in the same format you provide.
Will I be able to see what changes you made?
Absolutely. Every order includes a before/after summary showing what was cleaned and how many issues were fixed. Standard and Premium orders include a detailed transformation log documenting every step. Premium also includes the reusable Power Query M-code so you can reapply the cleaning yourself.
Can you clean data from multiple files or sheets?
Yes. If your data comes from different sources (e.g. Shopify + Amazon + POS), I can merge and clean them into one unified dataset. This may require a Standard or Premium order depending on complexity.
