Excel Import CSV: Open Comma-Separated Files Correctly

How-to basics · Updated November 19, 2026

Yes. To import a comma-separated CSV file in Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From Text/CSV, choose the file, check that the preview uses a comma as the delimiter, and select Load. This import route gives you more control than simply opening a CSV, especially when the file contains dates, leading zeros, or text with commas.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for organizing information into rows and fields: commas commonly separate fields, and line breaks commonly separate rows. A basic file might look like this:

Name,City,Order total
Amina,Denver,42.50
Luis,Miami,18.00

The first row often contains column headings, but that is a convention, not a requirement. CSV is not an Excel workbook format. It does not preserve worksheet formatting, charts, multiple tabs, or Excel formulas as formulas. When Excel saves a sheet as CSV, it saves the active worksheet’s data as text; formula cells are represented by their calculated values, and workbook features are not retained.

Although the name says comma-separated, CSV files do not all use identical rules. Some are created with semicolons or tabs between fields, often because of regional settings or the application that exported the data. A CSV extension alone does not guarantee that commas are the correct delimiter.

Import a CSV using Excel’s data import tools

On Windows, the From Text/CSV command lets you inspect how Excel interprets a file before putting the data in a worksheet. Use these steps:

  1. Open the workbook where you want the data, or start a blank workbook.
  2. Select Data > Get Data > From File > From Text/CSV.
  3. Browse to the CSV file and select Import.
  4. In the preview, check the delimiter, file origin or encoding, and the way the columns appear.
  5. Select Load to place the data in a worksheet. Select Transform Data first if you need to adjust columns or data types in Power Query.

The preview is useful because it can reveal a problem before it spreads through the workbook. If a line that should form five columns appears in one column, check the delimiter. If an address such as 12 Main Street appears in the wrong field, check whether the source uses a different separator or has inconsistent quoting.

Excel’s Power Query import can also be refreshed in some workflows. If the source file changes and the workbook connection is set up to use that file, a refresh can update the imported table. This is convenient for recurring reports, but it does not mean every CSV opened by double-clicking is automatically linked for future updates.

Opening a CSV directly versus importing it

For a quick look at a simple file, you can open it directly in Excel using File > Open or the Windows File Explorer. Excel will try to divide the text into columns. What you see can depend on the file’s structure and regional settings, so direct opening is not always the best choice when the data must be interpreted precisely.

Choose the import command when you need to control the delimiter, encoding, or column types. This is particularly important for exported customer lists, product codes, financial reports, and data that contains dates. Direct opening is often adequate for a small, uncomplicated file that already displays correctly and does not contain values Excel might reinterpret.

On Mac, Excel also supports opening CSV files, and Microsoft 365 versions with Power Query offer text and CSV import options. The available commands and their exact placement can vary by Excel version and update. Excel for the web can work with CSV files too, but its interface and import controls are not identical to the Windows desktop workflow. If delimiter or type control is essential, use the desktop import preview where available.

Choose the correct delimiter

In the import preview, the delimiter tells Excel what separates one field from the next. Select Comma for a conventional comma-separated file. If the preview has the wrong number of columns, try another delimiter only if it matches how the source file was created. Common alternatives include a semicolon, tab, or another specified character.

A comma inside a properly quoted field is not a separator. For example, a CSV row might contain:

Company,Address,Revenue
Northwind,22 Market Street, Suite 4,1250

That line is ambiguous because the address and revenue are not clearly protected as fields. A correctly quoted version would be:

Company,Address,Revenue
Northwind,"22 Market Street, Suite 4",1250

With valid quoting, Excel treats the comma inside the address as part of the address rather than as a column break. CSV conventions commonly use double quotation marks to enclose fields containing delimiters, line breaks, or quotation marks; a quotation mark within a quoted field is commonly represented by two quotation marks. If the source file has broken or inconsistent quoting, changing Excel’s delimiter may not fix it. The file may need correction in the system that produced it or in a text editor.

Protect leading zeros, dates, and long numbers

Excel tries to recognize numbers, dates, and other values. That can be useful for calculations, but it can also change data that should remain exactly as written. A postal code such as 00421 may become 421 if interpreted as a number. A product code such as 0017 can lose its first zeros, and a date-like value may be converted to a date according to Excel’s regional conventions.

