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

Parte de la información aparece en idioma inglés.

Vetted Pro

Serbia

Hablo Serbio, Bosnio, Inglés, Croata

18 pedidos completados

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...
Revisado por el equipo de Fiverr Pro

El equipo de Fiverr Pro seleccionó a Borislav J por su experiencia.

Revisado para

  • Análisis de datos

  • Procesamiento de datos

  • Visualización de Datos

Acerca de este Servicio

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.

Tecnología:

Excel

Otros

Experiencia:

Extracción de Datos

Flujo de Datos

Mi porfolio