Excel Import CSV Into a Sheet: Steps, Options, and Fixes

How-to basics · Updated November 19, 2026

To import a CSV file into an Excel sheet, select Data > From Text/CSV, choose the file, check the delimiter and preview, then choose Load. To place the imported data in a particular existing worksheet, choose Load To and specify the destination cell.

Import a CSV with the Data tab

In Excel for Microsoft 365 on Windows, the Data tab provides the most dependable way to bring in a CSV, especially when the file contains dates, identifiers, unusual characters, or more than a few rows. The import preview lets you check how Excel is interpreting the file before it becomes worksheet data.

  1. Open the workbook where you want the data, or create a new workbook.
  2. Select Data > From Text/CSV. If your ribbon shows the grouped commands, use Data > Get Data > From File > From Text/CSV.
  3. Browse to the CSV file and select Import.
  4. In the preview, check that columns are divided correctly and that names, dates, and numbers look as expected. If needed, choose a different delimiter or file origin.
  5. Select Load to put the data into a new worksheet, or use the arrow beside it and choose Load To to choose a destination.

A CSV is plain text arranged in rows and fields, so the preview is more than a formality: it is where you can catch interpretation problems before they affect the worksheet. If the preview is correct and you do not need to choose a specific location, the regular Load option is the simplest route.

Put the imported data in an existing sheet

When you need the CSV in a particular place in an existing worksheet, use Load To rather than opening the file and copying cells by hand. In the import preview, open the menu beside Load and select Load To. Choose Table, then select Existing worksheet and identify the top-left destination cell, such as Sheet1!$A$1. Confirm the dialog to load the data there.

The precise dialog options can depend on the Excel build and how the import was started. If you have already opened the query in Power Query Editor, use Home > Close & Load or its dropdown and select Close & Load To to choose where the result goes. A table is usually the useful choice for a CSV because it gives the imported range headers and table behavior.

Before loading, make sure the destination area is clear. Imported rows and columns can occupy a large rectangular range, and loading over existing content risks replacing or conflicting with that data. If you need to preserve neighboring information, choose an empty area or a new worksheet, then move or reorganize the data after checking the import.

Check delimiters, encoding, and the preview

CSV means comma-separated values, but a file may use a different separator. Some systems create semicolon-delimited files, and tab-delimited text may also be supplied under a CSV-like workflow. In the preview, set the delimiter that matches the file. If you choose the wrong one, a row that should fill several columns may appear in a single column, or text may split at the wrong places.

Text fields can contain punctuation, including commas. A correctly formatted CSV can enclose such a field in quotation marks so the comma remains part of the field rather than acting as a separator. If the preview still splits the value incorrectly, check the delimiter and text qualifier settings instead of immediately editing the worksheet. The source file may also have inconsistent quoting or separators that need correction.

File origin controls how Excel reads text characters. If names or symbols appear as question marks or garbled characters, try the appropriate encoding in the import preview. UTF-8 is common for modern exports, but the correct choice depends on how the CSV was saved. Checking this before loading can prevent character damage that is harder to diagnose after the data is in the sheet.

Protect identifiers, dates, and other data types

CSV files do not preserve Excel cell formatting or declare a reliable type for every value. Excel may infer that a field contains numbers or dates, then convert it as it imports. That can be helpful for ordinary quantities, but harmful when the characters are identifiers rather than values for calculation.

  • Postal codes and account numbers: A value such as 00127 can lose its leading zeros if treated as a number. Set the relevant column to text during import when those zeros matter.
  • Long numeric identifiers: Very long digit strings may be displayed in scientific notation or lose precision if interpreted numerically. Treat identifiers as text.
  • Dates: Dates such as 03/04/2026 are ambiguous: they can mean March 4 or April 3 depending on the date convention. Confirm the intended locale and interpretation instead of assuming the display is correct.
  • Mixed columns: A column with numbers and text may not behave consistently if Excel guesses its type. Review the preview and, when necessary, transform the column to text or another suitable type.

For more control, choose Transform Data to open Power Query Editor before loading. There you can inspect columns and change data types, remove unwanted rows, or split a column. A useful habit is to compare a few known source values with the imported result, especially leading zeros, dates near the beginning of the file, and long codes.

Opening a CSV versus importing it

