I will data cleaning work in power query
Data Cleaning Specialist Excel, Power Query
About this Gig
Are broken spreadsheets, messy CSV exports, or manual copying-and-pasting costing you hours of lost time? I can help you fix it.
I specialize in turning disorganized, error-filled, and raw datasets into clean, structured, and dashboard-ready files using Advanced Excel & Power Query. Whether you need a quick one-time sheet cleanup or a fully automated ETL refresh pipeline, I ensure 100% accuracy and efficiency.
- Data Cleaning & Standardization: Deduplication, fixing text casing, parsing dates, splitting/merging columns, and handling missing values.
- Power Query ETL Automation: Consolidating multiple CSV/Excel files from a folder into a single, automatically refreshable master table.
- Data Transformation: Unpivoting cross-tabs, reshaping schemas, and preparing datasets specifically for Power BI, Tableau, or Excel dashboards.
- Error Auditing & Fixes: Resolving formula errors (#N/A, #VALUE!), broken lookup links, and mismatched column formats.
Why Choose Me?
- Automation First: I build reusable Power Query M-code scripts so future data cleans automatically in 1 click.
- Clear Communication: I provide step-by-step documentation explaining the exact steps performed on your dataset.
Financial software:
Oracle EBS
•
QuickBooks
•
SAP s/4HANA
Industry:
Data analytics
•
E-Commerce
•
Legal
Target country:
Australia
•
India
•
United States
Gigs are not screened
Please note that there is no screening process for this service. We recommend that you message the freelancer and check all necessary details before placing your order. Read more about Financial services at Fiverr.
My Portfolio
FAQ
Can you set up an automated refresh so I don't have to clean new files manually?
Yes! Using Power Query, I can set up an automated pipeline connected to a folder or file. When you add new raw data in the future, you simply click "Refresh All" in Excel, and your cleaned dataset updates instantly.
What file formats do you work with?
A: I work with Microsoft Excel (.xlsx, .xlsb, .xlsm), CSV, TSV, JSON, and Google Sheets exports.
Is my company or personal data safe with you?
Absolutely. I maintain strict data privacy and confidentiality standards. Once the order is completed and accepted, local working files are deleted.
