How to Import CSV to an Existing Excel File

How-to basics · Updated November 21, 2026

To import a CSV into an existing Excel workbook in Microsoft 365 for Windows, open the workbook, choose Data > Get Data > From File > From Text/CSV, select the CSV, then use Load To and choose an empty destination on the worksheet. For repeatable imports, Power Query is usually the safest option; for a one-time transfer, you can also open the CSV and copy its data into the workbook.

What importing a CSV actually does

A CSV, or comma-separated values file, stores rows of plain text separated by delimiters. It can contain values such as names, dates and amounts, but it does not preserve Excel formatting, formulas, charts, multiple worksheets or workbook features. Importing it adds the CSV’s data to an Excel workbook; it does not turn the CSV itself into a fully formatted Excel sheet.

The distinction matters because “existing Excel file” can mean two things: adding the CSV to a workbook that already has other sheets, or adding its rows to a particular existing data table. The first is straightforward: load the CSV onto a new sheet or an unused part of an existing sheet. The second needs more care. Excel does not automatically recognize that new CSV rows should be appended to an existing table just because the columns look alike.

Before starting, consider whether the CSV is a one-time delivery or a file that will be replaced with updated data regularly. That choice affects whether you should simply copy values or create a query that can be refreshed.

Choose the right import method

  • Power Query: Best when you want to control column types, clean the data, repeat the import, or combine it with other sources. It creates a query that can be refreshed.
  • Open and copy: Handy for a small, one-time import. Open the CSV, copy its cells, switch to the existing workbook and paste them into a suitable location.
  • Move or copy a sheet: Useful when you want to bring the CSV’s entire opened sheet into another workbook. In the CSV workbook, right-click its sheet tab, choose Move or Copy, select the destination workbook and confirm.

For an important or recurring dataset, Power Query is generally preferable because it makes the import process explicit. Copy and paste is simpler, but it is easy to paste into the wrong column, omit rows, or lose track of which file supplied the values.

Import the CSV with Power Query

These steps apply to Excel for Microsoft 365 on Windows. Keep the existing workbook open, and make sure the CSV file is saved somewhere accessible.

  1. In Excel, open the workbook that should receive the data. Select the Data tab.
  2. Choose Data > Get Data > From File > From Text/CSV, then browse to and select the CSV.
  3. Review the preview. Check that the delimiter separates the fields into the intended columns and that the first row is treated as headers if it contains column names.
  4. If the preview looks correct, open the Load menu and choose Load To. If the file needs cleaning or type adjustments, choose Transform Data instead; in Power Query Editor, make the changes and then use Home > Close & Load To.
  5. In the Import Data dialog, select Table and Existing worksheet. Specify an empty starting cell, such as =$A$1 if that cell is blank, or use the cell-picker button to select a destination.
  6. Confirm the destination and click OK. Excel creates a table containing the imported results at that location.

Do not choose a starting cell inside another Excel table or over data you need to keep. Leave enough blank space for the import to expand, including when a later refresh brings in more rows or columns. If you prefer to keep the original workbook layout untouched, load the results to a new worksheet instead.

Check delimiters, headers and column types

CSV files are not always comma-delimited. Depending on how a system created the file and on regional settings, fields may be separated by commas, semicolons, tabs or another character. If the preview shows every value in one column, or splits a value in the wrong place, select the correct delimiter in the import preview or transform the data before loading.

Quoted values can contain delimiters without being split into separate fields. For example, a field containing "Portland, Oregon" should remain one value when the CSV’s quoting is interpreted correctly. If columns appear shifted, check the delimiter and text-qualifier settings instead of immediately editing the source data.

Also inspect how Excel interprets types. A product code such as 004812 is an identifier, not necessarily a number; if treated as numeric, its leading zeros may disappear. 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 Editor, select a column and set an appropriate data type, such as Text for codes or Date for dates, before loading. Check several records against the source system if the format is uncertain.

For characters that display incorrectly, such as accented letters, check the file encoding. UTF-8 is common, but a CSV exported by an older or specialized system may use a different encoding. The import preview can help reveal a mismatch before the data is loaded.

Add CSV rows to an existing table

If the goal is to extend a table already in the workbook, simply loading the CSV beside or below it does not necessarily merge the data. A Power Query result is its own output table. It does not automatically insert new rows into a separate table that you have been maintaining by hand.

