--- title: Import multiple Excel or CSV files in to Excel using Power Query description: Learn how to easily import multiple CSV files into Excel using Power Query to streamline your data management process. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Cartoon%20image%20of%20stacking%20lots%20of%20files%20and%20data%20together-1.jpeg --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) [Power Query](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/power-query) # Import multiple Excel or CSV files in to Excel using Power Query [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 24 June, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Cartoon%20image%20of%20stacking%20lots%20of%20files%20and%20data%20together-1.jpeg) If you have multiple Excel files you need to combine in to one list, Power Query may have the answer for you.  Using the import from folder option, you can import multiple xlsx or csv files in to one Excel file without having to manually copy and paste the data one file at a time.   To give Power Query the best chance please be mindful of the below: - The files need to be of the same structure  E.G. same headings in the same place.  If not, Power Query will try its best but it cannot work miracles. - All the files you want to import should ideally be in the same folder to make the import easier. How To: - Open Excel - Click on the "Data" tab - Click "Get Data" (first option on the left) - Click "From File" - Click "From Folder" - Use the pop up to browse to the folder that contains the xlsx or csv files you want to combined - The following screen will appear.  It displays a list of the all the files found in the folder selected previously.  Click "Combine" and then "Combine & Load to" ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-3.png?width=722&height=571&name=image-png-3.png) - Use the screen below to check the data is as expected, and then click ok: ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-4.png?width=669&height=505&name=image-png-4.png) - Choose where you would like to import the data to.  If you accept the default options below, the data will be imported in to a new sheet: ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-Jun-23-2025-10-35-56-7700-AM.png?width=255&height=230&name=image-png-Jun-23-2025-10-35-56-7700-AM.png) - And following a moment, Power Query / Excel will import your data from all the files and add it to your spreadsheet. If this was useful and you would like more Power Query tips to be added to our blog, please leave a comment below. Previous Post ###### [You can't spell Paint without AI - Generative Erase tool](https://woodthorpeitsolutions.co.uk/tips-and-news/you-cant-spell-paint-without-ai-generative-erase-tool) Next Post ###### [Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/missing%20information%20cartoon%20spreadsheet-1.jpeg?width=352&name=missing%20information%20cartoon%20spreadsheet-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) #### [Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg?width=352&name=A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/i-cant-type-a-phone-number-in-to-excel) #### [Ahhh, I can't type a phone number in to Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/i-cant-type-a-phone-number-in-to-excel) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/calendar%20maths%20cartoon.jpeg?width=352&name=calendar%20maths%20cartoon.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) #### [The final countdown (Date Maths in Excel)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-06-24T09:30:00.136Z", "datePublished" : "2025-06-24T09:30:00.000Z", "headline" : "Import multiple Excel or CSV files in to Excel using Power Query", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/Cartoon%20image%20of%20stacking%20lots%20of%20files%20and%20data%20together-1.jpeg" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/import-multiple-excel-or-csv-files-in-to-excel-using-power-query", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```