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 2: Select Start using an Excel Spreadsheet
Step 3: Give your new application a name.
Step 4: 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.)
Please read the How to Import Data article for a detailed overview regarding importing spreadsheets to an existing app.