How to Open a CSV File in Excel With Separate Columns

How-to basics · Updated November 20, 2026

To open a CSV file in Excel with its values in separate columns, use Data > From Text/CSV, choose the correct delimiter in the preview, and select Load. This import route lets you check how Excel will split the data before it appears in your worksheet, which helps prevent the common problem of every row landing in one column.

What You’ll Need

  • A CSV file saved on your computer or in a location you can access.
  • Microsoft Excel for Microsoft 365 on Windows.
  • A basic idea of how the file is separated: most often by commas, but sometimes by semicolons or tabs. If you are not sure, you can inspect the preview in Excel.

A CSV is a plain-text data file, not a formatted Excel workbook. It usually stores rows of values separated by a delimiter. Importing it into Excel puts those values into worksheet cells; saving a copy as an Excel workbook afterward lets you keep Excel formatting and features.

Step-by-Step

  1. Open Excel and start an import. Open a blank workbook or the workbook where you want the data. On the ribbon, select Data > From Text/CSV. Browse to the CSV file, select it, and choose Import. In some Microsoft 365 builds, the command appears as Data > Get Data > From File > From Text/CSV. If you do not see the shorter command, use that route. Importing this way is safer than double-clicking when you need to check separators or protect values such as codes with leading zeros.
  2. Check the preview before loading. Excel displays a preview of the file. Look at the column headings and a few rows. If you see distinct fields across the preview, Excel has identified a delimiter that may be right. If the whole line appears in one preview column, or names and numbers are split incorrectly, do not load it yet. You can change the settings in this window.
  3. Choose the delimiter that matches the file. In the delimiter control, select Comma for a typical comma-separated CSV. If that does not create the expected columns, try Semicolon or Tab, depending on how the file is structured. Use the preview as your guide: for example, a row such as Rina,West,42 should appear in three fields if commas separate its values. Avoid selecting multiple delimiters unless the file actually uses more than one, or Excel may split fields too far.
  4. Check the text encoding if characters look wrong. If names or symbols appear as question marks or odd characters, look for the file-origin or encoding setting in the import window. Try 65001: Unicode (UTF-8) when the CSV was saved as UTF-8; this is a common format for files shared online. Check the preview again after changing the setting. The correct choice depends on how the source file was created, so do not change it if the characters already display correctly.
  5. Decide whether to transform the data before importing. Choose Transform Data if you need to control column types before they enter the sheet. This is important for postal codes, product IDs, account numbers, and other values that can begin with zero. In the Power Query Editor, select the relevant column and use Transform > Data Type > Text. You can repeat this for other columns that should remain text. For ordinary data, you can proceed directly with Load.
  6. Load the data into the workbook. In the preview window, select Load to place the imported data in a new worksheet. If you used Power Query, choose Home > Close & Load in the editor. For a different destination, use the load options, if available, and choose where the table should go. Wait for the import to finish, then confirm that each field appears in its own column and that the first row contains the headings you expect.
  7. Review how Excel interpreted the values. Check a few important fields for changed dates, long numbers, decimal separators, and leading zeros. Excel may interpret a value such as 03/04/2025 as a date, but the order of the day and month depends on regional settings and the source. It may also display long numeric identifiers in scientific notation. If those values must stay exactly as written, import the column as Text rather than relying on Excel’s automatic interpretation.
  8. Save an Excel copy if you want to keep working on it. Choose File > Save As, select a folder, and choose Excel Workbook (*.xlsx) as the file type. Give the workbook a new name so the original CSV remains unchanged. A CSV cannot store multiple worksheets, formulas, or most Excel formatting; the XLSX copy can. Keep the original too if you need an unmodified source file.

If you already opened the CSV and all its content is in column A, you can often split it without importing again. Select the affected column, choose Data > Text to Columns, select Delimited, choose the correct delimiter, check the preview, and select Finish. If some fields contain commas inside quotation marks, check that the text qualifier is set to a double quote so those commas are treated as part of the field rather than as separators.