Double-clicking a CSV or using File > Open is quick when you only need to view a straightforward file. Excel opens the text as a workbook-like grid, usually placing the values into columns based on its interpretation of the CSV. This route is convenient, but offers less opportunity to review import settings first and can make automatic conversions easy to miss.

Use Data > From Text/CSV when you need to control the delimiter, encoding, data types, or destination sheet. It also creates a query connection that can be refreshed, which is useful when a new version of the same source file will arrive later. Opening a CSV directly is reasonable for a one-time look at simple data, provided you verify any values that Excel might reinterpret.

In either case, a CSV itself cannot hold multiple worksheets, Excel formulas, cell colors, or workbook features. It stores rows of text fields in a file format, not the full structure of an Excel workbook. Importing it into an existing workbook does not mean the original CSV will acquire those workbook features; they belong to the Excel file you save.

Refresh an import when the source changes

An import made through Power Query can be refreshed after the CSV changes. If the source file stays in the same location and retains the same name and general structure, select a cell in the loaded table and use Data > Refresh All, or right-click the table and choose Refresh when that option is available. Excel reruns the query and updates its output.

Refresh is not the same as importing an unrelated replacement file. If the CSV moves or is renamed, the query may report that it cannot find the source. Use Data > Queries & Connections to locate the query and edit its source, or create a new import if the replacement has a different layout. Before refreshing, consider whether the updated result will still fit safely in its destination area.

A loaded query result is managed as imported output. Avoid typing permanent notes or unrelated values inside the table if a refresh could replace the results. Put commentary outside the output range, or keep it on a separate worksheet, so a future update does not create a conflict.

Common import problems and practical fixes

  • Everything appears in one column: Reopen the import through the Data tab and select the separator actually used in the file. Do not assume every file uses commas.
  • Leading zeros disappear: Import the affected field as text. Formatting the cell as Text after zeros have already been removed will not restore the original digits; reimport from the source.
  • Dates are reversed or unexpected: Confirm the date convention used by the source and use the appropriate locale or transform the column before loading. Check the underlying source text if the date is ambiguous.
  • Accented letters look wrong: Try the correct file origin or encoding, commonly UTF-8 for modern exports, and inspect the preview again.
  • Values do not line up under headers: Check whether fields contain quoted separators, whether rows have inconsistent numbers of fields, and whether the first row is being treated as headers as intended.
  • Excel changes a long number: Reimport that field as text. If Excel has already rounded or altered a long numeric value, changing its display format afterward cannot recover the lost digits.

When an error is difficult to isolate, open the CSV in a plain-text editor and inspect a few rows. This helps distinguish a problem in Excel’s interpretation from a problem in the source file itself. Make a copy before editing the source, and retain the original if the data is important.

Excel for Mac and Excel for the web

On Excel for Mac, the available Power Query and text-import features depend on the Excel release and update channel. Current Microsoft 365 versions include Power Query capabilities, but the ribbon layout and available connectors can differ from Windows. Look on the Data tab for text/CSV or Get Data options; if the Windows path described above is not present, use the import options available in your Mac version and check its preview before loading. Keyboard shortcuts and dialog wording can also differ, so the Windows steps should not be assumed to match exactly.

Excel for the web may offer fewer import and query-editing controls than the desktop app, and availability can change. For a file that needs careful encoding, type, or destination choices, use the desktop Excel application. Once data is in an Excel workbook, it can be opened in the browser for ordinary review and collaboration, subject to the workbook features supported there.

Frequently Asked Questions

How do I import a CSV into an existing Excel sheet?
Choose Data > From Text/CSV, select the file, then use the menu beside Load and choose Load To. Select Existing worksheet and specify an empty destination cell.

Why does my CSV open in one column in Excel?
Excel may be using a different delimiter from the one in the file. Import it from the Data tab and choose the correct separator in the preview, such as a semicolon or tab instead of a comma.

How do I stop Excel from removing leading zeros from a CSV?
Import the relevant column as text before loading. If the zeros have already disappeared, format changes cannot restore them; import again from the original CSV with the column treated as text.

Can I import a CSV without changing the original file?
Yes. Importing reads the CSV into Excel; it does not require you to edit the source file. Save the result as an Excel workbook if you want to keep the imported data, worksheet formatting, or other workbook features.

Will Excel automatically update the sheet when the CSV changes?
A query-based import can be refreshed, but it does not necessarily update the sheet immediately when the source file changes. Use Data > Refresh All, and make sure the source remains available at the location the query expects.

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.