CSV Files, or Comma-Separated Value Files to give it it's full name, are files that contain data usually with a comma to separate each bit of data.
eg: David, Smith, Male
Sometimes other delimiters are used such as semicolons, but in Databowl we ideally need these files to be separated with a comma.
Please see below some methods you can use to replace semicolons with commas:
Method 1 - Notepad
Right-click on the file. Select Open with Notepad
Click the Edit menu. Select Replace
Enter a semicolon ';' into the Find what box
Enter a comma ',' into the Replace with box
Click the Replace all button
Close the Replace window
Save the file as a .csv
Method 2 - Export Settings
In your software, like MS Excel, Select File > Options > Advanced.
Clear the check box 'Use system settings'.
Set 'Decimal separator' to a point (dot), and 'Thousands separator' to a comma.
Click OK.
Export to CSV.
Select File > Options > Advanced.
Tick the checkbox 'Use system settings'
Click OK
Method 3 - windows Preferences
Click on the Start menu
Type control panel
Click on Control Panel (Desktop app)
Select Clock, Language, and Region
Click Region
Select Additional settings in the pop-up window
Change the List separator to comma
Click Apply
Hit OK
Once done, try saving your CSV file and check if you will see comma instead of a semicolon.
TEST TEST TEST
When you work with anything like data, the best way to guarantee things work is to test.
So once you've exported the file, open it back up in your software to make sure the data matches the columns as expected.
Please note: If your data has commas in it, say a single line for an address or some notes, then this may cause issues.
Now you should be ready to import.