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 Quickbase. 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 Quickbase 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 Quickbase features
Once you get your data into Quickbase, 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 Quickbase, you may want to restructure your data, breaking it out into multiple tables where appropriate. This is a two-step process.
-
Design your Quickbase app. Not sure which columns should become tables? Learn how to plan application structure.
-
After you've made a plan, read how to split columns out into separate tables using Quickbase'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:
-
Restructuring data you've imported to Quickbase: Converting a column into a table