Skip To Content

Tables and named ranges

ArcGIS Maps for Office automatically detects tables and named ranges in the workbook for use in the Add data wizard. If there are no tables or named ranges in the workbook, you can manually specify the range of cells to use with the Add data wizard. If your spreadsheet contains a table or named range, the Add data from worksheet window automatically sets that as the current selection.

It is highly recommended that you convert data to a table before adding it to a map. Converting your spreadsheet data to an Excel table allows ArcGIS Maps for Office to add new columns of information to the table, provides many ways of filtering the data, and automatically updates the map to reflect changes to the table.

To create a table, click the Insert tab on the ribbon and click Table. Choose the range that contains your data and click OK. Now the locations in this table can be added to a map using the Add Data button from the ArcGIS Maps tab.

Note:

In Microsoft Excel, a spreadsheet is not equivalent to a table or named range. A table or named range is an item specifically created by the user of the spreadsheet. For more information, see Overview of Excel tables.

If you are unsure as to whether your workbook contains tables or named ranges, use Name Manager on the Excel Formulas tab to see a list of tables and named ranges.

Tip:

When selecting cell ranges, drag the mouse pointer over the desired group of cells. Do not select cells using the column headers or row numbers, as that selects the entire worksheet and may impact performance. See Select cells, ranges, rows, or columns on a worksheet for more information.

PivotTables are a special type of table in Excel that are used to summarize and analyze data. When adding data, ArcGIS Maps for Office automatically detects pivot tables for use in the Add data wizard and includes them if appropriate. A pivot table will not be added to the Add data wizard if it contains an unsupported data type, has a hierarchy, or has more than one row label.