Common Mistakes

  • Opening the file without checking the delimiter. Double-clicking a CSV may work, but Excel can use regional settings to decide how to separate values. If the result is one column, use the import steps above or Text to Columns rather than assuming the file is damaged.
  • Picking the wrong separator. A semicolon-separated file imported as comma-separated may stay in one column. Conversely, splitting on both commas and semicolons can break values that should remain together. Use the preview to identify the separator that produces the intended fields.
  • Letting Excel change identifiers into numbers. A code such as 004817 can become 4817 if treated as a number. For values that are identifiers rather than quantities, set the column to Text during import.
  • Assuming CSV preserves Excel formatting. CSV stores plain text values and delimiters, not worksheet styles, formulas as working formulas in every context, multiple tabs, or column widths. Save as XLSX when you need workbook features.
  • Saving over the source file accidentally. Keep the original CSV untouched when possible. Use Save As to create a separate XLSX working copy.

Tips

  • Let the preview decide. A good import preview has the expected number of columns, recognizable headings, and sensible sample values. Do not load until it looks right.
  • Use Text for codes, not just numbers that happen to look numeric. ZIP codes, telephone numbers, SKU values, and reference IDs often need their original characters preserved. They are labels, even when they contain only digits.
  • Keep dates and decimal conventions in mind. A CSV created in one region may use a different date order or decimal mark from your Excel settings. If dates matter, verify several rows against the source before sorting or calculating with them.
  • Import again when the source changes. If you use Power Query, the imported data can be refreshed from the same source. Use Data > Refresh All after the CSV is updated, provided it remains in the same location and keeps a compatible structure.
  • Use a copy for experiments. If you are unsure how a delimiter or data type will behave, import into a new workbook or worksheet first. That makes it easier to compare the result with the original CSV.

Troubleshooting

Everything is in one column: Select the source column and use Data > Text to Columns, then choose Delimited and test comma, semicolon, or tab. If you have not imported yet, return to Data > From Text/CSV and change the delimiter in the preview. If none of those options work, the file may use another separator or fixed-width spacing; inspect a copy in a plain-text editor to see what separates fields.

Fields are split into too many columns: You may have selected a delimiter that also appears within values, or selected more than one delimiter. Re-import and choose only the separator used between fields. If values are enclosed in double quotes, ensure the import treats the quote as a text qualifier. Properly quoted commas inside a field should not create extra columns.

Accented letters or symbols are garbled: Reopen the import and try a different file encoding, starting with UTF-8 if appropriate. If the preview becomes correct, load from that setting. If no encoding gives readable text, ask for a fresh export from the source application and specify UTF-8 when that option is available.

Zeros disappear or long values change: Import the affected column as Text before loading. Changing a number’s cell format after Excel has already removed leading zeros will not restore the original characters; re-import from the CSV to recover them. For long identifiers, avoid letting Excel convert them into numeric values.

Dates or decimal values look incorrect: Check the source file and the regional conventions used to create it. A date like 04/05/2025 is ambiguous without knowing whether the source means April 5 or May 4. Re-import and set uncertain columns to Text, or confirm the intended format with the person or system that produced the CSV before converting them.

You cannot find From Text/CSV: Maximize the Excel window or check the Data tab for Get Data or From Text/CSV; ribbon layouts can vary. On Excel for Mac, the available Power Query import options depend on the version. If the command is unavailable, open the CSV and use Data > Text to Columns to split its contents. On Mac, menu and shortcut details differ from Windows, but the delimiter and preview checks still apply.

Frequently Asked Questions

Why does my CSV open in one column in Excel?
Excel may be using a different list separator from the one in the file. Import with Data > From Text/CSV and select the delimiter that creates the correct preview, or use Text to Columns on the already-open data.

Should I open a CSV by double-clicking it?
You can, especially for a simple file that displays correctly. For more control over separators, encoding, and values such as leading-zero codes, start the import from Excel’s Data tab instead.

How do I keep leading zeros in a CSV column?
Use Transform Data during import, select the column, and set its data type to Text before loading. If zeros have already disappeared, re-import from the original CSV as Text.

Can I save the result as a normal Excel file?
Yes. Use File > Save As and select Excel Workbook (*.xlsx). Keep the CSV separately if you need an untouched copy, because CSV does not retain Excel workbook features.

What if my CSV uses semicolons instead of commas?
Choose Semicolon as the delimiter in the import preview. The file extension can still be .csv even when semicolons separate its fields; the preview is the best check.

Can I import a CSV on Mac?
Yes. Excel for Mac has import options that vary by version. If its Power Query import route is available, use the preview to set the delimiter and data types. Otherwise, open the file and use Data > Text to Columns to split it.

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.