For a repeatable combined dataset, bring both sources into Power Query: the existing Excel table and the CSV. You can select the existing table and choose Data > From Table/Range to create a query for it, and import the CSV as another query. In Power Query Editor, use Home > Append Queries to stack rows from tables with matching columns. Check that corresponding fields have compatible names and types, then load the combined query to a new sheet or an empty destination.

Appending is different from merging. Append adds rows from one table beneath another; merge joins tables using matching key columns, much like looking up related information. If the CSV contains updates to existing records rather than entirely new rows, decide how to identify duplicate keys and which source should take precedence. A blind append can create duplicate records.

When a query output is refreshed, Excel rebuilds that output from its sources. Avoid typing manual corrections directly into the query’s result table: those edits may be replaced on refresh. Put durable corrections into the source data or into explicit Power Query transformation steps.

Common import problems and practical fixes

  • Everything lands in one column: Reopen the CSV import and choose the delimiter that matches the file. Do not assume every CSV uses commas.
  • Leading zeros disappear: Set identifier columns to Text in Power Query before loading. Formatting a number as text after the zeros have been removed cannot reliably restore the original code.
  • Dates or decimals change: Confirm the source’s locale and conventions, then set the column type deliberately. A decimal comma or day-first date can be interpreted differently from the computer’s regional format.
  • Existing data is in the way: Load to a blank area or a new sheet. A query table needs room to occupy its output range and may not be able to expand through existing content.
  • Some characters look wrong: Check the encoding, especially for accented or non-Latin text, and inspect the preview before loading.
  • Refresh cannot find the file: The query may point to a file path that has changed or is unavailable. Keep the source in a stable location, or update the query’s source when the CSV moves.

For a very large CSV, the worksheet limit is 1,048,576 rows and 16,384 columns. If the file exceeds the worksheet’s capacity, it cannot all be loaded as a normal sheet table; filter or aggregate it in Power Query, or use an appropriate data-model workflow.

Refresh, save and protect the workbook

After a Power Query import, save the destination as an Excel workbook, typically .xlsx, to retain its sheets, tables, query connection and other workbook features. A CSV file cannot hold all of those features; saving an Excel workbook as CSV retains only the active sheet’s values and discards workbook structure and much of its formatting.

If you replace the source CSV with a newer file at the same path and keep its structure compatible, you can update the query using Data > Refresh All. If the CSV is saved under a different name or location, the query may need its source path updated. Renaming columns or changing their layout can also require adjustments to query steps.

Keep an unchanged copy of the original CSV when the source data is important. That gives you a reference if a later import changes types, omits fields or produces unexpected results. For shared workbooks, tell other users where the source file lives and whether they need access to it to refresh the query.

Excel on Mac and Excel for the web

Excel for Mac has Power Query features in supported Microsoft 365 versions, but connectors, availability and menu labels can differ by release. Look under the Data tab for Get Data or Power Query options; if the text/CSV connector or destination controls are not available in your build, use Excel for Windows or open the CSV and copy its data into the workbook. Menu differences should not change the key checks: choose the right delimiter, verify column types and place results in an empty range.

Excel for the web can open and edit workbooks, but the desktop app is the more dependable choice for configuring a text/CSV query and its load destination. If a workbook already contains a query, refresh behavior in a browser can depend on the source and supported connection features. Use the desktop app when you need to create or troubleshoot the import.

Frequently Asked Questions

Can I import a CSV into an existing Excel sheet without creating a new sheet?

Yes. In the Import Data dialog, select Existing worksheet and choose a blank starting cell. Leave enough room for the result and avoid placing it over an existing table or data you need to retain.

Will importing a CSV overwrite my existing Excel data?

It should not be treated as a safe way to overwrite or update existing records. Choose an empty destination. If you want to replace a dataset, first make a backup and deliberately clear or replace the relevant output rather than loading over valuable cells.

How do I add new CSV rows to an existing Excel table?

For a refreshable workflow, import the CSV and connect the existing table to Power Query, then append the two queries and load the combined result. For a one-time task, copy only the new rows and paste them below the table after checking column order and duplicates.

Why does Excel put my CSV data in one column?

The selected delimiter may not match the file. In the Text/CSV preview, choose the actual separator, which could be a comma, semicolon or tab. Also check whether quoted text is being handled correctly.

Can I refresh the imported CSV later?

Yes, if you imported it as a Power Query connection. Keep the source file at the expected location and choose Data > Refresh All. If the file moves or its structure changes, update the source or query steps as needed.

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.