Summary
In ArcGIS Experience Builder, Microsoft Excel (.xlsx) files can be added to web apps for the purpose of displaying or sharing tabular data. This article provides three methods to add an Excel file to an ArcGIS Experience Builder web app: embedding the Excel file to the web app using the Embed widget, displaying the Excel file’s data in a table using the Table widget, and uploading the Excel file as a comma-separated values (CSV) text file (.csv) using the Add Data widget.
Procedure
Add the Excel file using the Embed widget
Embed the Excel file to the ArcGIS Experience Builder web app using the Embed widget.
- Create an embed code of the Excel file. In this example, an embed code of the Excel workbook is generated from Microsoft OneDrive.
Note:
Embed codes are unique to each Excel file and are generated using third-party software or apps.
- Open the web app in ArcGIS Experience Builder.
- Add the Embed widget to the web app.
- On the Content tab of the Embed widget, select the Code option for the Embed by parameter and insert the embed code into the text box.
The image below shows the Excel file successfully embedded in the ArcGIS Experience Builder web app.
Add the Excel file using the Table widget
Upload the Excel file to ArcGIS Online and use the Table widget to display the data in the ArcGIS Experience Builder web app.
- Sign in to ArcGIS Online.
- Add the Excel file as an item. Refer to ArcGIS Online: Add files as items for more information.
- On the item details page, set the sharing level to Everyone (public) to enable public access to the Excel file when viewing the web app. Refer to ArcGIS Online: Share items with everyone for more information.
- Use the Table widget to display the data from the Excel file.
- Open the web app in ArcGIS Experience builder.
- Add the Table widget to the web app.
- On the Content tab of the Table widget, click New sheet.
- In the Sheet configuration panel, click Select data.
- In the Select data panel, click Add new data.
- In the Add data window, search for and select the item from Step 2 and click Done.
- In the Select data panel, expand the item containing the Excel file data and select the feature layer.
The image below shows the data from the Excel file successfully added to the web app using the Table widget.
Add the Excel file converted to a CSV file using the Add Data widget
Upload the Excel file as a CSV (.csv) text file using the Add Data widget in the ArcGIS Experience Builder web app.
- Open the web app in ArcGIS Experience Builder.
- Add the Add Data widget to the web app.
- Save, preview and publish the web app.
- Open the published web app. In the Add Data widget, click Click to add data.
- In the Add data panel, click the File tab.
- Click Upload, select the Excel file from the local machine and click Done.
The image below shows the Excel file successfully added to the web app as a CSV text file (.csv) using the Add Data widget.
Note:
Click Actions > Export to export the file to the local machine.