Import a CSV into an Existing Excel Workbook

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, open the workbook you want to keep, select Data > Get Data > From File > From Text/CSV, choose the CSV, then use Load To to place its data in an existing worksheet or a new worksheet. This imports the CSV without replacing the workbook; you choose where its rows and columns go.

Import a CSV with the Get Data command

The Get Data method is usually the safest choice because Excel previews the file before loading it. You can check how Excel has separated the columns, adjust the file origin or delimiter, and choose a destination in your workbook. The imported data is normally created as an Excel table and can be connected to the source file for later refreshes.

  1. Open the existing workbook in Excel. If you plan to load the CSV into a particular worksheet, select that sheet first so it is easy to choose a destination.
  2. Select Data > Get Data > From File > From Text/CSV, browse to the CSV file, and select Import.
  3. Review the preview. Check that fields appear in the right columns and that accented or non-English characters display correctly. If needed, change the file origin or delimiter in the preview.
  4. Select Load to accept Excel’s default destination, or open the arrow beside Load and select Load To.
  5. In the Import Data dialog, select Table, then select Existing worksheet and specify a blank starting cell, such as =$A$1, or choose New worksheet. Select OK.

The cell reference in the dialog identifies the upper-left corner of the imported results; it does not mean the CSV must begin in column A. For instance, selecting a blank cell such as D3 places the first imported field in D3 and fills down and to the right. The import may occupy many cells, so leave enough room below and beside the destination. If you choose New worksheet, Excel adds a sheet to the open workbook rather than creating a separate workbook.

Choose where the CSV data should go

Think about how the imported data will be used before picking a location. A new worksheet is a good option when the file is large, when you want to preserve the layout of existing sheets, or when you are not yet sure how the data should be combined. You can rename that sheet afterward and use formulas, charts, or other workbook features to refer to it.

Loading to an existing worksheet is useful when the workbook already has a designated input area or a report designed to use the CSV values. Select a clear starting cell outside any existing data table, formulas, notes, and merged cells. Imported results can expand well beyond the first row and column, so check the expected CSV dimensions rather than selecting a cell that merely looks empty. Do not load over information you need to keep.

Importing a CSV into a workbook does not automatically insert its rows into an existing Excel table. If you load the file beside the table, it is a separate result. For a simple one-time addition, you can copy the new rows and paste them into the table’s first empty row, then check that the table includes them. For repeatable combining, import both the existing table and the CSV into Power Query and use Home > Append Queries in the Power Query Editor; load the combined result to a suitable destination. Appending combines rows with matching columns, so inspect column names and order first.

Check data types before loading

A CSV stores text fields separated by delimiters; it does not preserve Excel formatting, formulas, cell colors, or number formats. During import, Excel tries to interpret values as dates, numbers, or text. That automatic interpretation is convenient for ordinary data, but can damage values whose appearance is important.

  • ZIP codes and product IDs: A value such as 00427 may be treated as a number and lose its leading zeros. Set that column to Text in Power Query if those zeros are part of the identifier.
  • Dates: A date such as 03/04/2026 can mean March 4 or April 3, depending on the date convention. Confirm the expected order and locale before accepting the conversion.
  • Long numbers: Account references or tracking codes may be rounded or displayed in scientific notation if Excel treats them as numeric values. Import identifiers as text when they are not used for arithmetic.
  • Decimal and thousands separators: A number written as 1.234,56 in one regional convention may not be read as intended under another. Check the preview and regional interpretation.

To control types, select Transform Data in the import preview to open Power Query Editor. Select a column and use the data type control on the Home or Transform tab to choose an appropriate type, such as Text, Date, or Whole Number. A type change is especially important for identifiers: formatting a number as Text after Excel has already removed its leading zeros cannot recover the missing characters. For sensitive columns, make the type choice before loading.

Confirm delimiters, encoding, and headers

Comma-separated values are commonly separated by commas, but CSV files may use semicolons or another delimiter, often because of regional settings or the way the file was exported. In the preview, check that each field has its own column. If an entire row appears in one column, select the correct delimiter. If a field containing a comma is enclosed in quotation marks, a properly structured CSV import recognizes that comma as part of the field rather than as a column break.

Also confirm whether the first row contains column headings. When headings are present, Power Query can use them as field names; when the first row is ordinary data, treating it as headers would remove that row from the data and use its values as labels. Column headings make later filtering, sorting, and combining easier, but they should be unique and meaningful.

If names or symbols appear as strange characters, check the file origin or encoding setting in the preview. UTF-8 is common, but exports can use other encodings. A wrong selection can make characters such as é or ñ unreadable even though the rest of the file looks normal. Correct the encoding before loading instead of trying to repair every affected cell afterward.

