Line Breaks and Multi-Line Fields

When you upload a .csv file that contains values with multiple lines, the value is inserted exactly as it appears into the field in the Big Table, without any automatic trimming.

In Salesforce, standard text fields do not support line breaks or multi-line content.

Field Type	Data in the .csv or .txt File	Data Inserted in the Big Table Record
Text	“Testing with line 1 Testing with line 2 Testing with line 3"	Testing with line 1 Testing with line 2 Testing with line 3
Text Area and Text Area Long	“Testing with line 1 Testing with line 2 Testing with line 3"	Testing with line 1 Testing with line 2 Testing with line 3

Field Type

Data in the .csv or .txt File

Data Inserted in the Big Table Record

Text

“Testing with line 1

Testing with line 2

Testing with line 3"

Testing with line 1 Testing with line 2 Testing with line 3

Text Area and Text Area Long

“Testing with line 1

Testing with line 2

Testing with line 3"

Testing with line 1

Testing with line 2

Testing with line 3

Tip:

The double quotes (") used for enclosing text in the .csv file are removed automatically after import.