ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Formatting a table in Microsoft Excel for use in ArcGIS

You can open Microsoft Office Excel tables directly in ArcGIS and work with them like other tabular data sources. For example, you can add them to ArcMap, preview them in ArcCatalog, and use them as inputs to geoprocessing tools.

  1. Make sure the first row of the worksheet is properly formatted, since it will be used for the field names in ArcGIS.

    You should follow these general best practices for field naming, particularly if you want to join an Excel table to another table in ArcMap:

    • Field names must start with a letter.
    • Field names must contain only letters, numbers, and underscores.
    • Field names must not exceed 64 characters.

  2. If you have cells with numeric data, dates, and so on, make sure the content is consistently formatted—in other words, make sure all the numeric data is actually numeric. ArcMap scans the first eight rows to determine the field type that should be used. If there are other types of data in those rows, the field is converted to text when the table is in ArcMap.

    Numeric fields are converted to the double data type in ArcGIS.

    ArcMap can only read the first 255 characters of a cell. If you have more characters than that, ArcMap converts the field to a BLOB type and you won't be able to read its contents.

Related topics

  • Understanding how to use Microsoft Excel files in ArcGIS

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2018 Esri. | Privacy | Legal