Import Multiple Files into Excel: A Practical Guide

Yes. In Microsoft Excel for Microsoft 365 on Windows, use Data > Get Data > From File > From Folder to import a folder of similar files, then choose Combine & Transform Data to bring their rows into one table. If you want each file kept separate, import each one as its own query or worksheet instead.

What “import multiple files” can mean

Excel can bring data from several files into a workbook in more than one way. The right method depends on what you want to do with the data after it arrives. Combining files means stacking their records into a consolidated result; importing files separately means keeping each source in its own query, sheet, or table.

Combine matching files: Append records from monthly sales CSVs or similarly structured workbooks into one table.
Keep files separate: Import different reports into separate sheets so you can review them individually.
Import several sheets from one workbook: Choose multiple worksheet or table items from the workbook’s Navigator window.

For recurring work, Power Query is usually the most useful option. It records the import and transformation steps, so you can refresh the result when source files change or new files are added. Copying and pasting is possible for a one-off task, but it is easier to make mistakes and harder to repeat consistently.

Combine files from a folder with Power Query

The folder method works best when the files contain the same kind of data in the same layout. For example, suppose a folder contains January, February, and March CSV exports, each with columns named Date, Product, and Units. Power Query can read each file and append the rows into one result.

Put the source files in one folder. Keep unrelated files, such as notes or backup copies, elsewhere.
In Excel, select Data > Get Data > From File > From Folder.
Browse to the folder and select it. Review the file list, then choose Combine & Transform Data.
In the Power Query prompts, select the sheet, table, or content to use as the sample. Check that the preview shows the data you intend to combine.
Review the combined result in the Power Query Editor. Remove unnecessary columns or rows and confirm that headings and data types look right.
Select Home > Close & Load to return the result to Excel. Depending on the workflow, you can use Close & Load To to choose where and how to load it.

Power Query creates a query that reads the files in the selected folder and applies the same transformation steps to them. The resulting table is not simply a static copy of the current data. When the source files are updated, use Data > Refresh All to refresh connected results. The query’s folder location must remain accessible for refresh to work.

Prepare files before combining them

Matching structure matters more than matching filenames. Ideally, every file should have one header row, the same column names, and the same meaning and data type in each column. A column called Amount should contain amounts in every file, rather than amounts in one file and comments in another.

Small differences can create confusing results. If one report calls a field Customer ID and another calls it Client ID, Power Query may treat them as separate columns rather than recognizing them as the same field. Similarly, a date stored as text in one source may not behave like a date stored as a date value in another. Standardize these details before importing when practical, or correct them in the query.

Use a dedicated folder for the files you want included.
Use consistent headings and avoid title rows above the actual column headers.
Check that files do not contain extra totals or footnotes that would be mistaken for records.
Use consistent file types where possible, such as all CSV files or all workbooks with the same table layout.
Keep a backup of source files if you plan to rename, move, or clean them up.

File names can still be useful even if the columns match. Power Query’s folder listing includes file metadata, and you can retain the source file name as a column when you need to trace a row back to its origin. This is helpful for auditing or investigating an unexpected value.

Import files without combining them

If each file should remain independent, create a separate query for each one. In Excel for Windows, use Data > Get Data > From File and choose the appropriate source, such as From Text/CSV or From Workbook. Select the file, inspect the preview, and load it. Repeat for the other files, choosing a separate destination when needed.

For multiple worksheets or tables in one Excel workbook, choose Data > Get Data > From File > From Workbook, then select the workbook. The Navigator window lists available items. Select an item to preview it and load the required worksheet or table. If you need several items, you can select and load them as separate queries; exact selection options may vary with the workbook’s contents and Excel build.

Keeping queries separate is useful when the files have different layouts or serve different purposes. You can still combine them later if their columns can be aligned. In Power Query Editor, use Home > Append Queries to stack rows from compatible queries. Appending is different from merging: append adds rows, while a merge matches rows using one or more key columns, much like a lookup.

Choose between folder import, separate queries, and copy-paste

