CSV download issues

CSV download issues

If your CSV files are often not opening properly, the reason is that regional settings in windows use commas as the default decimal point character (instead of a period in english countries), and so the default separator is a semi-colon. In order for them to open CSV's without having to import it every time, they can change those regional settings:
  1. In the start bar, search "Control Panel" (Panneau de Configuration)
  2. Go to the Region Settings
  3. Go to the Region - Dates, Numbers, etc... settings
  4. Click Additional Settings (Parametres Supplementaires)
  5. Change the Caractere Decimal to a period, and the separateur de listes, to a comma.
  6. Click Apply (Appliquer), then close.
  7. Close all excel windows and try to reopen the file.