Data Load Record Handling and Requirements

Use the Load from File option to import data records from a delimited text file directly into an existing List. There is a limit of 5,000 records for uploading. If you need to upload more records, we strongly suggest that you use a Connect job. These are the requirements for uploaded files:

  • Character to Quote field values as Double Quotes (") and None only.
  • Character Separator - Comma Only
  • File must have header

Notes

  • Blank and/or null characters are stripped from the beginning and end of fields (columns) in imported data. If necessary, it also truncates data fields to fit into the field lengths you specify.
  • Timestamp fields must have the format yyyy-mm-dd hh:mi:ss (anything after the ss segment is truncated).
  • For text fields – Any blank lines are removed from those text fields.
  • For mobile number fields - See Mobile number data import handling in Responsys.

Import Speed

Importing can be slowed for various reasons, including:

  • Data fields of type MEMO (Long Text)
  • Source data that is both tab-delimited and double-quoted
  • Ignored columns

Learn more