Adding a Microsoft Excel table to ArcMap

Excel files are added to ArcMap like other data, through the Add Data dialog box. When you browse to an Excel file, you will need to choose which table you want to open. For example, if you have an Excel workbook called sales_figures.xls that contains three worksheets—Sales, Month, and Year to date—each worksheet is a separate table in ArcGIS. Any name references to cells or ranges defined in Excel are preserved in ArcGIS.

Steps:
  1. Click the Add Data button Add Data.
  2. Click the Look in arrow and navigate to the Excel workbook file (.xls).
  3. Double-click the Excel workbook file.
  4. Click the table you want to add to ArcMap.
  5. Click Add.

    Excel tables, like other nonspatial tables (without associated features), are shown only in the List by Source view of the ArcMap table of contents.

TipTip:
You can also drag an Excel table from the Catalog window to add it to ArcMap.

Related Topics


9/17/2012