How to Open a CSV File in Excel Without Losing Data

How-to basics · Updated November 21, 2026

To open a CSV in Excel, double-click the file or use Excel’s File > Open command. If the file contains important IDs, dates, or special characters, use Data > From Text/CSV instead; the import preview lets you check how Excel will read the columns before loading them. Save a working copy as an Excel workbook (.xlsx) if you want to keep formatting or multiple sheets.

What You’ll Need

  • A CSV file saved on your computer or somewhere you can browse to, such as a network folder.
  • Microsoft Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has similar import options, though their location or appearance may vary slightly.

A CSV is a plain-text table, not a complete Excel workbook. It can hold rows and columns of data, but not workbook features such as cell formatting, charts, or multiple sheets. Keep the original file unchanged until you have checked the imported data.

Step-by-Step

  1. Find the CSV file. Note its folder and filename, and check that it ends in .csv. If it arrived as an email attachment or download, save it somewhere easy to find first. If the file is important, make a copy before opening it so you can return to the untouched original if needed.
  2. Choose how to open it. For a quick look at a straightforward file, double-click the CSV in File Explorer. If Excel is not the default app, right-click the file, choose Open with, and select Excel. You can also start Excel, select File > Open > Browse, go to the file, select it, and choose Open. If it is not listed, use the file-type menu in the Open dialog and select a text or all-files option.
  3. Check the result before editing. Excel usually places comma-separated fields into separate columns and each line into a row. Look at the first few rows and the bottom of the data. Check that headers are in the expected columns, fields with commas have not split incorrectly, and values such as postal codes or product IDs still have their original digits. Direct opening is convenient, but Excel may automatically interpret text as dates or numbers and remove leading zeros.
  4. Use the import preview when the data needs care. In Excel, select Data > From Text/CSV, browse to the CSV, select it, and choose Import. Excel displays a preview. Check the file origin or encoding setting if characters look wrong, and select the correct delimiter if the preview does not show the fields in separate columns. Comma is common, but a file may use a tab, semicolon, or another separator.
  5. Set sensitive columns to text before loading. If the preview looks right but Excel might alter values, select Transform Data to open Power Query. Select a column such as an account number or ZIP code, then use Home > Data Type or the data-type icon in the column header to choose Text. This preserves leading zeros and avoids treating long identifiers as numbers. For date columns, choose a suitable date type only if the values really represent dates and the date order is clear.
  6. Load the data into Excel. In the Power Query window, use Home > Close & Load to place the prepared data in a worksheet. If you did not need to transform anything, choose Load in the import preview. Confirm that the column headings and a few sample values still look right. The imported table is now available to sort, filter, format, or analyze in Excel.
  7. Save a workbook copy if you will keep working. Select File > Save As, choose a folder, and select Excel Workbook (*.xlsx) as the file type. Give the workbook a new name and save it. This keeps Excel features you add, while leaving the original CSV available as a plain-text source. If you choose to save back to CSV instead, Excel may warn that some workbook features are not compatible; the CSV format cannot preserve them.

Common Mistakes

  • Opening directly when leading zeros matter. Excel may read values such as 00127 as the number 127. Formatting the cell to display zeros after opening does not necessarily restore the original text. Import the column as Text instead.
  • Assuming every comma is a column break. A correctly formatted CSV can contain commas inside a quoted field, such as an address. Excel’s import tool understands quoted fields; manually splitting every line at each comma can break the data.
  • Saving the working file over the source. Saving changes to a CSV can discard formatting, formulas, and other workbook-only features. Keep a separate .xlsx copy for ongoing work, and retain the original CSV if you may need it again.
  • Ignoring date and number conversions. A string such as 03/04/2025 can mean different dates in different regional settings. Check the source’s date convention before accepting Excel’s conversion, and keep ambiguous values as text until you know how to interpret them.
  • Expecting the CSV to contain several sheets. A CSV holds one table, not an entire workbook. If someone expected to send multiple tabs, ask for an Excel workbook instead.

Tips

  • Use the import route for files containing long reference numbers, leading zeros, mixed date formats, or characters from other languages. It gives you a chance to inspect and adjust the data before it reaches the worksheet.
  • Look at the preview from left to right. Confirm that each heading sits over the correct values and that text containing commas remains in one field. Also check whether the first row contains headings or actual data; do not treat a data row as a header by mistake.
  • If you receive updated versions of the same CSV regularly, importing with Power Query can make repeat updates easier. Keep the source file in a consistent location and use the query’s refresh option after replacing it with a new version. Check that the new file has the same columns and layout before relying on the refreshed table.
  • For a quick keyboard route on Windows, Ctrl+O opens Excel’s file-opening screen; on Mac, use Command+O. To protect the source, use Save As rather than changing the file’s extension manually.
  • Only open CSV files from sources you trust. Plain-text files can contain entries that spreadsheet software interprets as formulas. If data is unexpected or comes from an unknown source, inspect it carefully and do not treat the displayed values as harmless just because the filename ends in .csv.

Troubleshooting

Everything appears in one column: The delimiter may not be a comma, or Excel may not have detected it. Choose Data > From Text/CSV, select the file, and try the appropriate delimiter in the preview. A semicolon is common in some regional settings. If the file uses tabs, choose Tab. Do not split on spaces unless the file’s structure specifically uses spaces between fields.

Letters or symbols look garbled: The file may use a different character encoding. Open it through Data > From Text/CSV and try another file origin or encoding in the preview. UTF-8 is common for files containing accented letters or non-Latin characters. Check several affected words before loading; changing the worksheet font usually will not repair incorrectly decoded text.

Zeros disappeared or a long number changed: Reopen the original CSV rather than trying to repair a converted value in the worksheet. Import it with Data > From Text/CSV, choose Transform Data, and set the affected column to Text before loading. Very long identifiers should generally be stored as text, because Excel’s numeric precision is limited.

Dates are reversed or inconsistent: Do not guess based on one cell. Check the source system or ask the file’s sender whether dates use month/day/year or day/month/year. Reimport and keep the column as text until the order is confirmed, or set the correct date type during transformation.

Excel does not open the file or it looks empty: Confirm that the download completed and that you selected the intended file. Try File > Open > Browse or Data > From Text/CSV rather than relying on the file association. If Excel reports that the extension or format does not match, check with the sender that the file is genuinely a CSV and has not been renamed from another format.

Frequently Asked Questions

Can I open a CSV in Excel by double-clicking it?

Yes. If Excel is the default app for .csv files, double-clicking opens the file. This is fast for a basic view, but Excel may automatically convert some values. Use the import preview when preserving IDs, dates, or exact text matters.

How do I open a CSV in Excel without changing the data?

Choose Data > From Text/CSV, inspect the preview, and use Transform Data to set sensitive columns to Text before loading. This helps preserve values such as 00056 and long account codes. Keep an untouched copy of the source as an additional safeguard.

How do I save a CSV as an Excel file?

After opening or importing it, select File > Save As and choose Excel Workbook (*.xlsx). The new workbook can preserve formatting and additional sheets you create. The original CSV remains a separate plain-text file if you save the workbook under a new name.

Why does Excel put the whole CSV in one column?

Excel may be using the wrong separator. Import the file with Data > From Text/CSV and choose the delimiter shown by the file’s layout, such as comma, semicolon, or tab. Check the preview to confirm the columns before loading.

Can I open a CSV in Excel for Mac or Excel for the web?

Excel for Mac supports opening CSV files and has text-import options, although the menus and dialog may differ from Windows. In Excel for the web, upload or open the file from OneDrive or SharePoint; if the values need careful type or delimiter control, use the desktop app’s import options.

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.