Import CSV Into an Existing Excel Worksheet

How-to basics · Updated November 21, 2026

To import a CSV into an existing worksheet in Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From Text/CSV, select the file, review its preview, and choose Load > Load To. In the Import Data dialog, select Table and Existing worksheet, specify the destination cell, and select OK. Check the destination first: the imported table needs an unoccupied area and can replace data if it overlaps existing content.

What importing into an existing worksheet means

A CSV, or comma-separated values file, is a text file that stores rows and fields. It does not preserve Excel formatting, formulas, charts, or multiple worksheets. Importing one into an existing worksheet means placing its rows and columns at a chosen location in a workbook that already has a sheet, rather than creating a separate workbook for the CSV.

Excel’s import process normally loads the parsed data as a table. You can choose a starting cell, such as A1 or D5, on an existing sheet; Excel fills the area to the right and below it. The worksheet itself remains in the workbook, but cells in the output area must be available. A starting cell is not a way to insert rows into the middle of a populated range: make room first, or select a clear area.

Import is also different from appending. Loading a CSV below an existing list does not automatically make Excel combine the two datasets. The import creates its own output table. If the goal is one continuous dataset, use the append approaches described below.

Import the CSV with the Data tab

  1. Open the workbook and select the worksheet where the data should go. Decide on an empty starting cell and make sure the expected number of columns and rows will not collide with existing values, formulas, or tables.
  2. Select Data > Get Data > From File > From Text/CSV. Browse to the CSV, select it, and choose Import.
  3. Review the preview. Check that columns are split correctly, characters display properly, and the first row is treated as headers only if it really contains column names. Adjust the file origin or delimiter if necessary.
  4. For a straightforward import, open the arrow next to Load and choose Load To. In the Import Data dialog, select Table, then Existing worksheet. Enter a reference such as =Sheet1!$D$5, or use the range selector to choose the cell on the intended sheet. Choose OK.
  5. If the preview needs cleanup, choose Transform Data instead. In Power Query Editor, make changes such as setting column types or removing unwanted rows, then choose Home > Close & Load To and select the existing worksheet and destination in the dialog.

The reference in the dialog identifies the top-left destination cell; it does not specify a fixed-sized destination range. Excel expands the output to fit the imported data. If the workbook contains important content near that cell, choose another location or move the content before loading.

Check delimiters, encoding, and data types

The preview is worth checking before loading because a CSV is plain text, and Excel has to infer how that text should be interpreted. A comma is common as a field separator, but files created under some regional settings use semicolons. If every row appears in one column, or if values are split at the wrong places, change the delimiter in the preview rather than trying to repair the finished table cell by cell.

Quoted fields can contain commas without being split into separate columns. For example, a row containing a quoted city-and-region field may include a comma within that field. Excel’s CSV parser should respect standard quotation marks, but malformed quotes or a nonstandard export can produce an unexpected preview. If a field breaks incorrectly, inspect the source file and its delimiter and quote conventions.

Encoding affects accented letters and other characters. If names display as strange symbols, check the file-origin or encoding choice in the import preview; UTF-8 is a common encoding for exported CSV files. Data types matter too. Excel may interpret values as dates or numbers. A product code such as 00482 can lose its leading zeros if treated as a number. In Power Query Editor, select the relevant column and set its type to Text before loading when those zeros are meaningful. For dates, check that the day and month order matches the source data rather than accepting a plausible but incorrect interpretation.

Prepare the destination worksheet

Before loading, identify whether the destination is a normal blank range or an existing Excel table. A new imported table can be placed in clear space on the same worksheet, but it should not overlap another table or cells containing information you need. Excel may show an error or require another destination if the selected area is occupied. Do not assume that choosing an existing sheet means Excel will preserve every cell in the output footprint.

Consider what is around the destination, not just the first cell. If a CSV has six columns and thousands of records, a starting cell at D5 uses columns D through I and the rows below row 5. A note or calculation in that area could be overwritten or obstruct the table. Save the workbook before a substantial import, and consider using a new worksheet if the right-sized area is uncertain.

CSV files carry values and text, not the source workbook’s visual formatting. After loading, you can format the resulting table, adjust column widths, and add formulas elsewhere. Keep calculations outside the imported output when possible: refreshing an imported table can replace or resize its contents, so formulas placed inside its future footprint are vulnerable to being displaced.

Append rows instead of replacing or placing them beside data

If you already have a list and want the new CSV records at its bottom, a simple approach is to import the CSV into a temporary worksheet, verify the columns, and then copy the data rows into the first empty row of the existing list. If both ranges have the same column order and compatible types, copy only the data rows when the existing list already has its own headers. Copying the CSV headers again in the middle of the list can interfere with sorting, filtering, and summaries.

For a recurring workflow, Power Query can combine a query from the existing table with a query from the CSV. Use Data > Get Data to create or load the sources, then use the Power Query Editor’s Home > Append Queries command to stack rows from one table under the other. Choose the two queries, check that corresponding fields have compatible names and types, and load the combined result to a suitable destination. Appending aligns fields by column name, so consistent headers make the result easier to validate.

