Answer

The format of your CSV template is based on your export separator preferences. To ensure your exported data is properly organised into separate columns, it's crucial to have the correct export separator. Using the wrong separator can cause your file to compress into a single, unreadable column. The correct export separator preferences can be configured in your account settings.

Background

Typically, European users should set their export separator to a semicolon (;), while most other users should use a comma (,). However, this can vary depending on your computer system. If your exported data appears in a single column, please verify your export separator setting by following the steps below and try switching to a semicolon or a comma.

Steps

To change your export separator settings:

1. Sign in to your NQC account.
2. Select your initials in the top right corner of the screen.
3. Select 'Account settings'.
4. Choose 'Personalisation' from the dropdown menu.
5. On the 'Personalisation' screen, click 'Edit' below the 'Personalisation' section.
6. Within the 'Export separator' field, select the correct export separator (typically a semicolon for European users, and a comma for other users) and click 'Save'.
7. When the correct export separator preference has been saved, your CSV template should be separated into distinct columns.