Use the folder method when you receive a recurring batch of similarly structured files and want one refreshable table. It is especially valuable for weekly or monthly exports: save the next file in the designated folder and refresh the query. Before relying on that process, verify whether the query will include every file in the folder and whether older files should remain there.

Use separate queries when the source files differ in layout, when you need independent outputs, or when you want to inspect each source before combining anything. Use copy-paste for a small, one-time job where the data is simple and no repeatable refresh is needed. Copy-paste can be quick, but it does not preserve a dependable connection to the original files.

A useful rule is to ask whether the files represent repeated batches of the same dataset. If they do, combine them. If they are distinct reports, import them separately first. If some files share a structure and others do not, combine the compatible group and handle the exceptions in their own queries.

Refreshes, file changes, and storage locations

A Power Query import is tied to its source path. Moving or renaming the folder can prevent refresh until the source location is updated. If files live on a shared drive, make sure the drive is available to the person refreshing the workbook. A path that works on one computer may not work on another if it points to a local folder such as a user’s Downloads directory.

When you add a new file to a folder-based import, refresh the query to check that it is included. When you remove a source file, refresh to update the combined result. Do not assume that deleting rows from the output worksheet changes the source files or permanently changes the query; the next refresh can rebuild the output from the sources and recorded steps.

Be careful with temporary or backup files in the source folder. If a file matches the query’s import pattern but has a different structure, it can cause errors or unexpected columns. A dedicated folder and a quick review of the source file list are simple safeguards. If the query has filters, verify that they still include the intended files after the folder contents change.

Common problems and how to fix them

Some rows or files are missing: Confirm that the files are in the selected folder, that filters are not excluding them, and that the query has been refreshed.
Columns appear twice under different names: Compare the headers across source files and standardize spelling, spaces, and punctuation.
Refresh reports an error: Open the query and identify the failing step. A source file may have been moved, renamed, deleted, or changed to a different layout.
Numbers or dates look wrong: Check the column’s data type and regional format. Values such as 03/04/2026 can be interpreted differently depending on date conventions.
Extra rows appear: Look for repeated headers, subtotal lines, blank rows, or report notes in the source files. Filter or remove these in Power Query if appropriate.

When the source files are generated by another system, changes to that system’s export format can break a previously reliable query. If a refresh fails after an export update, compare a new file with an older one and check for renamed fields, additional heading rows, or a changed worksheet name.

Excel for Mac and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Power Query features and available connectors can differ by platform and update channel. Excel for Mac has Power Query capabilities, but the set of supported sources and folder-import options may differ from Windows; check the Data tab and the current Microsoft support information for your installed build. If the folder connector is unavailable, importing files individually or combining them on a Windows desktop may be necessary.

Excel for the web can work with some imported data and may support refreshing certain queries, but it does not provide the same full Power Query authoring experience as Excel for Windows. If you need to build or substantially edit a folder-combine query, use the Windows desktop version. A workbook’s refresh behavior can also depend on the source type and access permissions.

Frequently Asked Questions

Can I import multiple CSV files into one Excel sheet?
Yes. Put files with matching columns in a folder, use Data > Get Data > From File > From Folder, and choose Combine & Transform Data. Review the result and refresh the query when the folder contents change.

Do all the files need to have the same name?
No. They can have different filenames. Consistent column headings and layout are more important. Keeping meaningful filenames can help you identify which source contributed particular records.

Can Excel combine files with different columns?
Sometimes, but the result may contain separate columns for differently named fields, with blank values where a file lacks a column. For a clean result, align headings and decide how to handle missing fields in Power Query.

Will new files appear automatically in the combined table?
Not necessarily as soon as they are saved. The folder query can read qualifying files when refreshed, so use Data > Refresh All and verify the result. The new file must be in the queried location and compatible with the import steps.

Can I combine worksheets instead of files?
Yes. You can select worksheet or table items from a workbook’s Navigator, or create separate queries and append compatible data in Power Query. Combining worksheets works best when their data has the same structure.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.