Solved

Trying to upload a list (CSV) and keep getting error message: "Duplicate Headers"

  • 14 June 2021
  • 3 replies
  • 3902 views

Badge +2
  • Contributor I
  • 0 replies

Hi all,

 

Strange because I have done this many times before, but I am attempting to upload a list and it keeps saying “duplicate headers” when there are no duplicate headers. I have tried with different files and I keep getting the same message. Has anyone had this happen before? I only have three columns (First Name, Last Name and Email. When I try to copy and paste, I get the same message and when I try to remove the header altogether, I still get the same message. Any help appreciated.

 

icon

Best answer by Dov 15 June 2021, 15:38

View original

3 replies

Userlevel 7
Badge +61

Hello @Hiba,

Thanks for sharing your question with the Klaviyo Community.

In most cases, the duplicate headers error is referring to duplicate blank column headers. The solution is to remove any additional blank columns in your .csv file. Also, ensure when you are uploading that all data types are set to the “string” data type.

This should resolve the issue for you.

 

Badge +3

Hi @Dov , how do you delete those blank columns headers in the file? I'm getting the same issue 

Userlevel 7
Badge +61

Hi @karentiamson21,

Thanks for your question.

Here’s some information from this guide on how to highlight these columns: “To select multiple adjacent rows/columns at once, just select the first one by clicking on the row number or column alphabet and drag the cursor till the last row/column you want to select”

Then, hold the Control key + click on mac (or right-click on pc) and select “Delete Columns” for that range.

 

Reply