Select From a Spreadsheet in the Create Application Wizard to load spreadsheet data and then create report on that data.
Parent topic: Creating Database Applications
Load spreadsheet data from a file or by copying and pasting and then create an interactive report on that data.
When you run the Create Application Wizard and select From a Spreadsheet, the Create From a Spreadsheet Wizard appears.
You then choose how to upload the spreadsheet data. Options include:
From a file. Select this option to upload spreadsheet data from a file as comma separated (*.csv) or tab delimited file.
Copy and paste. Select this option to copy and paste tab delimited data.
Once you approve a page preview, the wizard loads the data into the database, creates a report and form on the data, and then displays the Create Application Wizard. A new interactive report with form page named after the table you imported displays under Pages. You then finish the application creation process by naming the application, specifying the application appearance, editing the report, create additional pages, selecting features, and configuring settings.
Copy and Paste Sample Data
If you choose the Copy and paste option, the wizard includes Sample Data. Simply expand the Sample Data region and select a sample.
Support for Uploading JSON Data
The Create From a Spreadsheet Wizard supports the upload of JSON data. To view two examples, select Copy and paste option, expand the Sample Data region, and select either JSON and Structured Test Data or JSON only Test Data.
Parent topic: Creating a Database Application from a Spreadsheet
Load spreadsheet data from a file as comma separated (*.csv) or tab delimited file and then create an interactive report on that data.
To load spreadsheet data from a file:
Select From a Spreadsheet in the Create Application Wizard to load spreadsheet data and then create report on that data.
To load spreadsheet data by copying and pasting:
Parent topic: Creating a Database Application from a Spreadsheet