Skip to content
English
  • There are no suggestions because the search field is empty.

How do I open a .csv file with Excel?

When opening .csv files in Excel, it is important to retain the formatting to avoid errors when importing or editing the data. The following steps ensure that the data is displayed correctly.

Step-by-step instructions

  1. Do not open the file directly: Avoid opening the .csv file by double-clicking it. This may open the file with incorrect settings.
  2. Start Excel: Open Microsoft Excel without loading a file.
  3. Perform the data import: Go to "Data" in the top menu bar, select "Get Data" and then "From File". Click "From Text/CSV".
  4. Select the file: Navigate to the location of your .csv file, select it, and click "Import".
  5. Check the data formatting: A preview of the data is displayed in the Excel import dialog. Make sure the columns are formatted correctly (e.g. text, date, number). If necessary, select the correct data format for each column.
  6. Import the data: Click "Load" to import the data into a new worksheet.
  7. Save the data: Save the file as an Excel workbook (.xlsx) to preserve the formatting and any adjustments you have made.

Important notes

  • Changes to the structure: Make sure the structure of the .csv file (e.g. the number of columns and their order) is not changed during editing.
  • Special characters: Check whether special characters or umlauts are displayed correctly.
  • Formatting: Use the formatting options in Excel to ensure that all data is displayed correctly.

By following these steps, you can work with .csv files in Excel without errors and keep the formatting intact.