Importing data from Excel to create new apps

You can create a new app from Microsoft Excel by importing the .xlsx file or copying and pasting only the data that you need.  

Step one: Clean up your Excel spreadsheet

For best results, your data must fit the structure that works well in Quick Base. Clean up before import, and you'll save yourself work later. Read Preparing Excel data for import.

Step two: Create a new app by importing the data

You can turn your spreadsheet data into a Quick Base app in one of two ways:

  • Importing the Microsoft Excel (.xlsx) file. Read more about importing files.

  • Copying and pasting only the data that you want. To do so, click and drag to select cells within the spreadsheet. Read more about importing by pasting data.

Step three: Restructure your data to take advantage of Quick Base features

Once you get your data into Quick Base, your work isn't necessarily done. Your app is a relational database, which lets you organize data into separate tables that are linked to each other. This model is very different from a flat Excel spreadsheet. To get the most out of Quick Base, you may want to restructure your data, breaking it out into multiple tables where appropriate. This is a two-step process.

  1. Design your Quick Base app. Not sure which columns should become tables? Learn how to plan application structure.

  2. After you've made a plan, read how to split columns out into separate tables using Quick Base's handy "convert column to table" feature. This useful tool lets you convert a column into a master table that's automatically related to the original table.

Related topics: