Import Data from Outside QuickBase

You can get a new application off to a running start by importing a file to create an application or by pasting data to create an application. If work on your application is already well-underway, you can still import data from outside of QuickBase at any time. To import data into an existing application, you can either:

When you import data into an existing application in QuickBase, QuickBase either adds the new records to an existing table (a normal import), or replaces existing QuickBase records with those that you import (an update import). QuickBase decides which type of import you want based on whether or not you import data into the destination table's key field.

If you have chosen to import data into a key field, QuickBase checks to see if there's a match between any value you import into a key field and any value that already exists in the key field in your table. If it finds a match, QuickBase updates the matching record with the new data you're importing. If it doesn't find a match, QuickBase creates a new record.  

For example, imagine you have an application that manages language classes your business offers. In the Course table, you change the key field from the Record ID to the Course ID (which you know will always be unique). Records in your app might look like this:

Now, let's say you copy and paste the following data into the Import from Clipboard feature: 

Course ID, Course name, Description

201009, Advanced French, "This course describes how to build complex sentences, etc."

201111, Italian for Beginners, "This course covers basic Italian vocabulary, conversation, etc."

Because you are importing into your key field (Course ID), QuickBase checks to see if there's a match between any value you're trying to import into your key field and an existing value. In this case, it finds a match in Course ID 201009.

Therefore, QuickBase takes the following actions:

Read more about formatting data for import by pasting, and importing blank values.

Copy and paste data from another program

To copy and paste data from another program:

  1. In your source document, highlight the text that you want to copy, and choose Copy from the Edit menu.

    You can copy tables from a word-processing document, or specific rows or columns from a spreadsheet program.

  2. Open the QuickBase application into which you want to paste the data.

  3. If your application has multiple tables, select the table into which you want to import data.

  4. Choose Import/Export from the More dropdown.

  5. Select Import into a table from the Clipboard.

  6. In the Paste Data section, paste the data that you want to import.

  7. Click Import Data.
    QuickBase analyzes your data, and then displays the results.

  8. Check the Import Data page to ensure that the field labels for each field (column) are correct and that the data is properly aligned. To do so:

  9. Click Import.

    If the import creates new fields, QuickBase displays a warning message asking you to confirm the action. If this isn't your intention, click Cancel, then edit your import (refer back to Step 8). Otherwise, click OK.

    QuickBase tells you how many records you created or updated.

    Note: If the program created placeholders to populate a User field, QuickBase displays the number of placeholders created. A Replace Placeholders link appears in the explanatory text. Click Replace Placeholders to convert placeholder values to real users. You can do this at any time.

  10. To access the application, click Go to the App Home Page.

Import data from a file

To import data from a file:

  1. If your data is in Microsoft Excel 2007 or later, you can import the .xlsx file.  

    Otherwise, open the file in the original program that created it, then export the file as a tab-delimited (.tsv) or comma-delimited (.csv) file. If there's no Export command, click Save As and specify either file type.

    Tip: If you have rows that contain explanatory text, remove them before you save the file as a tab-delimited (.tsv) or comma-delimited (.csv) file. Import only column headings and records into QuickBase. Doing so helps the program analyze the structure of your data.

    If you import data from a Microsoft Excel file, read more about importing data from Excel into existing applications. If you're importing from Microsoft Project, the process is slightly different. Read about importing Project data into QuickBase.

  2. Open the QuickBase application into which you want to import data.

  3. If your application has multiple tables, select the table into which you want to import data.

  4. Choose Import/Export from the More dropdown.

  5. Click Import into a table from a file.

  6. In the Choose file section, click Browse, select the Excel (.xlsx), comma-delimited (.csv), or the tab-delimited (.tsv) file that you want to import, then click Open.

  7. Click Import from File.

    The Import Data page displays, showing you how QuickBase will structure the import.

    Note: QuickBase may display a warning prompt to let you know that you're about to perform an "Update import" (see Tip above). If you don't want to do so, remove the key field from your import. To remove it, locate the field and click Do Not Import at the top of the column.

  8. Check the Import Data page to ensure that the field labels for each field (column) are correct and that the data is properly aligned. To do so:

  9. Click Create.

    If the import creates new fields, QuickBase displays a warning message asking you to confirm the action. If this isn't your intention, click Cancel, then edit your import settings (refer back to Step 8). Otherwise, click OK.

    QuickBase tells you how many records you created or updated.

    Note: If the program created placeholders to populate a User field, QuickBase displays the number of placeholders created. A Replace Placeholders link appears in the explanatory text. Click Replace Placeholders to convert placeholder values to real users. You can do this at any time.

  10. To access the application, click Go to the App Home Page.

Importing from a relational database

Before you import data from a relational database into a QuickBase application, decide whether you want the application to preserve relationships based on the primary and foreign key fields in the relational database.

To import data without preexisting key fields:

  1. Export the data from the relational database to Microsoft Excel (2007 or later) files, comma-delimited (.csv) files, or tab-delimited (.tsv) files.

  2. You can do one of the following tasks:

To import data with preexisting key fields:

  1. Export the data from your the relational database to Microsoft Excel (2007 or later) files, comma-delimited (.csv) files, or tab-delimited (.tsv) files.

  2. Create a new QuickBase application from scratch with a table and field structure that matches the relational database structure.

  3. In QuickBase, change the key field of each table so that it corresponds to the key field in the relational database.

  4. Import the file for each table into QuickBase. The relationships are now set according to the key fields in the imported data. The exceptions are:

 

Return to top   

© 1999-2014   Intuit Inc.  All rights reserved.  Legal Notices.