Why my exported CSV file data not displayed properly ?

Why my exported CSV file data not displayed properly ?

In certain regions, such as Europe, users may encounter difficulties opening Excel files downloaded from the web in CSV format (.CSV). The problem lies in regional Excel settings, where default list separator options differ – files may be interpreted with either a comma or semicolon separator. In Europe, the default tends to favor the semicolon as a delimiter rather than a comma.
Here are step-by-step instructions for adjusting these settings on both Windows and MacOS platforms:

Windows Users:

  1. Begin by accessing the Control Panel from the Windows Start Menu.
  2. Navigate to the Regional and Language Options.
  3. Within the Regional Options tab, locate and click on Customize/Additional settings (for Windows 10 users).
  4. Adjust the 'List separator' to a comma (,).
  5. Confirm the changes by clicking 'OK' twice.

MacOS Users:

  1. Access System Preferences.
  2. Open the Language & Region pane and select the Advanced option.
  3. Modify the Decimal Separator:
    1. If it's currently set as a period (.), the CSV separator will be a comma.
    2. If it's set as a comma (,), the CSV separator will be a semicolon.

Alternative method:

  1.  Launch Excel and create a new empty spreadsheet.
  2. Navigate to the Data tab and select 'From Text.'
  3. Choose the desired file to open.
  4. Opt for the 'Delimited' option and proceed to the next step.
  5. Select the appropriate delimiter to accurately display metadata in the Preview pane.
  6. ​Once opened, make necessary modifications to the file and save it as .TXT (tab delimited) to ensure tab separation instead of variable characters.
These outlined methods should effectively address any issues encountered when opening CSV files in Excel, stemming from regional settings discrepancies.