Create an Application by Importing Data

You may have turned to Quick Base 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 Quick Base, you can put it to work by using it to help you create a new application. Quick Base 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 Quick Base.  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 Quick Base.

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 Quick Base 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 Quick Base, and access the Add a New Quick Base 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.

    Quick Base 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 Quick Base 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, Quick Base 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.

    Quick Base displays your new app's Home page.


Go back      |       

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