I will clean and transform your excel data with power query
Excel dashboards and Power Query cleaning
About this Gig
Is your Excel data messy, repeated, or stuck in monthly export files? I clean and transform it with Power Query so you get a refreshable table, not a one-off manual fix.
I am a business intelligence and data analytics professional based in Germany. Power Query is part of my daily work, not a one-off skill for this gig. I clean and shape data so the result stays correct when you refresh it. This gig is for Microsoft Excel, not a full dashboard or Power BI.
What you get:
A cleaned, well-typed output table you can filter, pivot, or load into a dashboard later
Refreshable Power Query steps you can reuse when new data arrives
Cleaning as agreed in your package: duplicates, blanks, data types, unpivoting, splits, and merges
A short note on how to refresh the queries
The editable Excel file
How we work:
1. You upload your file or a sample and describe the output you need.
2. I confirm the scope and limits before I start.
3. I deliver the workbook and apply the included revisions.
Please message me first if you have many different file layouts, very large files, or need folder automation. I will suggest the right package or a custom offer.
Platform:
Excel
Development technology:
Power Query
Expertise:
Power Query
•
Cleaning
FAQ
Is this for Excel or Google Sheets?
This gig is Microsoft Excel and Power Query. Google Sheets cleaning is possible only as a custom offer, because Power Query is an Excel feature.
Will I get a dashboard too?
No. This gig delivers a clean, refreshable table and the Power Query steps. If you also need a dashboard, see my dashboard gig or ask for a combined custom offer.
What file types do you accept?
Excel workbooks and CSV files are the standard input. Premium is for same-layout files only, including a folder of similar monthly exports. The 200,000-row maximum depends on file quality and Excel limits; if that would not fit in 5 days, I will say so before starting. PDF-only or badly scanned tabl
Can I refresh the result when new data arrives?
Yes. That is the point of using Power Query. You get written steps for refreshing. If the new file has a different layout, extra work may be needed.
What if my file is larger than the package limit?
Message me before ordering. I will tell you whether a higher package or a custom offer is the honest fit. I do not start work beyond the agreed limits without a new offer.
What do the included revisions cover?
Revisions are polish and small adjustments to the agreed deliverable only. New sources or a larger data volume need a new package or a custom offer.

