I'm getting an error when importing. What do I do?

Lesley Updated by Lesley

There are two import errors that can pop up sometimes for users:

  • Error: Number of columns is inconsistent at line {line number}
  • Error: Invalid opening quote at line {line number}

Both can typically be fixed by recreating the import file within a Google Sheet and exporting to CSV. This helps with any underlying formatting issues that were causing the errors.

If recreating the import file through Google Sheets doesn't get rid of the error, then we are happy to help troubleshoot this for you! To get started we will need the following information:

  • A link to the table where you're importing the file
  • A sample copy of the file you're importing that includes the line mentioned in the error

Send that information to support@knack.com or send us an in-app message and we'll be happy to troubleshoot it for you!

How did we do?

My import is taking a long time. Can you take a look?

Do the validation rules on fields trigger when importing data?