Troubleshooting: CSV Files are Opening Incorrectly

Due to your computer regional settings, when you open a CSV file all your data might appear in one single column separated with commas. Follow the below steps to fix it.

Steps for a Windows Computer
  1. Open Control Panel
  2. Navigate to "Clock and Region" and click "Change date, time, or number formats"
  3. Click "Additional settings"
  4. Set "Decimal symbol" to . and "List separator" to ,
  5. Click on "Apply" to save the changes
  6. Open the CSV file again
Steps for a macOS Computer
  1. Open System Preferences
  2. Navigate to "Language & Region" and click the "Advanced" button
  3. Under the "Number separators", set "Grouping" to , and "Decimal" to .
  4. Save the changes
  5. Open the CSV file again