Help Guides

CSV Files

CSV are text based files useful for importing and exporting data reliably. CSV stands for Comma-Sperated Values and as the name suggested, it's literally information separated by commas. This means no matter what software you use to created the CSV, besides the text itself, nothing else is stored e.g. formating and row/column height/width.

Important to remember:

Software such as Microsoft Excel tend to format dates automatically so always ensure dates show correctly in the text area of the software no matter how it shows. See guidelines on the import/export pages to ensure the dates are in the correct format.
The downloads page has a free simple CSV editor to ensure all data is accurate
Sometimes, empty rows are added so you must ensure there's no empty rows at the end. The simplest way is to open the CSV in notepad and make sure there's no rows at the end with recurring commas (i.e. ,,,,,,)
Ensure there's no empty rows at the top. Sometimes for readability users change column headers and add empty rows. This will cause errors when importing into any program.