I will combine, clean and automate multiple excel files using power query

Vetted Pro

Serbia

I speak English, Serbian, Bosnian, Croatian

18 orders completed

Power BI Developer and Visualization Expert

Hi, I’m Borislav, a Microsoft-certified Power BI Developer helping businesses turn complex data into confident decisions and clear insights. I don’t just build dashboards - I design data-driven decisi...
Vetted by Fiverr Pro

Borislav J was selected by the Fiverr Pro team for their expertise.

Vetted for

  • Data Analytics

  • Data Processing

  • Data Visualization

About this Gig

Vetted Pro

Are you dealing with dozens or hundreds of Excel files that need to be manually opened, cleaned, transformed, and combined?


I can build a professional Power Query solution that turns multiple Excel or CSV files into one clean, structured, refreshable dataset.


I can help you with:


*Combining files or worksheets into one master table

*Importing files from folders and subfolders

*Cleaning and standardizing inconsistent data

*Handling different layouts, headers, and structures

*Extracting data from filenames and folder paths

*Merging, appending, pivoting, and unpivoting

*Creating custom transformation and mapping logic

*Removing duplicates, blanks, errors, and unnecessary rows

*Standardizing text, dates, numbers, and categories

*Building custom Power Query solutions using M language

*Creating refreshable datasets for Excel or Power BI

*Automating recurring reporting


The result: a clean, scalable dataset that refreshes when new files are added, without repeating manual work.


I handle simple consolidations and complex datasets with different structures and business rules.


Please contact me (!) before ordering so I can review your files and recommend the best solution.

Technology:

Excel

Other

Expertise:

Data extraction

Data flow

Data manipulation

My Portfolio