First, let's discuss a few things to keep in mind while importing a spreadsheet.
- Ensure that your spreadsheet is in either .xlsx (Excel 2007 or newer) or .csv format. Other file types such as .xls or .mdb will not import and must be converted before proceeding.
- The spreadsheet must be a single, "flat" table. This means that there can be one, and only one, header row. You must remove any groups, totals, and/or subtotals.
- The header row will become the field names of the new table. When importing to create an app, the header row will be the first row in your spreadsheet where each column contains data.
- In a spreadsheet that has multiple worksheets, only the first (leftmost) worksheet is imported. To import multiple worksheets from one spreadsheet, successively 1) Move the desired worksheet to be leftmost, 2) Re-save the spreadsheet, 3) Import, and 4) repeat as needed.
- Cell formatting (colors, borders, number format, date format, etc.) is ignored.
- The number of columns that will be imported depends on several variables (such as size of content in each column) but will be generally limited to 125-300 columns.
Step 1: From the App drop-down menu, click + New.
Step 2: Select Start using an Excel Spreadsheet
Step 3: If you are using Firefox or Chrome, you may drag and drop your file into the outlined area from a location on your desktop. Internet Explorer users will click into the outlined area to upload the spreadsheet or use the Simple Uploader. (Firefox and Chrome users may also use this method.)
Once the spreadsheet is uploaded and validated, your app will be created with a table, a form, and a grid view. You will also receive an email form TrackVia <email@example.com> with details regarding your 'Import table results'.
Please read the How to Import Data article for a detailed overview regarding importing spreadsheets to an existing app.