HOW TO

Add an Excel file to an ArcGIS Experience Builder web app

Last Published: February 15, 2024

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.

  1. 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.
  1. Open the web app in ArcGIS Experience Builder.
  2. Add the Embed widget to the web app.
  3. 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.
Inserting the Excel file embed code in the Code option of the Embed widget

The image below shows the Excel file successfully embedded in the ArcGIS Experience Builder web app.

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.

  1. Sign in to ArcGIS Online.
  2. Add the Excel file as an item. Refer to ArcGIS Online: Add files as items for more information.
  3. 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.
  4. Use the Table widget to display the data from the Excel file.
    1. Open the web app in ArcGIS Experience builder.
    2. Add the Table widget to the web app.
    3. On the Content tab of the Table widget, click New sheet.
    4. In the Sheet configuration panel, click Select data.
Clicking New Sheet and Select data in the Table widget
  1. In the Select data panel, click Add new data.
  2. In the Add data window, search for and select the item from Step 2 and click Done.
Searching for and selecting the Excel file item
  1. In the Select data panel, expand the item containing the Excel file data and select the feature layer.
Selecting the feature layer to be displayed in the Table widget

The image below shows the data from the Excel file successfully added to the web app using the Table widget.

The data from the Excel file displayed using the Table widget in the web app

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.

  1. Open the web app in ArcGIS Experience Builder.
  2. Add the Add Data widget to the web app.
  3. Save, preview and publish the web app.
  4. Open the published web app. In the Add Data widget, click Click to add data.
The Click to add data button in the Add Data widget
  1. In the Add data panel, click the File tab.
  2. Click Upload, select the Excel file from the local machine and click Done.
Uploading the Excel file from the local machine in the Add Data widget

The image below shows the Excel file successfully added to the web app as a CSV text file (.csv) using the Add Data widget.

The Excel file added to the web app as a CSV text file
Note:
Click Actions > Export to export the file to the local machine.

Article ID: 000031592

Software:
  • ArcGIS Online
  • ArcGIS Experience Builder

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options