Import a CSV File into Excel: Steps, Settings, and Fixes

How-to basics · Updated November 18, 2026

To import a CSV file into Excel for Microsoft 365 on Windows, open a workbook, select Data > From Text/CSV, choose the file, check the delimiter and preview, then select Load. For more control over dates, leading zeros, or other column types, choose Transform Data first and set those columns before loading.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for storing rows and columns of data: commas usually separate fields, and line breaks separate records. A CSV can be opened by many spreadsheet programs, but it does not store Excel formatting, formulas as working formulas in a dependable workbook structure, multiple worksheets, charts, or cell styles. It is a data exchange format, not a complete Excel workbook.

Despite the name, a CSV does not always use commas. Depending on the program or regional settings that created it, the separator may be a semicolon, tab, or another character. The text encoding also matters: UTF-8 is common, but a file saved with another encoding can display accented letters or non-Latin scripts incorrectly unless Excel reads it with the right origin setting.

Import with Data > From Text/CSV

This method is usually the safest choice because Excel previews the file before putting it in the sheet. It also lets you choose how columns are interpreted instead of accepting every automatic conversion.

  1. Open the workbook where the data should go. To start a separate workbook, open Excel and create a blank one.
  2. Select Data > From Text/CSV on the ribbon.
  3. Find and select the CSV file, then choose Import.
  4. In the preview, check that the columns are separated correctly. Choose the appropriate delimiter if the preview shows everything in one column or splits fields incorrectly.
  5. Check the file origin or encoding if characters look wrong. For a UTF-8 file, choose the UTF-8 option if Excel has not detected it correctly.
  6. Select Load to insert the data, or Transform Data to review and adjust it in Power Query first.

Excel commonly loads the imported table into a new worksheet in the current workbook. If you need a specific destination, use the load options available from the import workflow; after loading, you can also move or copy the resulting table. Confirm the destination before importing a large dataset so it does not overwrite information you meant to keep.

Choose between Load and Transform Data

Load is suitable when the preview is correct and automatic type detection has not damaged the data. It is quick for straightforward exports, such as a list of product names and quantities. Transform Data opens Power Query Editor, where you can inspect column names, remove unwanted rows, change data types, and select a destination before the data reaches the worksheet.

Use the editor when values that look like numbers are actually identifiers, or when dates and decimal separators need attention. For example, a product code such as 004218 is not a quantity: if Excel turns it into the number 4218, the original leading zeros are lost. In Power Query, select that column and set its data type to Text before loading. Similarly, choose Text for postal codes, account IDs, and other codes whose digits are not intended for arithmetic.

Power Query can also be useful when you receive a recurring export with the same structure. If you keep the query and replace or update the source file, you may be able to refresh the imported results instead of repeating every cleanup step. Refresh behavior depends on the file path and query settings, so keep the source file in a stable location and check the query after changing its name or folder.

Check delimiters, encoding, and regional formats

A preview that puts an entire record into one column usually indicates that Excel has selected the wrong delimiter. In the import preview, try the separator used by the source file. A semicolon-separated file may appear as one column if Excel expects commas. Conversely, choosing a comma when the source uses semicolons can split values in the wrong places.

Quoted fields can contain punctuation without creating extra columns. For instance, a CSV row may contain a field like "Portland, Oregon"; the comma inside the quotation marks belongs to the field, not the separator. A correctly configured CSV reader recognizes the quotation marks. If the preview still splits such a field, check the delimiter and text qualifier options rather than manually deleting punctuation.

Dates and decimal values can also vary by region. A date such as 03/04/2026 could mean March 4 or 3 April, while a decimal may use a comma in one locale and a period in another. Do not assume Excel has interpreted ambiguous values correctly. In Power Query, set the data type and, where needed, use the option to change type using a locale that matches the source data. Compare a few known values with the original export before relying on the imported column.

Open a CSV directly or import it into a workbook

For a quick look at a simple file, you can open it directly: in Excel, use File > Open and browse to the CSV, or open the file from File Explorer if CSV files are associated with Excel. Excel displays the data in a worksheet, but it may automatically convert text that resembles dates or numbers. This route is convenient, but it gives you less opportunity to inspect conversion choices before opening the data.

