Excel Import Multiple CSV Files: Methods and Tips

How-to basics · Updated November 18, 2026

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, choose Combine > Combine & Transform Data, review the Power Query preview, and select Close & Load. This is usually the simplest repeatable method when the files have the same column structure.

Choose a method that fits your files

The right approach depends on whether the CSVs are alike and what you want to do with them. If each file has the same headers and represents more rows of the same kind of information, combine them into one table. For example, monthly sales exports with columns for Date, Product, and Amount can become a single table with a source-file column for traceability.

If the files have different purposes or different layouts, import them as separate queries or worksheets instead. A customer list and a product list are not usually useful as one appended table. You can also import one CSV at a time when you only need a quick, one-off result, but repeating that process for many files takes longer and makes updates harder.

  • Same columns, many files: use the folder connector and combine them.
  • Different datasets: import separately, then organize them in separate sheets or queries.
  • One-time, small task: import each file individually or copy data into a prepared workbook.
  • Recurring reports: use Power Query so you can refresh the combined result when new files arrive.

Combine CSV files from a folder with Power Query

Power Query is Excel’s built-in data import and transformation tool. It can read a group of files, apply a consistent set of cleanup steps, and append their records into one output. The folder method is especially useful because the query can be refreshed later rather than rebuilt from scratch.

  1. Put the CSV files you want to combine in a dedicated folder. Keep unrelated files out of it so they are not mistaken for part of the dataset.
  2. In Excel for Microsoft 365 on Windows, open the workbook that should hold the result and select Data > Get Data > From File > From Folder.
  3. Browse to the folder and select Open or OK. Check the file list shown by Excel before proceeding.
  4. Select Combine, then Combine & Transform Data. Excel uses a sample file to infer how to read the group and opens the Power Query Editor.
  5. Inspect the preview, confirm that the headers and columns are correct, make any needed changes, and select Home > Close & Load to send the result to Excel.

The resulting table normally contains records from all eligible files, with each file’s rows placed below the previous file’s rows. Power Query may also include a column identifying the source file. Keep that information if you need to trace an unusual value back to its original export; otherwise, you can remove it in the editor.

Prepare the folder and files before combining

Power Query works most predictably when the CSVs follow a consistent pattern. Ideally, every file has one header row, the same column names, and the same meaning and order for each field. A column called Date should contain dates in all files, for example, rather than dates in one file and notes in another.

File names can also help organize a recurring workflow. Names such as Sales-January.csv and Sales-February.csv are easier to recognize than export1.csv and export2.csv. The name itself does not determine whether the files can be combined, but it makes it easier to identify source files and spot an accidental duplicate.

  • Use a folder reserved for the files being combined; move archive copies and unrelated exports elsewhere.
  • Check that every file is a genuine CSV and is not an Excel workbook that was simply renamed.
  • Look for duplicate exports, blank files, or files with extra title rows before combining.
  • Decide whether the header names should match exactly, including spelling and punctuation.
  • Retain an untouched copy of the original files if the data is important or difficult to recreate.

If a file has an extra introductory line, a different header, or a changed column layout, the combine process may produce blank values, errors, or unexpected columns. You can often correct the issue in Power Query, but it is better to understand the difference before trusting the final table.

Check headers, delimiters, encoding, and data types

CSV means comma-separated values, but exports do not all use a comma as the field separator. Some use semicolons or tabs, particularly when regional settings or the exporting application call for a different delimiter. If the preview puts an entire row into one column, or splits values in the wrong places, check the delimiter setting in Power Query rather than assuming the file is corrupt.

Text encoding affects how Excel reads accented letters and other non-English characters. If names or symbols appear garbled, inspect the file’s encoding and choose the appropriate option during import. UTF-8 is common, but it is not safe to assume that every CSV uses it. A correct-looking preview is a useful check before loading a large set of files.

Pay particular attention to fields that look numeric but must remain text. Product codes such as 00427, postal codes, and account identifiers can lose leading zeros if Excel interprets them as numbers. Dates can also be ambiguous: 03/04/2026 could mean March 4 or April 3 depending on the date convention used by the source. In Power Query, select the relevant column and set an appropriate data type; for identifiers, Text is often the safer choice.

Do not assume that every value in a column has been interpreted correctly just because the table loaded. Review representative rows from different source files, including the first and last records and any file known to have unusual values. Correcting a data-type decision in the query is more reliable than repairing a few visible cells after the output has been loaded.

Transform and load the combined result

The Power Query Editor lets you clean the data before it reaches the worksheet. Typical changes include removing blank rows, renaming columns, filtering out unwanted records, changing data types, and removing columns that are not needed. These steps are saved as part of the query, so Power Query can apply them again when the data is refreshed.

For example, suppose each monthly CSV includes Date, Region, Item, Units, and Export Notes, but the report only needs the first four fields. Remove Export Notes in the query, set Date to a date type and Units to a numeric type, then load the result. If a future monthly file uses the same structure, the query can apply those saved transformations to its rows too.