When exact text matters, select Transform Data in the import window and review the columns in Power Query before loading. Set identifier columns, postal codes, and similar fields to the Text data type. For columns that should be dates or numbers, confirm that Excel interpreted them correctly. In Power Query, changing a type after an incorrect conversion may not restore information that has already been discarded, so inspect sensitive fields before loading.

Long digit strings require particular care. Excel worksheet cells have limited precision for numeric values, so account numbers, tracking codes, and identifiers should generally be imported as text rather than as numbers. If a long identifier has already been converted and digits have changed, formatting the cell as Text afterward will not recover the original characters; re-import the original CSV with the column treated as text.

For a one-time file, another option is to use Excel’s Text Import Wizard if it is available in your installation, where you can specify column formats during import. The modern From Text/CSV route is the usual choice in Microsoft 365. Avoid relying on a cell’s display format alone to preserve source data: a custom format can change how a value looks without changing the stored value.

Set the encoding and regional interpretation

Encoding determines how text characters are represented in the file. If names or places containing accents appear as symbols or garbled characters, the file may have been decoded using the wrong encoding. In the From Text/CSV preview, check the file origin or encoding setting and choose the one that matches the source. UTF-8 is widely used for CSV exports, but not every file is encoded the same way.

Regional settings can also affect interpretation. A file may use a period for decimal values in one region and a comma in another, and date order can vary as well. A value such as 03/04/2026 can mean March 4 or April 3 depending on the convention. For reliable results, confirm the source system’s number and date formats, then check the preview and imported columns rather than assuming Excel has guessed correctly.

When a file uses semicolons as separators because commas are used for decimal marks, selecting Comma will not split the fields as intended. Choose the actual delimiter shown in the source. If the file has no clear delimiter or mixes conventions, ask for a consistent export from the originating application when possible.

Common import problems and how to fix them

  • Everything lands in one column: Open the import preview and choose the delimiter the file actually uses. Also check that the source is a delimited text file rather than a different format renamed with a .csv extension.
  • Text is split into too many columns: Look for commas inside fields that are not enclosed in quotation marks, or choose a different delimiter if the file uses one.
  • Leading zeros disappear: Re-import the affected column as Text. Formatting the already-converted number as text does not bring back removed zeros.
  • Dates change order or meaning: Confirm the source’s date convention and set or convert the column deliberately during import. Inspect ambiguous dates rather than trusting automatic detection.
  • Accented characters look wrong: Select the appropriate encoding, often UTF-8 for modern exports, and compare the preview with the original source.
  • Numbers show unexpected decimal or thousands separators: Check the source region and number format, then verify the imported values before using them in calculations.

Excel worksheets are limited to 1,048,576 rows and 16,384 columns. A CSV can contain more data than a worksheet can display, so a very large file may be truncated or may require a database, a data model, or another tool suited to larger datasets. Check the source’s row count if a report appears incomplete.

Save or export data as a comma-separated file

To create a CSV from an Excel worksheet, select File > Save As or File > Save a Copy, depending on the interface, and choose a CSV option such as CSV UTF-8 (Comma delimited) (*.csv) when available. The UTF-8 option is often a sensible choice for files that may include international characters. Excel may display a warning that some workbook features are incompatible with CSV; that is expected because CSV keeps plain tabular data rather than the workbook’s full structure.

Only the active worksheet is saved to a CSV file. Before saving, select the sheet you intend to export and consider keeping a separate .xlsx copy if you need formulas, formatting, multiple sheets, or other workbook features later. Reopen the resulting CSV or inspect it in a text editor if the exact exported structure matters.

Frequently Asked Questions

How do I make Excel split a CSV by commas?
Use Data > Get Data > From File > From Text/CSV, select the file, and choose Comma in the delimiter setting if it is not selected automatically. Check the preview before loading.

Why does Excel put my whole CSV in one column?
Excel may be expecting a different separator, such as a semicolon or tab, or the file may not be structured as a valid comma-delimited file. Use the import preview to select the source’s actual delimiter.

Can Excel open CSV files with UTF-8 characters?
Yes. If characters display incorrectly, import the file and select the encoding that matches the source, such as UTF-8 when appropriate. Check the preview before loading.

How do I keep zeros at the start of a CSV value?
Import the relevant column as Text before loading it. If Excel has already converted 00421 to 421, changing the cell format afterward will not restore the missing zeros; import the original file again.

Does saving an Excel file as CSV keep every worksheet?
No. Excel saves the active worksheet’s tabular data to the CSV. Save a separate Excel workbook if you need multiple sheets, formulas, formatting, or other workbook features.

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.