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

This short article provides guidance for resolving any issues or obtaining assistance when you encounter difficulties importing your data.

There are two importing errors that can pop up occasionally for users:

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

  • Error: Invalid opening quote at line {line number}

Recreating the import file within a Google Sheet and exporting it via CSV is usually an effective solution for resolving both errors. This process addresses any underlying formatting issues that may have caused the errors to occur.

If recreating the import file through Google Sheets doesn't get rid of the error, we are happy to help troubleshoot this with 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

  • Approximate date/time of when the error last occurred
  • The error (if available) you're running into when attempting to import

You can send that information to our support team via the chat widget in the Builder or by submitting this form here.

 

Note:

Running into a different error than the two mentioned above, or are not seeing an error at all? Please still reach out to our support team with the information listed above, and they will be happy to investigate the cause and help you finish your import job.