Solved

Trouble Importing Suppression list.

  • 30 June 2023
  • 6 replies
  • 217 views

Badge +4

Trying to upload CSV here https://www.klaviyo.com/people/suppressed/import

 

and it tells me "The file specified has more than one column. Please limit to one column with an email address.”

 

That’s not true. What’s the problem?

icon

Best answer by retention 30 June 2023, 05:59

View original

6 replies

Userlevel 7
Badge +57

Hi @blissy, welcome to the community!

So when you see that error, it’s because your CSV has more than one column.  Make sure it’s only an email address (one per line), with no additional columns (like First Name, or other data).

If you think your CSV only has email addresses and no other columns and you are still getting an error, it might mean that your CSV may have empty columns on it.  Try deleting any columns (even if it appears empty) in your spreadsheet then saving it again as CSV.  Another way to check is to open the CSV with a text editor and see how many “commas” are in there.  There should be at most one comma, or none at all.  

Hope that helps!

 

@blissy @retention I am having the same issue too and tried deleting columns and checking how many commas there are. I spoke with live chat who can’t figure it out either and had to escalate it.

Userlevel 7
Badge +60

Hi there @casey

 

I saw that one of our support representatives responded to you with a possible solution, happy to see that! 

 

For anyone else struggling with this, it should be noted that formatting issue are typically the culprit with uploading CSVs. If you’re experiencing a similar issue, ensure the word "email" is removed from your column and only have the customer emails in your spreadsheet. 

 

Additionally, it’s recommended to use a brand new document in Google sheets to make ensure there is no extra formatting being added. 

 

Thanks for participating in the Community!

-Taylor 

Badge +4

There was only 1 column but the problem is that some of the emails contained characters such as , and “

Once I cleaned those up, it imported. I suggest the tech team edits the error message to make it more versatile and provide more potential reasons for the problem.

Badge +4

Another bug. It gets stuck on this and never says “import finished” even though it has.

 

 

Userlevel 7
Badge +60

Hello @blissy,

Thank you for sharing those feedback and bringing it to our attention! I’ll be sure to route that suggestion to our product team. 

Thanks for being a part of our Klaviyo Community!

David

Reply