How to Import Your Data into an Existing Table

00:01: From uploading the file to completing the import process, this guide will walk you through each action required to import data into an existing table in Knack. 00:14: After selecting the table that you would like to import your data file into, select the Records view, and then select the import icon. 00:25: You will then be directed to where you can import your data file by dragging and dropping the file into the upload area highlighted, or by selecting the file from your computer. 00:38: Once you have uploaded your data file, you can then define the headers of your data. First, select whether or not the first row of your data file consists of column headers, then select the "Next" button. 00:53: Here, you can choose whether or not you would like to update existing records in the data table. After selecting yes or no, select the "Next" button at the bottom. For this example, we will need to select "Yes". 01:08: During the Map Columns step of the import process, you have the opportunity to link every column in your data file with the corresponding field in the table. The column chosen for each field position on the left determines where the data from that column will be imported. After assigning columns to fields, select the "Next" button. 01:31: Upon reaching the confirm your import page, you'll encounter a summary detailing the number of records slated for import and the specific table they'll populate. Additionally, at this stage, you're presented with the opportunity to assign default values for any empty or absent fields not included in the data file. 01:53: For this example, I have selected the Instructor field since the imported data file did not include any data to import for the instructors. 02:04: Given that the instructor field in the current table is a connection field, the second input permits me to choose a pre-existing record from the connected table to serve as the default value for the records that I am preparing to import. However, if the field you select in the first input is not a connection field, you will be able to manually input a value instead. 02:29: You can further include default values for fields by clicking on the plus sign icon located to the right of the field selection input. Conversely, clicking on the "X" icon will remove your selection. After selecting any defaults that you would like, you can then confirm your import by selecting "Start Import". 02:51: Upon completing the import steps, you'll return to the Builder's Record view of your table. Here, you'll encounter a progress bar displaying the advancement of the import task showcasing details such as the number of records processed and the percentage of completion. Additionally, you'll have the option to cancel the import if necessary. 03:14: Upon the completion of the import task, you'll have the ability to close the import progress bar notification and proceed to view the newly imported records. 03:25: Select all the listed fields. 03:28: This guide covered the process of importing a data file into an existing table in your Knack app. Thank you for watching!