Skip to main content

Viewing downloaded .CSV data format.

Updated over a week ago

CSV (Comma-Separated Values) files are commonly used for storing tabular data. However, sometimes when opening a CSV file in Microsoft Excel, you may encounter readability issues. One common reason for this is when the file is opened using the wrong separator, such as a semicolon instead of a comma. In this guide, we'll show you how to fix this issue by adjusting the separator settings in Microsoft Excel

With Microsoft Excel:

  1. Open the CSV File: Navigate to the location of the CSV file on your computer. Double-click on the CSV file to open it in Microsoft Excel.

  2. Text Import Wizard: When the "Text Import Wizard" dialog box appears, select "Delimited" and click "Next":

With Open office:

  1. Open the CSV File: Navigate to the location of the CSV file on your computer. Double-click on the CSV file to open it in OpenOffice.

  2. Text Import Wizard: When the "Text Import" dialog box appears, select "Separated by" and choose "Comma" as the separator. Click "OK" to proceed:

Did this answer your question?