Exporting a CSV File with or without an Import

When you export a CSV data file from the sheet, the numeric fields display according to your Preferences settings (the number format options settings). The following provides additional information:

  • In functionalities that allow export and import of data through a CSV file, the currency symbol and digit grouping symbol are not displayed.
  • In functionalities that allow only exporting of data but not importing data through a CSV file, the currency symbol and the digit grouping symbol are displayed.
  • In Unifier functionalities that allow only exporting of data but not importing data through a CSV file, the negative numbers display according to your Preferences settings.
  • Decimal symbol display according to your Preferences settings.
  • In functionalities, which allow exporting and importing of data through a CSV, the negative numbers, if any, displays as: -<Number, Decimal Symbol, Number> (Example: -100000,99 - The decimal symbol is comma)
  • If there are any date fields, the dates are formatted based on your Preferences settings.