Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean, transform, and automate your excel data using power query
About this Gig
Tired of copying, pasting, and re-cleaning the same data every week? I'll build a Power Query solution that does it for you once and then rebuilds itself with a single click.
Power Query is Excel's built-in automation engine. I use it to combine, reshape, and standardize your data into one clean, reliable table you can refresh anytime.
What I'll build for you:
- Merge multiple files, sheets, or a whole folder into one table
- Reshape your data unpivot, pivot, split, group, and restructure
- Remove errors, blanks, and duplicates as part of the flow
- Connect to Excel, CSV, text, web, or databases
- A refreshable query add new data, click Refresh, done
No fragile formulas, no manual steps, no monthly fees. Just a clean, repeatable pipeline that saves you hours every time.
I bring real, hands-on experience with messy, real-world data and care about accuracy and on-time delivery.
Send me your files and what you want the end result to look like I'll automate the rest.
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
My Portfolio
FAQ
What exactly is Power Query?
Excel's built-in tool for cleaning, combining, and reshaping data through repeatable steps. Once built, you refresh it with one click instead of redoing the work.
How is this different from a one-time data cleanup?
This focuses on automation and transformation — merging many files, reshaping, and building a refreshable pipeline you reuse — rather than a single manual clean of one sheet.
Can you combine multiple files or sheets?
Yes. I can merge many files, multiple sheets, or an entire folder into one unified table.
Will it update when I add new data?
Yes. It's fully refreshable — paste or replace your data and click Refresh. I can also set up scheduled refresh (extra).
What data sources do you support?
Excel, CSV, text files, folders, web tables, and common databases.
Do I need a special version of Excel?
Power Query is built into Excel 2016 and later, Microsoft 365, and Power BI — no add-ons needed.
