Importing customer contacts - error messages

Here is a list of error messages that may occur while importing customer contacts and how to fix them.

If you are unsure of the file format required when importing from Excel, download our Excel template from Reveal’s Import customer contacts section.

 

Error message: File too large
The file you are trying to upload is too large. You can only import a maximum of 10,000 contacts per file.
These are the maximum file sizes, per file type:

  • CSV: 20 MB
  • XLS: 10 MB
  • XLSX: 5 MB

What to do
Cut and paste some contacts into another file or files, so they are not above the maximum file size.

 

Error message: Incorrect file type
For your import to be successful, you must use Excel (XLSX or XLS) or CSV (UTF-8) files.

What to do

  • Download the Excel template from the Import customer contacts section of Reveal.
  • Copy and paste the data across to the template.
  • Save it to your device.
  • Select UPLOAD FILE.

 

Error message: The file has more than one sheet
All files being imported must have a single sheet.

What to do
Open the file, copy any information you want to import onto one sheet and delete the other sheets.

 

Error message: The file has the same column heading twice
The file you uploaded has the same column header more than once, for example the column header Email is used twice in the document.

What to do
Open the file and rename any column heading that appear more than once. Try to upload again.

 

Error message: The file does not have enough columns
The minimum number of columns needed to import contacts is two.

What to do
Open the file and ensure the file has more than two columns.

 

Error message: The file is missing content
The file you tried to upload is empty, or just the first row or column is empty.

What to do
Open the file and ensure the customer details are saved in the file, and that the first row or column are not empty. Upload the file again.


Was this article helpful?


0 out of 0 found this helpful