Use Data > From Text/CSV when you want the file inside an existing workbook, need to choose an encoding or delimiter, or must protect identifiers and dates from automatic conversion. On Windows, the keyboard shortcut to open a file in Excel is Ctrl+O; on Mac, use Command+O. The shortcut opens a file but does not replace the import preview workflow.

Excel for Mac also provides text-import and Power Query options in supported Microsoft 365 builds, though the available connectors and ribbon labels can differ by version. Look under the Data tab for Get Data or a text/CSV import command. If that command is unavailable, opening the CSV and using Data > Text to Columns can split data already placed in one column, but it is not as convenient for setting import types in advance. Excel for the web has different import capabilities; if its interface does not offer the needed text/CSV options, use the desktop app.

Prevent common import problems

  • Everything appears in one column: import again and select the actual delimiter, or use Data > Text to Columns for data already opened in a sheet.
  • Leading zeros disappear: set the relevant column to Text in the import or Power Query step. Changing a number format after the zeros have been removed may not restore the original value reliably.
  • Dates are reversed or changed: check the source convention and set the column type with the correct locale before loading.
  • Accented characters look garbled: select the correct file origin or encoding, commonly UTF-8 when that is how the CSV was saved.
  • Columns shift unexpectedly: inspect quoted fields and confirm the delimiter. A comma inside a quoted address should remain part of that field.
  • Numbers display with unexpected decimals: check whether the source uses a comma or period as the decimal mark and choose a matching locale.

After an import, compare the row count and a few representative records with the source. Check the first and last rows, columns with codes, and values containing commas or quotation marks. For a critical dataset, keep an unchanged copy of the original CSV so you can compare it if a conversion or cleanup step produces an unexpected result.

Save the result as an Excel workbook

A CSV file cannot preserve Excel-specific workbook features such as multiple worksheets, formatting, formulas, or Power Query connections. After importing, save the working copy as an Excel workbook: select File > Save As, choose a folder, and select Excel Workbook (*.xlsx) as the file type. The CSV can remain unchanged as the original source.

If you save the sheet back as CSV instead, Excel will warn that some workbook features may be lost. A CSV normally represents a single flat dataset, so it is not a suitable format for preserving several sheets or formatting. Keep the .xlsx version for continued editing, and export a fresh CSV only when another system specifically needs that format.

Safety and data handling

CSV files are plain text, but opening one in a spreadsheet can cause values to be interpreted as dates, numbers, or formulas. Be cautious with files from unknown sources, especially if cells begin with characters such as an equals sign and contain unfamiliar formula-like content. Do not assume a CSV is harmless simply because it has no macros. Importing questionable fields as text can help prevent unintended interpretation, and you should review unexpected content before using it.

Also consider where sensitive information is stored. A local import into Excel does not require uploading the CSV to a separate online converter. If the file contains personal, customer, or confidential business data, follow your organization’s storage and sharing rules, and avoid sending it to tools or services that are not approved for that data.

Frequently Asked Questions

Why does Excel put my CSV data in one column?
Excel may be using a different delimiter from the one in the file. Use Data > From Text/CSV and choose the correct separator in the preview. For data already in the worksheet, Data > Text to Columns can split it.

How do I keep leading zeros when importing a CSV?
Set the column to Text in the import or Power Query steps before loading it. This is important for codes such as 004218, which should not be treated as a number for calculation.

Can I import a CSV into an existing Excel workbook?
Yes. Open the workbook first, select Data > From Text/CSV, choose the file, and load the data. Check the load destination so the imported table lands where you expect.

Does importing a CSV change the original file?
Importing normally brings a copy of the data into Excel; it does not edit the source CSV. Save your workbook as .xlsx if you want to retain Excel features and keep the original CSV as a separate source file.

Can Excel import a semicolon-separated CSV?
Yes. In the import preview, select semicolon as the delimiter. The CSV extension does not guarantee that commas are the separator, so confirm the preview before loading.

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.