CSV File won't import because it has semi-colons as seperators instead of commas

When customer have contacts in an Excel file and they export it to CSV, semi-colons are used as column seperators instead of commas. We have seen this mainly occur on French operating systems. It may also happen in other languages than French, but it is not an issue when configured for English.
 
Here is how it can be fixed:
 
1. Go to the Windows Control Panel
2. Open the "Region and Language" item
3. At the bottom of the Formats tab, click "Additional settings"
4. On the Numbers tab, find the "List separator" option and open the dropdown menu.
a. If it has a comma option, select it from the dropdown and click OK on all boxes.
b. If there is no comma option, then click Cancel from that screen. Then open the Format dropdown and choose English (US) or English (Canada). Click OK.
5. Now when you save the Excel file to CSV, the seperators are commas and the file will import properly into VanillaSoft.
 
NOTE: If you had to use method 4.b, then of course that will change your date and number formats within your Windows operating system. You may want to revert that to its original setting after having saved your Excel file into CSV format.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk