CSV input/output matrix
This table explains the formatting options when CSV or Excel CSV is selected as the export file format in Sage CRM.
|
Input |
|||
|---|---|---|---|
|
Export File Format |
User Preferences Delimiter |
Contains Extended Characters |
Delimiter |
|
CSV |
Comma |
No |
Comma |
|
CSV |
Semicolon |
No |
Semicolon |
|
CSV |
Tab |
No |
Tab |
|
CSV |
Comma |
Yes |
Comma |
|
CSV |
Semicolon |
Yes |
Semicolon |
|
CSV |
Tab |
Yes |
Tab |
|
Excel CSV |
Comma |
No |
Tab |
|
Excel CSV |
Semicolon |
No |
Tab |
|
Excel CSV |
Tab |
No |
Tab |
|
Excel CSV |
Comma |
Yes |
Tab |
|
Excel CSV |
Semicolon |
Yes |
Tab |
|
Excel CSV |
Tab |
Yes |
Tab |
|
Output |
|||
|---|---|---|---|
|
Encoding |
Padding |
Renders correctly in Excel |
Example |
|
UTF-8 |
No |
No |
Test 01,00001,”Test, 02” <CR LF> |
|
UTF-8 |
No |
No |
Test 01;00001;Test, 02<CR LF> |
|
UTF-8 |
No |
No |
Test 01<Tab>00001<Tab>Test, 02<CR LF> |
|
UTF-8 |
No |
No |
Test 01,00001,”Test, 02” <CR LF> |
|
UTF-8 |
No |
No |
Test 01;00001;Test, 02<CR LF> |
|
UTF-8 |
No |
No |
Test 01<Tab>00001<Tab>Test, 02<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
|
UTF-16 LE |
Yes |
Yes |
=”Test 01”<Tab>=”00001”<Tab>=”Test, 02”<CR LF> |
