---
title: "Discussion on \"Combine many Excel files into one table with Power Query\" | Hashnode"
description: "Discussion on \"Combine many Excel files into one table with Power Query\". Step by step: combine a folder of Excel or CSV files into one table with Power Query, and refresh it every month."
url: "https://hashnode.com/posts/combine-many-excel-files-into-one-table-with-power-query/6af5b9c7b323451bbe3dcfea"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Combine many Excel files into one table with Power Query](https://armaandata.hashnode.dev/combine-many-excel-files-into-one-table-with-power-query?utm_source=hashnode&utm_medium=feed)

Step by step: combine a folder of Excel or CSV files into one table with Power Query, and refresh it every month.

Nov 12 · 2 min read · armaandata.hashnode.dev  
Read the article

-   [#powerquery](https://hashnode.com/tag/powerquery)
-   [#excel](https://hashnode.com/tag/excel)
-   [#power-bi](https://hashnode.com/tag/power-bi)

## Written by

[Aniket Kumar Mishra](https://hashnode.com/@armaandata)

@armaandata · Dubai, UAE

  
[View profile](https://hashnode.com/@armaandata)

Power BI and Excel automation. Data clean-up, ETL and reports for small and mid-size companies.

I turn messy business data into clean Power BI dashboards and automated reports. Excel, Power Query and VBA pipelines: drop new files in a folder and the report updates. Based in Dubai, working with small and mid-size companies. Client work is confidential; samples use simulated data.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
