To import multiple CSV files into Excel for Microsoft 365 on Windows, put the files in one folder, then choose Data > Get Data > From File > From Folder. Select the folder and use Combine & Transform Data to append files with the same column layout into one table; use Power Query when you want a repeatable import that can be refreshed as files change.
Choose whether to combine files or keep them separate
Before importing, decide what you want the result to look like. If every CSV contains the same kinds of records—such as monthly sales with columns for date, product, and amount—you will usually want one combined table with all the rows. Power Query can append the rows and preserve a single set of column headings.
If each CSV represents a different subject or needs its own worksheet, import the files as separate queries or open each file and move its sheet into a workbook. Combining dissimilar files into one table can create many blank columns or mix unrelated fields, so it is not automatically the best choice just because the files are in the same folder.
- One table: Best when files have matching columns and you want to filter, sort, summarize, or analyze all records together.
- Separate worksheets: Best when the files contain distinct reports or need to remain independently viewable.
- One workbook per file: Best when you need to preserve separate deliverables rather than build a combined analysis.
Combine matching CSV files from a folder
The folder method uses Power Query, Excel’s built-in tool for connecting to, shaping, and refreshing data. Keep the files to be combined together in a dedicated folder. If possible, make sure they have the same column names and compatible data types. Avoid placing unrelated CSVs, old exports, or temporary files in that folder, because the query may include them too.
- In Excel, open a blank workbook or the workbook that will hold the result.
- On the Windows ribbon, select Data > Get Data > From File > From Folder.
- Browse to the folder containing the CSV files and confirm the selection.
- Review the file list. Choose Combine & Transform Data to inspect and shape the combined result in Power Query. If you are confident the files are consistent, the available combine-and-load option can load the result directly.
- In the combine process, check the example file and confirm that the correct delimiter and headers are detected. Choose the appropriate sheet or table-like data preview if prompted.
- In Power Query Editor, review the column names, data types, and rows. Select Home > Close & Load to load the result to a worksheet, or use the close-and-load options to choose a destination.
Power Query creates a query based on the folder and the transformations you apply. When new matching CSV files are added to that folder, use Data > Refresh All to update the result. Refreshing is not the same as automatically watching the folder: Excel does not necessarily update the table the instant a file arrives. Refresh after the source files have been added or changed.
Import CSV files individually
For files that should stay separate, or when you need to inspect each one before deciding what to do with it, connect to them one at a time. In Excel for Windows, choose Data > Get Data > From File > From Text/CSV, select a CSV, and review the preview. Choose Transform Data to open Power Query Editor, or choose Load to bring the data into Excel. Repeat for each file, giving each query a clear name.
To load each query onto its own worksheet, use the load options for the query and select a worksheet destination. You can also open a CSV in Excel and then move or copy its worksheet into a destination workbook: use the worksheet tab’s context menu and choose Move or Copy. A CSV itself can store only one flat table of text values, not multiple worksheets, formulas, or Excel formatting. Moving a sheet into an .xlsx workbook lets you organize the imported data there.
Double-clicking a CSV often opens it directly in Excel, which is convenient for a quick look but gives you less control over import settings. The import route is preferable when a file has unusual delimiters, encoding, or columns that Excel might otherwise interpret incorrectly.
What Power Query does when it combines files
When combining files from a folder, Power Query uses one file as an example and applies a transformation pattern to the other files. It then appends their records into a single result. The output can include a source file name column, which is useful for tracking where each row originated. If that information matters, retain the source name during transformation rather than deleting it.
The approach works best when the files share a stable structure. For example, four monthly exports with the same headings can be combined into a table containing all four months. If one file has an extra column, a renamed heading, or a different layout, the resulting query may have missing values or errors. Inspect the preview and the final output instead of assuming that every source file was interpreted identically.
Power Query does not have to alter the original CSVs. Its transformation steps describe how to prepare data for the workbook; the source files remain separate unless you deliberately edit or replace them outside Excel. That makes the folder method useful for repeatable reporting: keep a clean source folder, maintain the query in the workbook, and refresh when the inputs change.
Check delimiters, encoding, and data types
A CSV is plain text with values separated by a delimiter. The name means comma-separated values, but exports may use semicolons or tabs instead, depending on the software and regional settings. If the preview puts an entire row into one column, check the delimiter setting in the import preview or Power Query rather than trying to fix the worksheet by hand.
- Encoding: If names or symbols appear as garbled characters, choose the appropriate file origin or encoding in the import options. UTF-8 is common, but the correct choice depends on how the source file was saved.
- Dates: A date such as 04/05/2026 can mean different days under different regional conventions. Confirm the intended order before accepting automatic date conversion.
- Leading zeros: Postal codes, product codes, and account identifiers may look numeric but should often be treated as text. If Excel converts 00127 to 127, import or transform that column as text to retain the identifier exactly.
- Long numbers: Long identifiers can lose precision if treated as numeric values. If the value is an ID rather than a quantity, preserve it as text.
- Quoted commas: A value such as a company name containing a comma may be enclosed in quotation marks in a correctly structured CSV. Use the CSV parser and correct delimiter instead of splitting every row at each visible comma manually.
Automatic type detection is useful, but it is not infallible. Review the columns most likely to be misread before loading—especially dates, identifiers, and values with leading zeros. You can change a column’s type in Power Query by selecting it and using the data type control on the ribbon or in the column header.
Keep the import reliable and manageable
A few simple habits prevent many refresh problems. Store only intended input files in the source folder, and move completed or unrelated exports elsewhere. Use consistent column headings, and keep the meaning and format of each column stable from file to file. If the source system changes its export layout, update the query and verify the output before relying on the refreshed data.
Give the query and output table names that explain their contents, such as MonthlySalesImport, rather than leaving generic names. If you need to distinguish the records later, include a source file name or a date field in the output. Keep an untouched copy of source files when they are important, and avoid editing imported values in the query output as if those edits were part of the source: a refresh can replace the table with the results generated from the CSVs.
Also consider Excel’s worksheet capacity. A worksheet supports up to 1,048,576 rows and 16,384 columns. If the combined result exceeds the row limit, it cannot all be loaded to one worksheet; use Power Query’s connection or data model options where appropriate, or use a database or other data tool designed for larger datasets. Even below the limit, very large files can take time and memory to import.
Windows, Mac, and Excel for the web
The menu paths above are for Excel for Microsoft 365 on Windows. Excel for Mac includes Power Query capabilities, but available connectors and the exact interface can differ by release. Check whether your Mac version offers the folder connector under Data and Get Data. If it does not, import the CSVs individually with the text/CSV import option, or use a Windows version of Excel for the folder-combine workflow.
Excel for the web can open and edit many workbooks, but its data-import and Power Query capabilities do not match the full Windows desktop experience in every case. For a folder-based CSV import, set up or manage the query in supported desktop Excel, then use the web version for tasks it supports. A workbook that contains a query may also depend on source-file access and permissions when refreshed.
Common mistakes and how to fix them
- Unwanted files appear: Remove unrelated files from the input folder or filter the folder listing in Power Query by file name or extension.
- Some rows are blank or shifted: Check for inconsistent delimiters, extra header rows, or files with a different structure. Inspect the source files and adjust the query deliberately.
- Headings appear as data: Confirm that the first row is promoted to headers in Power Query and that each file uses the same header arrangement.
- Values change after refresh: Check automatic data type conversion, particularly for dates and identifiers. Set types intentionally and test the query after changing source files.
- Refresh cannot find the files: The folder may have moved, been renamed, or become inaccessible. Update the source path in the query settings or restore access to the original location.
A common misconception is that combining CSV files means merging them side by side. In Power Query, the folder-combine workflow generally appends compatible files vertically: rows from one file follow rows from another. Joining records side by side is a different operation that requires a shared key and a merge, and it should only be used when the columns represent related records that can be matched reliably.
Frequently Asked Questions
Can Excel combine multiple CSV files into one sheet?
Yes. In Excel for Microsoft 365 on Windows, use Data > Get Data > From File > From Folder, then combine the files. This is most reliable when their columns and layout match.
Can I import CSV files into separate worksheets?
Yes. Import each file as its own query and choose a worksheet destination, or open each CSV and move or copy its sheet into an .xlsx workbook. A CSV file itself cannot contain multiple worksheets.
Will new CSV files appear automatically after I add them to the folder?
No. The folder query can include eligible new files when refreshed, but you generally need to choose Data > Refresh All to update the workbook.
Why does Excel put the whole CSV row in one column?
The selected delimiter may not match the file. In the text/CSV preview or Power Query, choose the delimiter actually used by the export, such as comma, semicolon, or tab.
How do I stop Excel removing leading zeros?
Import the affected column as text instead of a number. Identifiers such as postal codes and product codes are usually better stored as text because arithmetic on them is not meaningful.
Related
- Excel Won’t Insert a Row? Causes, Fixes, and Workarounds
- Excel Print Area Greyed Out: Why It Happens and Fixes
- Excel Protect Sheet Greyed Out? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets COUNTIF With Multiple Ranges: How It WorksGoogle Sheets’ COUNTIF function accepts one range at a time, so to count matching values across separate ranges,…
- Key Inventory Spreadsheet: What to Track and ManageA key inventory spreadsheet is a register of the keys an organization owns or manages, where each key…
- Count Excel Without Blanks: COUNTA and Other MethodsTo count cells that are not blank in Excel, use =COUNTA(A2:A20), replacing A2:A20 with your range. COUNTA counts…
- Examples of Ratings in Excel: Scores, Stars, and RulesExamples of ratings in Excel include 1-to-5 customer scores, star displays, letter-grade categories, and color-coded performance scales. For…
- Compare and Merge Documents in Word: A Step-by-Step GuideTo compare two Word files, open Word and choose Review > Compare > Compare, then select the original…
- Combine Excel Files: Practical Methods and StepsTo combine Excel files with the same column layout, put them in one folder, then in Excel for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.