Excel Integration allows users to import records from a worksheet in an Excel Workbook file by one of the following methods:
Page-level Import - A user can manually import the Excel file via the Page Gear menu > Excel Integration (if the feature is enabled on the page).
To perform Excel Integration on a Construct page or a page for a custom WebApp, the Page Designer must enable the feature on the page. Refer to Enable Excel Integration for more information.
The Excel template uses the current user's language, set on the My Profile page, to translate the translated column name and the help text in the template. Translated phrases must exist for the column headers and help text for them to display in the spreadsheet. Refer to Set the Language for the Translated Column Name Header in the Excel Template for more information.
Excel Integration cannot be performed on a page if it is read only.
Note
The security definitions associated with a user's role may prevent that user from viewing records added via Excel Integration. If a user's role prevents that user from viewing records on a page through a security definition, the user can add records to the page using Excel Integration. However, the user cannot view these records.
Refer to Use Excel Integration and the Data Insiders article Excel Integration for more information.
Configure Excel Integration includes the following topics: