Skip To Content

Add data to your page

Your data is the basis of everything you do in Insights. You can add data to your workbook page from various data sources, making it easy for you to find the data you need for your analysis.

Add data from the home page

The Datasets tab Connections on the home page gives you access to the feature layers that you created or that were shared with you by members of your organization. Clicking on the title of a dataset will open the dataset in a new workbook. You can use the search bar, filter, Favorites list Favorites, View items button View items, and Sort button Sort to help you find the items you want to add to a page.

Add data from ArcGIS Online

Feature layers in ArcGIS Online are categorized in the Add To Page pane to make them easier for you to find. Depending on who created the layers, and how they are shared, you can find data on the Content, Groups, Organization, Living Atlas, and Boundaries tabs.

Boundaries are Esri-provided layers that are helpful when your data doesn't contain any location fields, such as postal codes or census areas. Boundaries can be used to enable location for any dataset, create maps, and perform spatial analysis.

Follow these steps to add data from ArcGIS Online:

  1. Open the Add To Page window using one of the following options:
    • Create a new workbook. The Add To Page window opens when the workbook is created.
    • Click the Add button above the data pane in an existing workbook.
    • Create a new page in an existing workbook. The Add To Page window opens when the page is created.
  2. In the Add To Page window, choose one of the following tabs:

    Content

    Add feature layers you created in ArcGIS Online.

    Groups

    Add feature layers that were shared with groups to which you belong.

    Organization

    Add feature layers that have been shared with you in your organization.

    Living Atlas

    Add feature layers from curated global content from ArcGIS Online.

    Boundaries

    Add standard boundary feature layers from Living Atlas.

  3. Find the data you want to add. The following options may make it easier to find your data:
    • Choose a group or country to add your data from if you are using Groups or Boundaries.
    • Search for layers using keywords.
    • Sort the datasets by relevance, by date added, or alphabetically.
    • Display information, such as the dataset's owner, the date modified, and a description of the dataset, using View details.
  4. Select one or more datasets. When you have selected a dataset, the layers load in the Selected Data pane. You can uncheck any layers that are not required before adding the data to your workbook.
  5. Click Add to add the dataset to your page.

Depending on the number of datasets you selected, one or more map cards is displayed on your page.

Add data from Excel or CSV files

When you click Excel or CSV, a file drop zone and the Browse my computer button are displayed in the middle pane of the Add to Page window. You can drag a Microsoft Excel or CSV file to the window or browse to your files using the Browse my computer button. Multiple Excel or CSV files can be added at one time using Shift+click or Ctrl+click.

The number of tables displayed in the Selected Data pane depends on the number of sheets and tables in your Excel file.

Note:

CSV files only support one table per sheet. If your CSV file contains multiple tables per sheet, you should convert it to an Excel workbook or move the extra tables to their own sheets.

Excel and CSV files are added as nonspatial tables. To use your Excel and CSV files as spatial data, you must enable location.

Follow these steps to add Excel or CSV data:

  1. Open the Add To Page window using one of the following options:
    • Create a new workbook. The Add To Page window opens when the workbook is created.
    • Click the Add button above the data pane in an existing workbook.
    • Create a new page in an existing workbook. The Add To Page window opens when the page is created.
  2. In the Add to Page window, choose Excel or CSV.
  3. Browse to add a file using the Browse my computer button or drag a file into the window.
    Note:

    Excel and CSV files can be no larger than 100 MB. If you choose an Excel or CSV file that is larger than 100 MB, you will receive an error message.

  4. Click Add to add the dataset to your page.

No cards are created when you add Excel or CSV files. You can create charts and tables with Excel and CSV tables or enable location in your dataset to create a map.

Resources

The following resources may be helpful for adding data in Insights: