Excel Import CSV: How to Open and Load Files

How-to basics · Updated November 19, 2026

To import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From Text/CSV, select the file, review the delimiter and preview, then choose Load or Transform Data. This import route gives you more control over how Excel interprets columns than simply double-clicking a CSV file.

What a CSV file contains

CSV stands for comma-separated values. It is a plain-text format for rows and columns: each line usually represents a row, and a separator such as a comma divides fields. A CSV can also use quotation marks around fields, particularly when a field contains a comma or a line break. For example, a row might contain the fields 1042,"Portland, Oregon",Open; the quotes tell a reader that the comma inside the location belongs to that field, not that it starts a new column.

Unlike an Excel workbook, a CSV does not preserve worksheet features such as cell formatting, formulas as formulas, multiple sheets, charts, or column widths. It stores text values in a simple format. Excel can display and edit those values, but if you need to keep workbook features or preserve a carefully prepared import, save a working copy as an Excel workbook (.xlsx).

Import a CSV with the Data tab

The Data tab route is a good default when the file has dates, identifiers, unusual separators, or values that need cleanup. In Excel for Microsoft 365 on Windows, follow these steps:

  1. Open the workbook where you want the data, or create a blank workbook.
  2. Select Data > Get Data > From File > From Text/CSV.
  3. Browse to the CSV, select it, and choose Import.
  4. In the preview window, check the file origin or encoding, delimiter, and the way the columns appear. Use the delimiter control if Excel has split the data incorrectly.
  5. Choose Load to bring the data into a worksheet, or choose Transform Data to open Power Query and adjust columns and data types before loading.

If you select Load, Excel normally creates a table from the imported data. If you want to choose where it goes or adjust import settings first, open the arrow beside Load and use the available load options. In Power Query, review the preview carefully, then choose Home > Close & Load to return the result to Excel. The precise dialogs can vary with Office updates and the file’s encoding.

Open a CSV directly instead

For a quick look at a simple file, you can use File > Open in Excel, browse to the CSV, and open it. You can also open a CSV from File Explorer if Windows has Excel associated with that file type. Excel may place the parsed data into a worksheet immediately, which is convenient when the columns are straightforward and you do not need to control their types.

The trade-off is that opening directly gives you fewer chances to catch automatic interpretation before it happens. Excel can recognize values that look like dates or numbers and display them accordingly. A product code such as 00127 might become 127, for example, and a long numeric identifier may lose precision if treated as a number. If the original text matters, use the Data tab import route and set the relevant column to Text before loading.

On Mac, Excel’s menus and available Power Query options can differ by version. If your Microsoft 365 build offers Data > Get Data (Power Query) > From Text/CSV, use that to preview and transform the file. Otherwise, File > Open is the simple alternative; check the imported columns immediately, especially if separators or dates are important. Excel for the web also has different import capabilities from the Windows desktop app.

Choose the right delimiter and encoding

A delimiter is the character Excel uses to decide where one field ends and the next begins. Comma is common, but files exported in some regions or from some systems use semicolons, tabs, or another character. If a comma-separated file appears in Excel as one wide column, or if one record is split into too many columns, the delimiter choice is a likely cause. In the Text/CSV preview, select the delimiter that matches the file and confirm that several sample rows line up correctly.

Do not assume every comma in a CSV separates columns. Properly quoted fields may contain commas, quotation marks, or line breaks. Excel’s import parser accounts for standard CSV quoting, so changing the delimiter to a different character just because a description contains a comma can make the structure worse. Check the preview against a few complete rows rather than judging from one cell.

Encoding controls how characters are represented in the text file. If names or symbols appear as replacement characters or garbled text, check the file origin or encoding setting in the import preview. UTF-8 is widely used, but an export may use another encoding. The correct selection depends on how the source system created the file; changing encoding cannot restore characters that were already lost in the original export.

Protect dates, zeros, and long numbers

Automatic type detection is useful for ordinary data, but it can change the way important values are stored. Dates may be interpreted using a different regional order than expected: 03/04/2026 could mean March 4 or April 3, depending on the convention. A code like 000583 can lose its leading zeros if imported as a number. Excel also stores only 15 significant digits of numeric precision, so long account, tracking, or identification numbers should generally be imported as text, not as numeric values.

When you choose Transform Data, select a column in Power Query and set its type deliberately. Use Text for identifiers where every character matters. For dates, use the appropriate date type and, when needed, the locale option so Power Query reads day and month in the intended order. Then inspect several values before loading. If Excel has already converted a value and discarded leading zeros or digits, changing the cell format afterward will not reliably restore the original text; reimport from the original CSV with the column set correctly.

