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

Algumas informações são exibidas no idioma inglês.

Vetted Pro

Sérvia

Eu falo Sérvio, Bósnio, Inglês, Croata

18 pedidos finalizados

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...
Verificado pelo Fiverr Pro

Borislav J foi selecionado pela equipe do Fiverr Pro considerando sua experiência.

Verificado para

  • Data Analytics

  • Processamento de Dados

  • Visualização de Dados

Sobre este Serviço

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.

Tecnologia:

Excel

Outros

Especialidade:

Extração de dados

Fluxo de dados

Meu portfólio