Presentation of the different options for the CSV format :
- Check the box Export CSV by default if you want this custom CSV to be the one taken by default (for example for Drobox).
- CSV Windows format (recommended to open the file with Excel): This allows you to read a CSV file in Windows Excel format.
- Empty cells management (CSV): this allows you to decide whether you want empty cells to be duplicated or left empty.
- Separator: you can decide whether your data should be separated by a comma or a semicolon.
- Enclosure: select the character that will surround the values.
- Date format: Select the desired format.
- Decimal separator.
What is the difference between separator and delimiter?
Let’s take the example of a typical site supervision report form. We enter in the same data: “Abby Smith” ( in our Project Manager field) and “Carl Davis, Cassie Jones” (in our contractor field). By default, the information will appear like this in our CSV: Abby Smith, Carl Davis, Cassie Jones. However, how do we know which name corresponds to which position? To do this, you need to set up a separator and an enclosure.
Thus, if we define "
as en enclosure and ,
as a separator, our data will come out like this: “Abby Smith”, “Carl Davis, Cassie Jones”; we will thus be able to easily identify our project manager and our contractors.
The most common formats are :
- Separator:
,
and an empty enclosure,
- Separator:
,
and "
as the enclosure,
- Separator:
;
and an empty enclosure,
- Separator:
;
and "
as the enclosure.
Post a comment