Use Close & Load when the default destination is suitable. If you need to choose where the result goes, use Home > Close & Load > Close & Load To, where available, and select an appropriate destination such as a new worksheet or an existing location. A worksheet has a limit of 1,048,576 rows, so a combined dataset larger than that cannot fit in a single sheet. For large datasets, consider loading to the Data Model or using a database or other data-analysis tool, subject to your Excel version and available memory.

Import files separately or append existing queries

When files should remain distinct, import them one at a time through Data > Get Data > From File > From Text/CSV. Review the preview, then choose Transform Data to inspect or adjust the import in Power Query, or use Load when the preview is already suitable. Give each query a clear name so you can tell which source it represents.

If you already imported several files as separate Power Query queries and later decide they belong in one table, use Home > Append Queries or Home > Append Queries as New in the Power Query Editor. Append adds rows; it does not join values side by side based on a matching key. A merge is the kind of operation used to match related tables on a shared field, such as a product ID. Check the selected columns and resulting preview before loading.

Appending queries is useful when files have different cleanup requirements but eventually need a common output. For instance, one source may need a date correction and another may have an extra column. Transform each query as needed, then append them once their fields are aligned. If the structures differ, Power Query can produce a combined set of columns with blanks where a source does not supply a field, so verify that this is the intended result.

Refresh the query when new CSVs arrive

After a folder query has been loaded, place new files that follow the expected structure in the same source folder. In Excel, select Data > Refresh All to update the query and its output. Depending on the workbook and connection settings, a refresh may also be available from the query or table context menu.

Refreshing does not mean Excel will automatically notice every change at the moment it happens. It reruns the query when you request a refresh, or according to any refresh settings you have configured. The folder path is part of the query’s source, so moving the folder or opening the workbook on a computer that cannot access that location can cause refresh errors. If the source is on a shared drive or cloud-synced folder, confirm that the workbook user has access to it.

Keep the output table’s purpose clear. If you type manual notes directly into rows that Power Query controls, a refresh can rearrange or replace the query output and make those notes difficult to preserve. Store hand-entered annotations in a separate table and relate them to imported records using a stable identifier when possible.

Common problems and practical fixes

  • Only one column appears: check whether the file uses a delimiter other than a comma, and adjust the delimiter in the import settings.
  • Leading zeros disappear: change the affected field to Text in Power Query, then refresh and verify the displayed values.
  • Some columns are blank: compare the headers across files. Slightly different names or missing fields can create separate columns or null values.
  • Dates are reversed or misread: check the source’s date convention and select the correct type or locale before loading.
  • Refresh fails: confirm that the folder still exists, the files are accessible, and no file has an unexpected format or temporary extension.
  • The combined table contains repeated rows: check for duplicate source files or exports. Power Query appends files; it does not automatically know which repeated records are duplicates.

A common misconception is that combining files deletes or merges the originals. The folder-combine query reads the source files and creates a combined result in the workbook; it does not ordinarily rewrite the CSV files. Another misconception is that the source files must be identical in every respect. Small differences can be handled, but predictable headers and data types make the output substantially easier to trust.

Excel on Mac and other alternatives

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac includes Power Query capabilities in current Microsoft 365 releases, but available connectors and the interface can vary by version and update channel. Check the Data tab for the available Get Data or Text/CSV options; do not assume that the Windows From Folder connector is present in every Mac build. If it is unavailable, importing files individually and appending queries may be an option, or you can use a supported Windows installation for the folder workflow.

Excel for the web has different data-import capabilities from the Windows desktop application, and some Power Query authoring or refresh features may not be available there. If the workbook depends on a folder-based query, create and maintain it in a supported desktop version, then check the web version’s current support before relying on browser-based refresh.

For a few small files that will never change, copying and pasting rows into one worksheet can be adequate, provided you keep the headers consistent and check for formatting problems. For repeated work, Power Query is generally more maintainable. For very large, frequently updated, or multi-user datasets, a database or a dedicated data pipeline may be more suitable than a workbook.

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 & Transform Data. Load the query result to a worksheet to create one combined table.

Do all the CSV files need the same columns?
They should have the same headers and compatible data types for the cleanest result. Power Query can work with some differences, but missing or differently named fields may create blank values or additional columns that need review.

Will Excel include CSV files added to the folder later?
They can be included when you refresh the folder query, as long as they are in the queried folder and fit the query’s expected file pattern. Use Data > Refresh All and inspect the result after adding files.

Can I import each CSV into a separate worksheet?
Yes. Import each file separately with Data > Get Data > From File > From Text/CSV, then load each query to a suitable worksheet. This is better when the files represent different datasets rather than additional rows of one dataset.

Why did Excel remove zeros from my CSV codes?
Excel likely interpreted the codes as numbers. Import the affected column as Text in Power Query so values such as 00427 remain text rather than becoming 427.

What happens to the original CSV files?
The query reads them as its source and loads a result into the workbook; combining does not normally alter the source files. Keep backup copies when the data matters, and avoid changing or moving the source folder if you want refresh to keep working.

Related

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.