Skip to content

Bika Lab Systems

Personal tools
You are here: Home Help Centre How-tos How to set the field separator for .csv files in Windows
Document Actions

How to set the field separator for .csv files in Windows

This How-to applies to: Any version.

Instrument results imports to Bika's LIMS via .csv comma separator files will fail if the incorrect field separator is used. This howto describe how to set this on Windows XP

In Windows XP the csv field separating character is determined by a 'Regional options' setting which affects how .csv files are saved which in turn might render the files incompatible with the templates used in Bika. See the different import file formats and examples on the downloads page at

To set your Windows XP to the corresponding setting, navigate via the Control panel from the Start menu and select Regional and language options. Click [Customise] and set the List separator to the correct character and press [OK] 

Thanks Rickus Adams at BBK laboratory - Home of Bika Lab Systems, implementers of web based open source LIMS, Plone hosting and content management systems   Powered by Plone, the open source content management system. Customised and maintained by Bika Lab Systems