How to Import CSV to Excel: Steps and Common Fixes

How-to basics · Updated November 18, 2026

To import a CSV 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. If the preview needs correction, choose Transform Data first; this lets you adjust columns and data types before the information reaches the worksheet.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for storing rows and columns of data. A file might contain a header row followed by records, such as customer names, dates, and order totals. Despite the name, a CSV does not always use commas: depending on how it was created, it may use semicolons, tabs, or another delimiter between fields.

A CSV is not an Excel workbook. It does not preserve multiple sheets, cell formatting, formulas, charts, or workbook features. It stores text representations of values in a single table-like structure. Importing it into Excel lets you work with the data in a worksheet, but the way Excel interprets the text matters. A product code such as 00421 can become 421 if Excel treats it as a number, and a date such as 04/05/2026 can be ambiguous across regional settings.

Import a CSV using the Data tab

  1. Open the Excel workbook where you want the data. It can be a new workbook or one that already has other sheets.
  2. On the ribbon, select Data > From Text/CSV.
  3. Browse to the CSV file, select it, and choose Import.
  4. Review the preview. Check that columns are separated correctly and that names, dates, and special characters look right.
  5. If the preview is correct, select Load. To control types or make changes first, select Transform Data.

Excel places the imported records in a worksheet, usually as a table. If you need to choose a destination, use the arrow beside Load and select Load To, then choose options such as an existing worksheet and a starting cell. The exact dialog wording can vary slightly with Excel updates, but the import route is the same.

On Excel for Mac, the available Power Query features and ribbon labels depend on the Microsoft 365 version. Where supported, use Data > Get Data (Power Query) > Text/CSV, then review the preview and load the result. If that command is not available in your build, opening the CSV directly is a simpler fallback, but check how Excel interpreted the values before relying on them.

Choose between importing and opening the file

Double-clicking a CSV or choosing File > Open can be convenient for a quick look. Excel opens the file as a worksheet, but may automatically interpret fields using your computer’s regional settings and its guesses about data types. That can be risky when the file includes identifiers, dates, or decimals that must remain exactly as written.

Using Data > From Text/CSV gives you a preview and the option to transform the data before loading it. It is the better choice when accuracy matters, when the delimiter is not obvious, or when you expect to repeat the import. For a small, simple file, direct opening may be enough if you verify the results. Neither method turns the CSV itself into a feature-rich workbook; use Save As and choose an Excel workbook format if you need to preserve Excel features.

Check the delimiter, encoding, and preview

The import preview is where you can catch many problems before loading. First confirm that each field appears in its own column. If every row appears in one column, the selected delimiter may not match the file. In the preview or Power Query settings, choose the separator used by the source, such as comma, semicolon, or tab. A semicolon-delimited file is common in some regional settings, but the file’s actual contents determine the right choice.

CSV fields can contain delimiters as part of their text. Standard CSV uses quotation marks to enclose such fields, so a comma inside a quoted address should not automatically create a new column. If the source file is malformed or uses an unusual quoting convention, Excel may not split it as expected. Check a few records against the original data rather than assuming that a plausible-looking preview is correct.

Also inspect the file’s character encoding. If accented letters or other non-English characters appear as strange symbols, the file may have been read using the wrong encoding. In the import dialog, use the File Origin or encoding selection and try UTF-8 when that matches the source. The option may be displayed as 65001: Unicode (UTF-8). Verify names and symbols in the preview before loading, since changing the encoding afterward may not repair text that was already imported incorrectly.

Protect dates, numbers, and leading zeros

Excel tries to recognize values, but automatic detection is not always appropriate. Decide which fields are truly numbers or dates and which are identifiers that should stay as text. Account numbers, postal codes, SKU codes, telephone numbers, and values with leading zeros are usually identifiers, not quantities to calculate. In Power Query, select a column and set its data type to Text before loading if its exact characters must be preserved.

Dates need particular attention. The value 03/04/2026 could mean March 4 or April 3 depending on the format used by the source. If Excel interprets the source using a different regional convention, the resulting date can be wrong even though it looks valid. In Power Query, you can select the relevant column and use Transform > Data Type > Using Locale to specify the date type and the locale that matches the file. Check several known dates before accepting the result.

