Excel Not Opening CSV Correctly? How to Fix It

If Excel is not opening a CSV correctly, import it instead of double-clicking the file: in Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check the delimiter and preview, then select Transform Data if you need to set column types before loading. This avoids many problems with columns, dates, encoding, and leading zeros.

Start with the right import method

For a one-time import, open a blank workbook, go to Data > From Text/CSV, select the CSV, and inspect the preview before loading it. Confirm that the delimiter shown in the preview matches the file: usually a comma, but sometimes a semicolon, tab, or another character. If the preview looks right, choose Load. If you need to preserve identifiers or change data types, choose Transform Data first.

Opening a CSV by double-clicking is convenient, but Excel has to guess how to interpret it. Importing gives you a chance to check those choices. If a CSV is already open with all its contents in one column, close it without saving changes and import the original file through Data > From Text/CSV. Splitting the column afterward can work, but reimporting is often safer when Excel has also changed dates or numbers.

Use the delimiter setting when fields appear in the wrong number of columns.
Use the encoding or file-origin setting when letters display incorrectly.
Set sensitive columns to Text in the transformation step before loading.

Why Excel can read the same CSV differently

A CSV is a plain-text file containing values separated by a delimiter. It does not reliably carry spreadsheet features such as cell formatting, column widths, or instructions that tell Excel a value is an identifier rather than a number. Excel must interpret the text when it opens or imports the file, and its interpretation can depend on the file’s contents, regional settings, and import choices.

For example, a file containing Product,Code on its first line and Widget,00127 on the next may be opened with the code converted to the number 127. The zeros were part of the original text, but a numeric cell does not retain them. Similarly, a value such as 03/04/2026 can be interpreted differently in regions that use month/day/year and day/month/year conventions.

CSV is also a family of practical variations rather than a guarantee that every file uses commas. A program may call a semicolon-separated file a CSV, for example. Excel’s direct-open behavior can reflect the system’s regional list separator, while the import preview lets you choose the delimiter for that particular file.

Set the delimiter and preview the columns

In the From Text/CSV preview, select the delimiter that actually separates fields. A comma-separated file should normally produce one column per comma-separated field. If it produces a single column, try the correct alternative delimiter rather than splitting on spaces or punctuation at random. A semicolon-separated file, for instance, needs Semicolon selected.

Check several rows, not just the header. A correctly quoted CSV can contain a delimiter inside a field without treating it as a column break. For example, a field containing 12 Main Street, Apt 4 may be enclosed in double quotes in the source file so the address remains one field. A comma inside quotes is data; a comma between fields is a delimiter. If quotes are missing or unbalanced in the source, later rows may shift into unexpected columns, and changing Excel’s delimiter alone may not repair the underlying file.

If the preview is correct but the loaded table is not, cancel and import again, then inspect the file’s delimiter and quoting. Also check whether the source has inconsistent rows, extra separators, or line breaks inside quoted fields. When a file comes from another system, asking for an export in standard comma-separated UTF-8 format can be more effective than repeatedly adjusting Excel.

Fix dates, numbers, and leading zeros

Excel may automatically convert text that resembles a date, number, percentage, or scientific notation. That is helpful for ordinary data analysis but risky for account numbers, postal codes, product codes, and long reference values. Once a long digit string has been converted to a number, Excel retains only 15 significant digits of numeric precision; digits beyond that can be lost. Formatting the cell as Text afterward cannot restore digits that were already discarded.

To prevent conversion, choose Transform Data in the import window. In Power Query, select the affected column and set its data type to Text before loading. Review the other columns too: a date column should be interpreted using the intended date convention, while quantities or prices may need a numeric type. Then select Close & Load. The precise controls can vary slightly as Microsoft updates Excel, but the key is to set the type before the data reaches worksheet cells.

For a small amount of data entered manually, you can also format destination cells as Text before pasting or typing values. That does not change how a CSV is parsed when you simply double-click it, so it is not a substitute for controlling the import. When the source uses ambiguous dates, verify a known date against the original system before relying on Excel’s interpretation.

Choose the correct text encoding

Encoding determines how bytes in a text file represent characters. If accented letters, curly punctuation, or non-Latin writing appears as question marks or odd symbols, Excel may be reading the file with the wrong encoding. In the import workflow, check the file origin or encoding choice and select UTF-8 when that matches the source. The preview is a useful check: inspect names or words that contain non-ASCII characters before loading.

Some CSV files include a UTF-8 byte-order mark, which can help software identify their encoding; others do not. Files exported by older or specialized systems may use a different encoding. Do not assume every display problem is a delimiter problem: changing comma to semicolon will not fix garbled characters. If the correct encoding is unclear, request the export format from the system that created the file or compare a known name with the source.

Check the CSV file itself

Excel cannot reliably repair a file whose structure is inconsistent. Open a copy in a plain-text editor to inspect the first few lines. Look for the separator between fields, quotation marks around fields containing separators, and rows with a different number of fields than expected. Do not edit a production file without keeping an untouched copy, especially if another process depends on its exact format.

Some common structural causes include an unescaped quotation mark inside a field, a missing closing quote, or a line break embedded in a value. In standard CSV quoting, a field containing a double quote represents that quote by doubling it. A valid record may span multiple physical lines when a quoted field contains a line break, so each line in a text editor is not necessarily a complete spreadsheet row. If a particular export repeatedly produces malformed records, correcting the export is usually better than relying on manual cleanup after every import.

Save or refresh the data appropriately

After a successful import, save the workbook as an Excel workbook (.xlsx) if you want to keep worksheet formatting, formulas, tables, or Power Query settings. CSV stores plain text data and does not preserve those workbook features. If you save an edited workbook back as CSV, Excel warns that features outside the CSV format may be lost; the CSV will represent only the active sheet’s data, not a complete multi-sheet workbook.

For recurring files with the same structure, importing through Power Query can make refreshes more consistent. Keep the query’s delimiter and type choices, replace or update the source file as appropriate, and use Data > Refresh All to update connected data. Confirm the source path and inspect the refreshed results, particularly if the new file has different columns or formats. A query cannot guarantee that a future file has the same structure as the original.

Handle untrusted CSV files carefully

A CSV can contain text that spreadsheet software interprets as a formula when opened. This matters when files come from an unknown sender or contain user-submitted values. Avoid treating untrusted content as harmless just because the file is plain text. Importing suspicious columns as Text can reduce the chance that their contents are evaluated as formulas, but use a trusted source and follow your organization’s security guidance. Do not enable macros or follow links from a file merely because Excel displays a warning or prompt.

Frequently Asked Questions

Why does my CSV open in one column in Excel?
Excel likely chose a delimiter that does not match the file. Import it with Data > From Text/CSV and select the separator shown in the source, such as a semicolon instead of a comma.

How do I stop Excel removing leading zeros from a CSV?
Import through Data > From Text/CSV, choose Transform Data, and set the identifier column to Text before loading. Changing the cell format after the zeros have disappeared does not restore them.

Why are dates in my CSV changing?
Excel is interpreting date-like text using a date convention or data type that may differ from the source. Control the column type during import and verify ambiguous dates against the original data.

How do I fix strange characters in a CSV?
Check the encoding or file-origin choice in the import workflow. Try UTF-8 if that is how the file was saved, and verify the preview before loading.

Will saving a CSV as Excel keep the original file?
Use Save As and choose .xlsx to create an Excel workbook while leaving the source CSV intact. Avoid overwriting the original if you may need its unmodified text data later.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.