Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate your repetitive excel tasks with power query
About this Gig
Tired of repeating the same Excel work every week or month?
I will turn your repetitive Excel or CSV process into a reusable workflow using Excel and Power Query.
This service can include:
Combining multiple Excel or CSV files
Cleaning and standardizing data
Removing duplicates and unnecessary columns
Converting dates, numbers and formats
Matching and transforming tables
Preparing a recurring report or final output table
The service covers up to 3 source files, 10 main transformation steps and 1 final output table.
You will receive a tested Excel workbook with the Power Query workflow configured, along with simple instructions explaining how to replace the source files and refresh the result.
Please send sample files, a description of the steps you currently perform and an example of the expected result. Contact me before ordering so I can confirm that your request fits the scope.
Platform:
Excel
Development technology:
Power Query
•
Excel
FAQ
What do you need to start?
Please send sample Excel or CSV files, a short description of the steps you currently perform and an example of the expected result. You may anonymize or remove confidential data before sending the files.
What is included in the $45 service?
The service covers one recurring process with up to 3 source files, 10 main Power Query transformation steps and 1 final output table. You will also receive simple refresh instructions.
Can you automate any Excel task?
This service focuses on data cleaning, combining files, transforming tables and preparing recurring reports with Power Query. VBA macros, custom applications and complex dashboards are not included.
Can I reuse the workbook with new data?
Yes. The workbook will be configured so you can replace the source data and refresh the Power Query workflow. The new files must keep the agreed structure and column layout.