Refresh the import when the CSV changes

When you import through Get Data, Excel can retain a query connection to the CSV. If the source file is updated in the same location, select a cell in the imported results and choose Data > Refresh All to retrieve the latest data. You can also right-click inside the result table and choose Refresh. The query applies its saved import and transformation steps again, which is helpful for recurring reports.

A refresh updates the query output; it is not a general-purpose way to merge the changed CSV into manually edited cells. Avoid typing notes or formulas inside the imported output area because a refresh may replace or resize the results. Put commentary in separate columns or on another sheet, and use formulas that refer to the result table if you need calculations alongside it. If the CSV is moved, renamed, or stored in a location that is unavailable, the query may fail until its source path is corrected.

If you only need a one-time copy and do not want a connection to the file, you can use a different approach: open the CSV, copy its contents, and paste them into the existing workbook. That is straightforward, but it does not provide the same managed import steps or reliable refresh connection. Choose based on whether the data is a one-off or will be updated repeatedly.

Other ways to bring in a CSV

Opening a CSV directly in Excel is convenient when you simply want to inspect it. Excel usually opens it as a separate workbook, however, so it does not by itself add the contents to the workbook you already have open. You can then copy the required cells into the existing file, but take care to paste into the intended sheet and preserve any formulas or formatting already there.

Copy and paste is also useful for a small, one-time file. Open the CSV, select the data, copy it, switch to the existing workbook, and paste into a blank starting cell. If you need only the values and not source formatting, use a values-only paste option where available. Unlike a query, a pasted copy has no automatic relationship to the original CSV; future edits to the file will not update the pasted data.

On Excel for Mac, current Microsoft 365 versions include Power Query import features, but the available connectors and interface can vary by version. Look under the Data tab for Get Data or a text/CSV import command. If the relevant command is unavailable in your build, opening the CSV separately and copying its data into the workbook is a practical fallback. Excel for the web has different import and Power Query capabilities from the Windows desktop app; use the desktop app when you need the full Load To workflow or detailed control over query transformations.

Common import problems and how to fix them

  • Everything appears in one column: Reopen the import preview and select the delimiter used by the file. Do not split on commas blindly if the CSV uses semicolons or quoted fields.
  • Leading zeros disappear: Import the affected field as Text in Power Query, then load again. If the file has already been loaded as numbers, return to the original CSV so the original characters are still available.
  • Dates are reversed or inconsistent: Check the source’s date convention and set the column type using the correct locale before loading. A visually plausible date can still represent the wrong day and month.
  • Text looks corrupted: Change the file origin or encoding in the preview, then verify names and special characters before importing.
  • Existing content is affected: Cancel or remove the unintended result and import again to a genuinely empty area or a new worksheet. Before confirming Load To, consider the full size of the data and keep a backup if the destination workbook is important.
  • Refresh cannot find the file: Restore the CSV to its previous path or edit the query’s source so it points to the file’s new location. A query depends on access to its source.

If you make a mistake, Excel’s Undo command may reverse recent worksheet actions; on Windows use Ctrl+Z, and on Mac use Command+Z. Do not rely on Undo as a substitute for checking the destination: query refreshes and changes to external data connections do not always behave like ordinary cell edits. Saving a copy before a major import is a sensible precaution.

Frequently Asked Questions

Can I import a CSV into an existing Excel sheet without creating a new workbook?
Yes. Open the workbook first, use Data > Get Data > From File > From Text/CSV, and select Load To. Choose Existing worksheet and a blank starting cell, or choose New worksheet to add a sheet to that same workbook.

Will importing a CSV replace my existing workbook?
No. The import adds results to the workbook you have open. It can still affect cells if you choose a destination that overlaps existing content, so select an empty area or a new worksheet and check the destination before loading.

Can I add CSV rows to an existing Excel table?
Not merely by loading the CSV beside the table; that creates a separate result. For a one-time addition, paste the new rows into the table’s next available row. For a repeatable process, use Power Query to append the CSV data to a query of the existing table, then load the combined output.

How do I stop Excel changing numbers or dates in a CSV?
In the import preview, select Transform Data and set columns such as IDs, ZIP codes, and tracking numbers to Text. For dates and numbers, confirm the appropriate locale and data type before loading. Excel number formatting alone cannot restore characters already lost during conversion.

Will changes to the CSV update the imported worksheet automatically?
Usually not immediately. A Get Data import can be refreshed with Data > Refresh All, provided Excel can still access the source file. A copy pasted from an opened CSV has no refresh connection and must be copied again when the source changes.

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.