Importing data using Excel

You can use Excel to import data into a model or database that is accessible to App Studio from a connection. When you import data from a spreadsheet, the following occurs:

• A table is created in the model or database for each worksheet in the spreadsheet.
• An App Studio app is created with the same name as the spreadsheet.
• In the new app, an app board is created with a grid or chart planner widget for each worksheet in the spreadsheet.

Import data using Excel

1. On the Navigation toolbar, select Layout Designer .
2. In the Layout Designer pane, at the top of the Projects section, select a project.
3. Click and choose Create From Excel File.
4. In the Create From Excel File dialog box, for Connection, specify a connection. Each worksheet in the imported Excel file is added as a separate table that is accessible using the specified connection.
5. In the Import dialog box, do one of the following:
   • Click Select File and specify the Excel file that you want to import.
   • Drag and drop the Excel file onto the Import From File box.
6. Click Import.

Best practices for importing data using Excel

• If you have the same column in multiple worksheets, use the same name for each instance of the column. Examples of data categories that may appear in multiple worksheets include ProductName, CustomerName, or SupplierName.
• Take the data from separate worksheets and combine it within fewer worksheets, when possible. However, only combine data of the same granularity. For example, don't combine totals with line item data.
• The name of each worksheet should clearly identify the data it contains.