excel sec cover sheet for gis 2018 excel

Note: Column names that begin with a number will have an underscore appended in front of the number in ArcGIS Pro. Spaces and hyphens in Excel column names display as underscores in ArcGIS Pro.ĪrcGIS Pro scans the rows in each column to determine the data type.Best practice is for Excel column names to begin with a letter, especially if you want to join the Excel table to another table. Depending on your organization’s data requirements, you may want to make a copy of the worksheet and modify the copy.Ĭolumn names must be 64 characters or less.ĪrcGIS Pro field names can contain only letters, numbers, and underscores (no special characters).If the first row contains other content, modify the worksheet so that the first row contains column names. Note: If an Excel file is password-protected, you will not be able to access it in ArcGIS Pro.ĪrcGIS Pro converts the first row of Excel worksheet data to field names, so the first row in your Excel worksheet should contain column names.Before working with Excel data in ArcGIS Pro, there are a few things you need to be aware of. Export Excel data to a geodatabase table so that it can be managed with and related to GIS data stored in the geodatabase.ĪrcGIS Pro supports XLSX files (Excel 2007) and XLS files (Excel 2003 and earlier).Use Excel data as input to geoprocessing operations.Join an Excel table to a layer attribute table, then use the Excel data for queries, field calculations, feature labels, or map symbols.Microsoft Excel is a popular format for storing and analyzing tabular data. While you can't edit Excel data in ArcGIS Pro (worksheets are read-only), it’s easy to view Excel worksheets and do things like

Excel sec cover sheet for gis 2018 excel