Browse categories
Explore
Fiverr Pro
English
$
USD
Looks Like This Service Is On Hold
I will transform and automate your data using power query
India
I speak Bengali, English, Hindi
Excel Expert with Formulas, Dashboards, Automation, Power Query
Hi, I’m Sourav Manik Banerjee 👋
I’m an Excel expert with 10+ years of hands-on experience turning messy data into clean, automated, and easy-to-use spreadsheets. I specialize in Excel formulas, dashb...
About this Gig
Tired of manually copying data from multiple files every week? Power Query automates all that boring work. Set it up once, click refresh, done. Let me build that automation for you
What I automate: Combine multiple Excel/CSV files automatically Clean messy data with one click Import from websites and databases Remove duplicates automatically Filter and sort data Split/merge columns Unpivot data (wide to long format) Merge tables by matching columns Handle errors and blanks Create custom calculated columns Group and summarize data Reshape data structure Reusable templates for recurring work
Why Power Query? Stop wasting hours on repetitive data work. Power Query transforms data BEFORE it enters your sheet - way more powerful than formulas. One-click refresh updates everything automatically
Real examples:
· "I get 50 CSVs weekly and combine them" Auto-combine with one click
· "Daily messy report needs same cleaning" Automate entire cleaning
· "Pull data from 5 sheets and combine" Automatic combination
· "Data comes in wrong format, hours to fix" Automate restructuring
What you save: 2 hours weekly = 104 hours yearly. This pays for itself in week one
You'll just click "Refresh All" -
FAQ
I've never used Power Query before. Is this complicated?
Not at all! I set everything up for you. All you'll need to do is click "Refresh All" - I'll show you exactly where to click.
What's the difference between formulas and Power Query?
Formulas calculate in your worksheet. Power Query transforms data BEFORE it enters your worksheet. Power Query is way better for automation and combining files.
Can this work with files I receive regularly?
Yes! That's the whole point. As long as the file structure stays similar, you just replace the old file and click refresh.
What if my data comes from a website?
Power Query can connect directly to web sources. I'll need the URL and I can set it up to pull data automatically.
Will this slow down my Excel file?
Actually, Power Query can make your file faster because it processes data more efficiently than formulas. Plus, I'll optimize the queries for performance.
Can you teach me how to modify the queries later?
Yes! For Premium packages, I include training documentation and a video showing you how everything works.
What if my data structure changes?
Minor changes usually won't break anything because Power Query is flexible. For major changes, I'll help you update it (that's what revisions are for).
Can this work if my files are in different formats?
Absolutely. Power Query handles Excel, CSV, text files, and more. I'll set it up to work with whatever formats you have.
Do I need any special Excel version?
Power Query is built into Excel 2016 and later (including Microsoft 365). For Excel 2013, it's a free add-in. Doesn't work in older versions unfortunately.
Can you automate refreshing so I don't even need to click?
In Excel, you still need to click refresh. But if you're using Power BI (which is free), I can help set up scheduled auto-refresh.