Do not load a query over the same range that supplies one of its input tables. Keep the source data and combined output in separate areas or worksheets. That separation helps prevent circular or confusing arrangements and makes it clearer which data is original and which table is the refreshed result.

Use copy and paste for a one-time transfer

For a small, one-time CSV, you can open the file in Excel, select the parsed cells, copy them, and paste them into the existing workbook. On Windows, use Ctrl+C and Ctrl+V; on Mac, use Command+C and Command+V. If the CSV opens with all content in one column, use Excel’s import workflow instead of assuming the clipboard will separate the fields correctly.

When opening a CSV directly, Excel may create a separate workbook. Copy the cells from that workbook and paste them into the destination workbook, then check the result before closing either file. Pasting values is useful when the destination needs to remain a regular range, but it does not create a refreshable connection to the source CSV. Importing through Get Data is generally preferable when the file will be replaced or updated and you want to refresh the imported table.

Common problems and practical fixes

  • All fields appear in one column: Reopen the import preview and choose the delimiter used by the file, commonly comma, semicolon, or tab. Check whether the source uses a regional delimiter.
  • Leading zeros disappear: Set the affected column to Text in Power Query before loading. Formatting a number to show zeros later may look right but does not restore the original text value.
  • Dates are reversed or misread: Set the column’s type using the correct locale in Power Query, or import it as text and convert it deliberately after checking the source convention.
  • Text has garbled characters: Change the file origin or encoding in the preview, especially when the CSV is UTF-8. Confirm the result with names or words known to contain accented characters.
  • Excel refuses the destination: Select a clear starting cell outside existing tables and populated cells. If the output is large, check the entire expected footprint, not only the top-left cell.
  • New rows do not appear after replacing the file: A query refreshes its source; it does not automatically find an arbitrarily renamed or moved file. Keep the source path stable, update the query’s source when it changes, and then choose Data > Refresh All.

Be cautious with CSV files from unknown sources. A CSV is not an Excel macro-enabled workbook, but its cell contents can still be misleading or unexpected. Review unfamiliar data and do not treat formula-like text as trustworthy instructions. Excel’s import preview lets you inspect fields before placing them in a workbook; use it instead of blindly opening a file when the source is uncertain.

Refresh an import when the CSV changes

Loading through Get Data usually creates a query and a table that can be refreshed. If the CSV is updated at the same location, choose Data > Refresh All to rerun the query. Depending on the query settings, you can also right-click the imported table and choose Refresh. A refresh updates the query output; it is not the same as adding the new file’s rows to manually maintained records.

Before relying on refresh, confirm the query points to the intended file and that the CSV’s column names and structure remain consistent. If a source file changes its headers or removes a field, the query’s steps may no longer work as expected. Check row counts and a few key values after refresh, especially for business-critical data. If each period arrives as a separate CSV, a folder-based Power Query process may be more appropriate than repeatedly replacing one file, but it requires a consistent file structure and deliberate setup.

Excel for Mac and Excel for the web

Menu availability and Power Query capabilities can differ by Excel version and platform. Excel for Microsoft 365 on Mac has Power Query features, but available connectors and the import experience may not match Windows exactly. If your Mac build offers the CSV import and load-destination options, use them to select an existing worksheet; otherwise, opening the CSV and copying its parsed cells into the workbook is a practical one-time alternative. Review the pasted columns and types afterward.

Excel for the web also has a different set of data-import features from the Windows desktop app, and a local CSV may not offer the same Load To dialog. For a one-off transfer, open the CSV where supported, copy its cells, and paste them into the workbook in the browser. If you need a repeatable query or cannot select the intended destination online, use Excel desktop and verify the workbook after saving it to OneDrive or SharePoint.

Frequently Asked Questions

Can I import a CSV into a worksheet that already has data?
Yes, if you choose a clear destination range on that worksheet. The imported table needs room to expand, so select an area that will not overlap existing values or tables. To add records to the existing list itself, append or copy the rows into its first empty row instead.

Will importing a CSV overwrite my worksheet?
It does not replace the entire worksheet just because you choose that sheet. However, the output occupies cells beginning at the selected location, so overlapping data can be blocked or affected. Choose an empty area and save a copy before a large or important import.

How do I import a CSV without losing leading zeros?
Use Data > Get Data > From File > From Text/CSV, choose Transform Data, and set the code column to Text in Power Query before loading. This preserves values such as 00073 as text instead of converting them to the number 73.

Can Excel add the CSV rows to the bottom of an existing table?
Not merely by selecting a cell below the table in the Load To dialog; that creates a separate output. For a quick one-time job, copy the CSV’s data rows below the existing records. For recurring imports, use Power Query to append compatible source tables and load the combined result separately.

Can I refresh the imported CSV later?
Yes, when it was loaded as a Get Data query and the source remains accessible. Choose Data > Refresh All after updating the source file. Refresh updates that query’s output; it does not automatically merge its rows with a separate manually maintained list.

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.