Table of Contents

Some of my fields aren't importing correctly. How can I fix that?

Danielle Kellogg Updated by Danielle Kellogg

Check Your Matching: Columns to Fields

The first thing you want to check if some of your fields aren't importing is whether you're matching the right fields for those columns when importing.

For example, in the import below you'll see that the Email column in the import file was incorrectly matched to the First Name field within the table when first uploaded and vice versa:

That can be fixed by selecting the correct field from the options list next to "Map to" for that column.

So review your import at this step in the process to ensure that all the columns are matched up with the correct fields.

Check Your Matching: Updating Existing Records

When updating existing records, you need to match one of the columns in your import file to one of the fields in your table. That's how the system knows which record in your app to update based on the rows in your import file.

You need to match on a unique field when updating records using an import. Auto Increment fields are perfect for matching because they are always unique, though there are several field types that can be set to "Must be unique":

We don’t recommend matching on a Name or Address field because they can’t be set to unique and we’ve seen users run into issues with them. We’re working on improving this for those field types.

Fields Still Not Importing

If you went through the items above and your fields still aren't being imported correctly, 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
  • The estimated date/time of your last import

Send that information to support@knack.com or through an in-app message and we'll take a look!

How did we do?

I'm having trouble importing into a specific type of field. What can I do?

I'm having trouble importing into a connection field. What can I do?

Contact