CSV (comma-separated values) files generally use commas to separate fields. However, some software applications export CSV files where "character-separated values" is used instead, meaning separators can include characters like semi-colons or tabs. If the field separators don't match your system's settings, data importing into VanillaSoft could fail. Follow one of the solutions below to ensure seamless CSV imports.

Possible Solutions:

1. Computer Set to English:

   • Open the file in Excel.
   • Re-save it, choosing CSV (Comma delimited) as the file type. This will standardize the file's field separator to commas.

   ---

2. Computer Set to a Non-English Language:

   • Go to Windows Control Panel.
   • Open Region and Language.
   • In the Formats tab, click Additional settings.
   • In the Numbers tab, find the List separator option and open the drop-down.
   • If a comma is available, select it and click OK.
   • If no comma option exists, cancel the current screen, then choose either English (US) or English (Canada) from the Format drop-down.
   • Click OK to confirm your choice.

   Note: If this method changes the date and number formats within your operating system, consider reverting to the original settings after saving your Excel file to CSV.

Understanding how field separators work and adapting your settings will ensure that data is imported accurately into VanillaSoft. Whether your system is set to English or another language, these steps help make sure that the CSV files you're importing are in the proper format. This minimizes compatibility issues and improves data processing efficiency.