Decimal and thousands separators can also vary. For example, one source might write 1,234.56 while another writes 1.234,56. If Excel reads the separators according to a different locale, a value may be misunderstood or imported as text. Choose a suitable locale for the column in Power Query when needed, and compare the imported values with the source. Do not assume that changing a cell’s display format will fix a value that was parsed incorrectly.

Long numeric-looking identifiers require extra care: Excel worksheet numbers retain only 15 significant digits of precision. If a CSV contains a longer code, import it as text to avoid changing its digits. Applying Text formatting after Excel has already converted and rounded a long number cannot restore the original characters.

Make repeat imports easier with Power Query

Selecting Transform Data opens the Power Query Editor, where you can clean and shape the data before loading it. Common tasks include removing unwanted columns, filtering rows, changing column names, and setting data types. These steps are recorded as a query rather than applied as one-off edits to the worksheet. That makes Power Query useful when you receive a new version of the same report regularly.

For a recurring file, keep the query and replace or update the source file as appropriate. Then use Data > Refresh All to run the saved import and transformation steps again. Refreshing can save time, but it does not guarantee that a changed source has the same columns or data meaning. If the provider changes a header, delimiter, or date convention, review the refreshed result and the query steps.

Power Query is also helpful when the CSV needs repeatable cleanup before analysis. For instance, you can remove blank rows and set a code column to Text as part of the import process. These transformations do not change the original CSV file; they shape the data that Excel loads. Keep the source file if you may need to compare or re-import the original records.

Fix common CSV import problems

  • Everything appears in one column: Reopen the import using Data > From Text/CSV and select the delimiter that matches the file. Do not split on commas if the file uses semicolons or tabs.
  • Leading zeros disappeared: Import the affected column as Text. If Excel already converted the values, import again from the original CSV; changing number formatting alone will not bring back removed zeros.
  • Dates are reversed or unexpected: Confirm the source date convention and set the type with the matching locale in Power Query. Compare the results with known records.
  • Letters look corrupted: Choose the correct file encoding, often UTF-8, in the import settings and check the preview before loading.
  • Numbers are treated as text or have wrong decimals: Check the decimal and thousands separators used by the source, then select an appropriate locale or data type in Power Query.
  • Rows or columns seem to be missing: Inspect the original CSV in a text editor and check for blank lines, inconsistent delimiters, or broken quotation marks. Excel can only import what the file contains in a format it can parse.

When troubleshooting, return to the source file rather than repeatedly editing a damaged worksheet copy. A clean re-import makes it easier to distinguish a parsing issue from a display-format issue and reduces the risk of unknowingly keeping altered values.

Save the imported data in the right format

After checking the result, save the workbook as an Excel workbook if you want to retain tables, formulas, formatting, queries, or multiple sheets. Use File > Save As and select Excel Workbook (.xlsx). Saving back to CSV is useful only when you specifically need a plain-text data file. A CSV can hold one sheet of plain values, so saving an Excel workbook as CSV removes workbook features and may discard other sheets.

If another person or system will consume the exported CSV, confirm which delimiter, encoding, and date format it expects. A file that opens correctly on your computer may be interpreted differently elsewhere because regional settings and import rules differ. When the receiving system has a specification, follow it and test a small export before sending a large or important dataset.

Frequently Asked Questions

Can I import a CSV into an existing worksheet?
Yes. Use the arrow beside Load in the import dialog and choose Load To, then select an existing worksheet and starting cell where that option is available. Leave enough space so the imported table does not overwrite existing content.

How do I keep leading zeros when importing a CSV?
Use Data > From Text/CSV, choose Transform Data, and set the relevant column’s type to Text before loading. This is important for postal codes, product identifiers, and similar fields. If the zeros have already disappeared in the worksheet, import from the original file again.

Why does my CSV open in one column in Excel?
The file may use a different delimiter from the one Excel selected automatically. Import through Data > From Text/CSV and choose the actual separator, such as a semicolon or tab, in the preview. Also check whether the source uses consistent quotation marks around fields.

Can I import a CSV without changing its original file?
Yes. The import creates a worksheet or query result in your workbook; it does not edit the source CSV. You can keep the original file unchanged and save your work separately as an .xlsx workbook.

Can Excel update the imported data when the CSV changes?
If you imported it as a Power Query connection, use Data > Refresh All to retrieve the source again. The query depends on its source location and structure, so keep the file accessible and check the result if the CSV’s columns or format have changed.

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.