To import multiple CSV files into one Excel worksheet, put the files in a folder, then use Data > Get Data > From File > From Folder in Excel for Microsoft 365 on Windows. Choose Combine & Transform Data, check the preview, and load the combined table to a worksheet. Excel stacks the records from each file; it does not place each file side by side.
What importing multiple CSV files means
A CSV file stores tabular data as plain text, with commas or another delimiter separating fields and line breaks separating records. When you combine files, Excel reads each file and appends its data as additional rows in a single result. For example, three monthly sales files with the same columns can become one table containing all three months of sales.
This is different from importing several files as separate tabs, joining them side by side, or combining them with a lookup. Appending is usually the right choice when each CSV contains more records of the same kind: transactions, survey responses, inventory movements, or daily measurements. If each file contains different fields or represents a different kind of information, you may need to reshape or join the data instead.
Power Query is the most practical built-in option for recurring work. It creates a set of instructions that Excel can run again, rather than asking you to repeat the same copy-and-paste steps every time new CSVs arrive.
Why use Power Query
Power Query is Excel’s data-import and transformation tool. It can read files from a folder, combine their rows, and let you review or adjust the result before loading it. The source CSV files remain separate and unchanged; the combined table is an output in the workbook. This is useful when you receive a new batch each week or month and want to update the report without rebuilding it.
The folder method works best when the files have a consistent structure. Ideally, each file uses the same delimiter, column names, and general data layout. Some differences can be handled in Power Query, but a consistent template reduces errors and makes refreshes more predictable. Keep unrelated files out of the folder, or filter the file list to include only the CSVs you intend to combine.
Combine CSV files from a folder
- Prepare a source folder. Put the CSV files you want to combine in one folder. If the folder also contains notes, exports with a different layout, or unrelated files, move them elsewhere or plan to filter them out.
- Start the folder import. In Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From Folder. Browse to the folder and select Open or OK. Excel displays a list of the files it found.
- Choose the combine option. Select Combine > Combine & Transform Data. The exact button presentation can vary slightly by build. Excel uses a sample file to determine how to interpret the files, then opens the Power Query Editor with a preview of the combined data.
- Review the query. Check that the first row is being treated as column headings, that the columns line up, and that values have not been split incorrectly. If necessary, change the delimiter or data types and remove columns you do not need.
- Load the result. In Power Query Editor, select Home > Close & Load, or use the Close & Load dropdown and choose Close & Load To. Choose Table, then select New worksheet or Existing worksheet and specify a starting cell. Select OK to create the combined table.
In a typical set of monthly files, each CSV has columns such as Date, Product, Quantity, and Amount. The combined result has one header row followed by the records from all of the files. Power Query generally takes the header structure from the sample file, so do not expect repeated header rows within every file to become useful data. Review the preview, especially when the files were produced by different systems.
Load the table and refresh it later
For an output that is easy to manage, load the combined result as an Excel table on a new worksheet. A new worksheet keeps the imported data separate from your notes, formulas, and report layout. If you specifically need the table on an existing worksheet, use Close & Load To and choose an empty destination cell. Leave enough space for the results to expand; loading over existing content can cause a conflict or make the result hard to use.
After the initial load, you can add new CSV files to the source folder and refresh the query. In Excel for Windows, select Data > Refresh All, or right-click the query output and choose Refresh. The query rereads the folder and updates the combined table. Refresh does not edit the original CSV files, but it can change the output table to reflect changed or newly added source data. If you remove a source file, a refresh can also remove that file’s rows from the output.
Keep the folder at a stable location if you expect to refresh the workbook later. Moving or renaming it can break the query’s source path. If that happens, open the query settings or use Data > Get Data to update the source location. When sharing the workbook, remember that another person may not have access to your local folder; the workbook’s query cannot retrieve files they cannot access.
Check headers, delimiters, and data types
Before trusting the combined table, inspect a few records from each source file. CSV does not guarantee that every program uses the same separator or encoding. A file may use semicolons instead of commas, or contain characters that display incorrectly if the text encoding is interpreted differently. In Power Query, the preview and delimiter options help reveal these problems before the data is loaded.
- Headers: Make sure every file has the same column headings and that the first data record has not been mistaken for a heading. Avoid blank or duplicate column names.
- Column order: Check that the same field appears in the same column across the files. A changed export layout can put values under the wrong heading.
- Identifiers: Set codes, postal codes, and account numbers to Text when leading zeros matter. A value such as 00421 should not silently become 421.
- Dates and decimals: Confirm that the date order and decimal symbol match the source data. Regional settings can affect interpretation of values such as 03/04/2026.
- Empty values: Decide whether blank cells are genuinely missing information or represent a value that needs to be supplied before analysis.
Excel worksheets can contain at most 1,048,576 rows and 16,384 columns. The header uses one row, so a combined output with more records than the worksheet limit cannot be loaded in full as a sheet table. For larger datasets, consider using Power Query for transformations and loading to the Data Model, or use a database or other data tool designed for larger volumes.
Common problems and how to fix them
The result contains extra rows with column names. This usually means each CSV’s header row was imported as ordinary data, or the files do not share the same structure. Check the sample-file transformation and the applied steps in Power Query. Confirm that headers are promoted once and that source files have a consistent header row.
Values appear in one column or split into the wrong columns. Check the delimiter used by the source. A comma-separated file may instead use semicolons, tabs, or another separator. Also check whether text fields containing commas are enclosed correctly in quotation marks; a properly formatted CSV treats a quoted comma as part of the field, not as a column break.
Some files are missing or the query fails. Verify that the files are in the selected folder, have the expected file extension, and are not temporary or unrelated exports. A file with different columns or a different delimiter may fail the transformation based on the sample file. Inspect the folder listing and filter it to the intended files, then correct or exclude the outlier.
Leading zeros or dates change. Excel and Power Query may infer a data type from sample values. In the query, set fields that must remain identifiers to Text, and check date and number types against the source format. Do not rely on cell formatting alone to restore zeros that were already removed during conversion.
New files do not appear after refresh. Confirm that they were saved in the exact folder used by the query, that the file filter includes them, and that the query refresh completed without an error. Refreshing updates the query output; it does not automatically search every folder on your computer.
Power Query versus copy and paste
Copy and paste can be quicker for a one-time task involving only a few small files. Open each CSV, copy its data rows, and paste them beneath the previous file’s rows in a destination worksheet. Copy the header only once. Then check that the columns match and save the result as an Excel workbook so the combined data is no longer dependent on separate open CSV windows.
The trade-off is that manual pasting is easy to repeat incorrectly. It can duplicate a header, omit a file, or paste records into the wrong columns, and it does not provide a dependable refresh process. Power Query takes more setup at first, but is better for a repeatable import and makes the transformation steps visible. If you use Excel for Mac or Excel for the web and do not see the folder connector, available Power Query sources and menus can differ by version. You can import and append files individually where those commands are available, or use a careful manual workflow; do not assume every platform exposes the same folder-combine steps as Windows desktop Excel.
Frequently Asked Questions
Can Excel combine CSV files automatically?
Yes. In Excel for Microsoft 365 on Windows, use Data > Get Data > From File > From Folder, then choose Combine & Transform Data. Once the query is set up, refresh it to bring in new files from the source folder.
Will Excel put each CSV on a separate worksheet?
Not with the folder-combine process described here. It appends the file contents as rows in one combined table. To keep separate worksheets, import each file separately instead of combining them.
Do all CSV files need the same columns?
They should have the same headings and compatible layouts for the most reliable result. If a file has different columns or column order, correct or transform it before combining, then review the Power Query preview to confirm the fields are aligned.
Can I add another CSV after the first import?
Yes. Save the new file in the folder used by the query and select Data > Refresh All. Check any file filters and refresh errors if the new rows do not appear.
Can I combine CSV files on a Mac?
Power Query features and connectors vary between Excel versions and platforms. Check whether your Excel for Mac build offers a folder data source. If it does not, import the files individually and append them where available, or use copy and paste for a small one-time combination.
Does combining the files change the original CSVs?
No. Power Query reads the files and creates a result in the workbook. Editing the loaded table does not rewrite the source CSV files, and changes to the source files are reflected in the output only after a refresh.
Related
- Excel Goal Seek With Two Variables: Solver Options
- Excel Goal Seek With Multiple Inputs: Use Solver
- Excel Goal Seek Precision: Accuracy and Limits
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Calculate Row Percentage in ExcelTo calculate a row percentage in Excel, divide each value by the total of the values in that…
- Import Multiple Files into Excel: A Practical GuideYes. In Microsoft Excel for Microsoft 365 on Windows, use Data > Get Data > From File >…
- Google Sheets Meal Prep Planner: Set One Up EasilyYes. Google Sheets can work as a flexible meal prep planner for weekly menus, recipes, serving counts, shopping…
- How to Share a Private Calendar in OutlookTo share a private calendar in Outlook, open Calendar, choose Share Calendar, enter the recipient’s email address, select…
- Excel Heatmap Table: How to Create and Read OneIn Excel for Microsoft 365 on Windows, select the numeric cells in your table, then choose Home >…
- Excel Column Numbers: What A, Z, AA and XFD Mean in ExcelExcel columns have numerical positions even though their headings use letters: A is column 1, Z is 26,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.