CSV file list import into Marketo - Import Fail due to unclosed quotation - How do I fix? | Community
Skip to main content
A
Anonymous
October 26, 2015
Question

CSV file list import into Marketo - Import Fail due to unclosed quotation - How do I fix?

  • October 26, 2015
  • 4 replies
  • 8494 views

Hi,

Can you please assist with a basic list import i'm trying to run.  For some reason I keep getting the error below ''Import Failed - Due to unclosed quotation.'' 

Thanks,

Marianne

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    4 replies

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    October 26, 2015

    Hi Marianne,

    Is you file a CSV? Is it encoded in UTF8? Before generating it, have you removed all commas and " ?

    -Greg

    Kenny_Elkington
    Adobe Employee
    Kenny_ElkingtonAdobe Employee
    Adobe Employee
    October 26, 2015

    I would bet that one of your column names has a line break in it somewhere.  Try removing this and reimporting.

      R
      rachazen
      Level 6
      August 11, 2016

      I was having this same problem, but this solved it! Thanks @Kenny Elkington​!

      A
      Anonymous
      October 26, 2015

      Hi Gregoire & Kenny,

      Yes it is a CSV file and I have imported lists into Marketo before without any issues.  I have  removed all the visible '' "  with the 'Ctrl F' function and have removed all line breaks but it still wont import. 

      It is extremely bizarre.

      Grégoire_Miche2
      Grégoire_Miche2
      Level 10
      October 26, 2015

      Hi again Marianne,

      Are you sure you do not have a comma in a text (quotation enclosed) field?

      -Greg

      Diana_Jakubaity
      Diana_Jakubaity
      Level 4
      March 1, 2018

      The solution:

      I was having exactly the same issue over and over again.

      To remove the error and be able to upload the file, make sure that you don't have any ,commas, "quotation marks" or even /slashes/ within your cells in excel (any separator marks). If you do, just CTR+F and Replace all with no value.

      I also remove all hidden formatting just in case. But removing separators always works for me now!

      SanfordWhiteman
      SanfordWhiteman
      Level 10
      March 1, 2018

      But that's not an acceptable workaround, as those are totally valid values (for example, "Company Name, Inc." is the correct way to store that value).  Quotation marks are often used to indicate inches, as well as for nicknames.

      All of these delimiters are supported if properly escaped; there's even an official internet standard for CSVs!  Using a dedicated CSV editor like Ron's Editor (one of my favorite apps) insread of Excel avoids all such issues.

        Diana_Jakubaity
        Diana_Jakubaity
        Level 4
        March 1, 2018

        Thank Sanford for sharing - good to know.

        However, I tried Ron's Editor, it is super not user friendly... feels like using Excel 8-10 years ago. Just my personal experience.

        Terms & ConditionsAccessibility statement

        Loading footer...