Create an Application by Importing Data

You may have turned to QuickBase to help you track a process that's well under way. In that case, you've probably already entered a lot of data in another application and don't want to lose it.

Not only can you get this data into QuickBase, you can put it to work by using it to help you create a new application. QuickBase is smart enough to look at your data and create an application based on its format. In other words, you can import data and create an application with it at the same time.  

If your data is in Microsoft Excel 2007 or later, you can import an .xlsx file directly into QuickBase.  If your data is in a different application, you'll need to convert your data into the form of a .tsv or .csv file before importing it.

To learn how to import data from a Microsoft Project file, see Importing Project Data into QuickBase.

To create an application by importing data:
  1. Check and fix the formatting of your source file.

    The data you're importing must be in a format that's compatible with traditional database tables. Some spreadsheet programs like Microsoft Excel allow data anarchy that QuickBase won't tolerate. Read how to format your data for an easy import.

  2. If your data is in Microsoft Excel, you can import the .xlsx file.  Otherwise, open the file in the original program that created it, and export the file as a tab-delimited (.tsv) or comma-delimited (.csv) file. (If there's no Export command, try Save As and specify either file type.)

    Tip: If you only want to import a portion of your file, you can use a simple copy and paste approach instead. Read more.

  3. Sign in to QuickBase, and access the Add a New QuickBase Application page.

  4. Click the Import tab.

  5. Select From File and click Next.

  6. Click Browse to display the Choose file dialog box.

  7. Select the file that you want to import, click Open, and then click Next.

    QuickBase analyzes your data, and then displays the results.

    Import Analysis Results
    - You can change field types or exclude a column from import. Read on to learn how.

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

  9. When you're done checking results, click Create.

  10. Tell QuickBase what you want to call your application and the records in it.

    Within the Application Name box, type in a title for you application. Then within the Items in this application are called box, type in the term that best describes the records in your table. If you do, QuickBase uses this term instead of the more general word "record." For example, if you're managing staff assignments you might type in tasks.

    When you're done, click OK.

    QuickBase displays your new app's Home page.


Return to top   

© 1999-2016  QuickBase, Inc.  All rights reserved.  Legal Notices.