You can create a new application from Microsoft Excel by importing the .xlsx file (from Microsoft Excel 2007 or later) or copying and pasting only the data that you need.
You may not think your Excel spreadsheet is sloppy, but if Quick Base thinks so, you'll have trouble importing it into your new application. 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 Prepare Excel Data for Import.
You can turn your spreadsheet data into a Quick Base application in one of two ways:
Importing the Microsoft 2007 or later 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.
Once you get your data into Quick Base, your work isn't necessarily done. Your application is a relational database, which lets you divide 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.
Design your Quick Base application. 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 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.
Restructuring data you've imported to Quick Base: Converting a column into a table
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.