Error parsing CSV

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi,

I can't open a support ticket with QB about this, I just keep getting the word "Error" when I submit a ticket. I've tried for 2 days, even in an incognito window, and no luck. So I have to come here, I hope someone is able to help.

I'm getting "Error parsing csv. Unescaped quote found in cell. Error located on row: 9" when I try to update a connected table via Google Drive. I can't find on the Excel sheet any issues with row 9 and yet the sheet keeps failing to update.

What exactly should I be looking for? There are no quotes in any cells so I don't know what it's talking about. I've cleared all of the empty cells in the rest of the sheet. Please help, thanks.
Photo of James Trory

James Trory

  • 946 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,948 Points 10k badge 2x thumb
Hi James,

Have you been getting an error message when attempting to submit a Support Case with our Care Team? Do you get the same error when using this Support Case link? I do see that you have a support ticket in from today when I pull it up on our end but it sounds like you are getting an error message which is causing issues with viewing it. Our Care team can help take a look at both issues with you and the error you are seeing on your Sync since it sounds like there is some special character that is being identified in the data and looking at it might help to get to the source of what is going on with your Sync. 
Photo of James Trory

James Trory

  • 946 Points 500 badge 2x thumb
I realized that it was trying to attach the CSV that was causing the error in submitting the ticket. I removed the attachment and I could then open the ticket.