List Import Data Value Change | Community
Skip to main content
A
Anonymous
November 14, 2014
Question

List Import Data Value Change

  • November 14, 2014
  • 2 replies
  • 1095 views
I'm uploading a CSV file with a list of names from the tradeshow into Marketo. However, during the list imports about 3/4 of the company names are changed to "[n/a]" while the remaining 1/4 of company names are imported without a problem. I've checked the file and everything seems to be formatted correctly. Can anyone give any insight as to why some company names are accepted but the majority are changed?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

A
Anonymous
November 14, 2014
I have had similar issues before with CSV, even though everything looks good.  If you are on a PC, try downloading Notepad++ and then open the csv file in there and view it.

Depending on how the data was inputted into the csv or where they were acquired from, sometimes hidden invalid characters show up.

If that shows nothing, try opening in notepad or ++ and convert to plain text, then reimport back into excel and create a new .csv.

Hope this solves your issue.
Kenny_Elkington
Adobe Employee
Kenny_ElkingtonAdobe Employee
Adobe Employee
November 14, 2014
Abel, could you provide a sample value where this occurred?
Terms & ConditionsAccessibility statement

Loading footer...