Also distinguish a number from a number-like label. A quantity such as 25 may be suitable for arithmetic, while a postal code, SKU, or telephone number is usually an identifier even if it contains only digits. Choosing Text for identifiers avoids accidental arithmetic, scientific notation, and loss of meaningful zeros.

Transform and clean the data before loading

Power Query is helpful when the CSV needs repeatable preparation. In the editor, you can remove unwanted columns, rename headers, filter rows, split a column, or change data types before loading. Each action appears as an applied step, making the sequence visible and easier to revise than a set of one-off edits directly in worksheet cells. The original CSV is not changed by these transformations; Excel loads a prepared result into the workbook.

For example, imagine a monthly export with columns for order number, customer, date, and amount, plus a notes column you do not need. You could remove Notes, set Order number to Text, assign the date type using the source’s locale, and check Amount for unexpected text entries. Load the result only after confirming that the preview has the expected number of columns and representative values. This small review can prevent a whole column of dates or identifiers from being silently misread.

Power Query is particularly useful when you receive a fresh CSV each month with the same structure. Instead of repeating the cleanup manually, you can keep the query and point it to an updated source file, then refresh. If the incoming file changes its column names or layout, however, steps that depend on the old structure may need to be revised.

Refresh, save, and understand the file types

When data is loaded through a query, Excel can retain the connection and query steps in the workbook. If the source file is updated, use Data > Refresh All to update connected results. A refresh reads the source again; it does not mean that edits made only to the worksheet’s loaded table are written back into the CSV. Treat the CSV as the source and the query result as its imported output.

Save the workbook as .xlsx if you want to keep queries, multiple sheets, formatting, formulas, or other Excel features. Saving a worksheet back as CSV produces a plain-text export, not a full workbook. Excel may show a compatibility warning because CSV cannot retain all workbook features. A CSV export generally represents only the active sheet, so verify the selected sheet and the exported data before sharing it.

When saving as CSV, check the separator and regional conventions expected by the program that will receive the file. A CSV created on one computer may use a different list separator or date representation from what another system expects. If the receiving application specifies a particular encoding, delimiter, or column order, follow that specification and, when possible, reopen the exported file in a text editor or reimport it to confirm the result.

Common import problems and safe handling

  • Everything appears in one column: Return to the import preview and choose the actual separator, often comma or semicolon. Check the preview before loading.
  • Columns shift unexpectedly: Look for quoted fields containing separators, inconsistent rows, or a delimiter that does not match the file. Do not delete quote marks blindly; they may be part of the CSV structure.
  • Zeros disappear or numbers change: Import identifiers as Text. Reimport from the original file if Excel has already altered the values.
  • Characters look corrupted: Try the correct encoding in the preview, commonly UTF-8, and confirm the source file’s export settings if the issue remains.
  • Dates are reversed: Check the source’s date convention and apply the matching locale or date interpretation before loading.

CSV is plain text, but a file from an unknown source is not automatically safe. Spreadsheet programs may interpret some text beginning with formula characters as a formula when opening or importing data. Be cautious with files from untrusted senders, particularly if they contain unexpected formulas or request that you enable content. If you only need to inspect an unfamiliar file, a plain-text editor can show its contents without spreadsheet calculation; do not treat a CSV’s simple format as proof that its contents are harmless.

Frequently Asked Questions

What is the best way to import a CSV into Excel?
For reliable control, use Data > Get Data > From File > From Text/CSV. Review the delimiter and preview, set sensitive columns such as IDs to Text if needed, and then load the data.

Why does Excel put my CSV data in one column?
Excel may be using a different separator from the one in the file. Reopen it through the Text/CSV import route and select the delimiter shown by the source, such as comma, semicolon, or tab.

How do I keep leading zeros when importing a CSV?
Use the import preview’s Transform Data option, set the identifier column to Text in Power Query, and then load it. Formatting a value as Text after Excel has removed its zeros does not recover them.

Does importing a CSV change the original file?
No. Importing loads data into Excel; Power Query transformations create an output in the workbook and do not edit the source CSV. Saving or exporting over the original file is a separate action, so keep a backup if you plan to replace it.

Can Excel keep a CSV import up to date?
Yes, when you import through a query and retain that query in the workbook, you can use Data > Refresh All to read updated source data. The source file must remain accessible, and changes to its layout may require adjustments to the query.

Should I save my imported data as CSV or XLSX?
Choose XLSX to retain Excel features such as multiple sheets, formatting, formulas, and query settings. Choose CSV only when another system needs a plain-text data export, and remember that it cannot store the full workbook.

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.