Logo
English (US) Español
Submit a request Sign in
  1. Verticalresponse
  2. Vertical Response Classic (VRC)
  3. Lists
  4. List Upload

List Import Error: Incorrect number of fields

Avatar
Karissa
January 12, 2021 12:51
Follow

This error usually comes up when there is a formatting error in the list (csv/txt) file. We usually see this when there are delimiters in the data column for the file - when commas are within a cell in your .csv file or if tabs are within a cell in a .txt file. The most direct fix would be to delete any unnecessary columns from your file prior to import.
 
Your file must contain email addresses but all other columns are optional and only useful if you intend to mail merge or segment new lists with the data. For example, columns with Street Address data often have commas in the data and few customers would find it useful to include a customer's street address in an email or to segment a list on this data.

If you have data entries that have commas in the data entries and you want to separate them into separate columns, you can do so using the text-to-columns tool on Excel's data menu.You can learn more about this tool here: http://support.microsoft.com/kb/214261

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

  • Can I create a new list from an external file in Salesforce?
  • How do I import my contacts from Hotmail?
  • What is the purpose of the Message Inbox in my VR account?
  • How do I import my contacts from Outlook?
  • How do I import my contacts from Yahoo?
  • Why am I having difficulty importing my list?
  • Exporting Address Book on a Mac
  • How do I see who got rejected from my list upload and why?
  • How do I import my contacts from Gmail?
  • How do I add one or more email addresses to an existing list?
See more

Can't find what you're looking for?

Let us help you!

Submit a request

Copyright © 2011-2021 VerticalResponse. All rights reserved.

Powered by Zendesk