Arcgis Upload Excel File to Feature Layer

Later you've added a map to your worksheet, y'all can add together layers from the data in your Excel spreadsheet or from ArcGIS. When yous begin the Add Data workflow, ArcGIS for Function analyzes the data in the currently selected Excel tabular array or range of cells and suggests the all-time ways to represent it on the map. You tin quickly add together a layer to your map by using the default options, or you tin specify your data source, location blazon, and styling options manually.

Considerations

Data formats

• Use Excel tables—In most cases, it's recommended that you format your data every bit an Excel Excel table before you add it to the map. Using an Excel table allows ArcGIS for Office to add columns containing new information to the dataset. For more information, see Prepare data.
• Employ text values—Columns in your dataset that will be used for location (ZIP Codes, for instance) should be formatted every bit textual values, not numerical values. If your data contains a number that includes a leading nada, every bit is common with Zilch Codes, Excel interprets these fields as numerical values and strips out the leading zero, changing the original value. Formatting such columns as text ensures that your data will remain accurate.
• Use time formats— When your data contains time-merely fields (as opposed to date and time fields), ArcGIS for Office converts these values to strings to display them in pop-ups. Because of this, unlike true date and time values, time-but values cannot exist used in fourth dimension animations. To ensure that time values display properly, use the Format Cells option in Excel to choose the time format to use to all cells in that column before creating the layer.

  Time values in popular-ups and in layers or maps shared in ArcGIS volition display in the format prepare by the map author before creating the layer.

  Some ArcGIS for Role fourth dimension formats may incorporate slight differences from the standard Excel time formats. The following table shows some of these format differences:

  Excel time format	ArcGIS for Part time format
  13:thirty:55	13:thirty:55
  thirty:55:2
  37:30:55
  *1:30:55 PM	i:30:55 PM
  one:30:55 PM
  13:30	13:xxx
  1:30 PM	1:30 PM

Prepare data

ArcGIS for Office automatically detects tables in the workbook for use in the Add data wizard. It is highly recommended that you convert information to a tabular array before calculation information technology to a map.

To create a tabular array, click the Insert tab on the ribbon and click Table. Choose the range that contains your data and click OK. Now you can use this table to add a layer to a map. If you are unsure whether your workbook contains tables, utilise Name Managing director on the Excel Formulas tab to meet a listing of tables.

Tip:

When selecting prison cell ranges, drag the mouse pointer over the desired group of cells. Practice not select cells using the column headers or row numbers, as that selects the unabridged worksheet and may impact performance. See Select cell contents in Excel for more information.

PivotTables are a special blazon of tabular array in Excel that are used to summarize and analyze data. When adding data, ArcGIS for Function automatically detects pivot tables for use in the Add information wizard and includes them if appropriate.

Add a layer from Excel data

To add a layer from Excel data, do the following:

1. In your worksheet, click the map that you want to edit to select it, or add together a new map.
2. Sign in to ArcGIS using your ArcGIS credentials or click Continue to keep as a standard user with basic functionality.
3. From the map tools, click Layers .

   The layer list appears on the map.

4. Click Add from Excel.

   The Add together from Excel pane appears, displaying the available datasets and location types for the layer. In the Dataset field, ArcGIS for Office displays tables and cell ranges in the worksheet. In the Location types field, the bachelor location types are displayed.

   

5. Employ the Dataset drop-down menu to select a table or cell range. Employ the Location types drib-down menu to select a location type.

   Click Add to map.

Choose a dataset

By default, ArcGIS for Office displays the dataset currently selected in the workbook. The drop-down bill of fare lists available data in Excel tables or selected cells. If your spreadsheet contains multiple tables, or if ArcGIS for Office cannot find location-based data, you must specify the information to use to create the map.

To choose a different dataset, do the following:

1. In the Add from Excel pane, open up the Dataset drop-down menu.
2. Select a table or cell range to specify the areas in your worksheet that comprise the data y'all want to use to create the map layer.

   To cull a cell range, click Select a jail cell range and select the cells in the Excel worksheet. The Dataset driblet-down bill of fare is automatically populated with the range ID (for example, $A$i:$D$five). If the selected range contains headers, check the First row contains headers check box.

   If you plan to share your layer on ArcGIS, ensure that the layer's name doesn't incorporate whatever unsupported characters; see Layer names for more than information.

Choose a location type

To add Excel information to a map, your worksheet information must contain at least one of these location types: street addresses; latitude and longitude values (coordinates); or place-names such as a United States metropolis, The states county, state, globe city, country, Cipher Code, or postal lawmaking. You lot tin can also employ a custom location type based on a hosted service in your ArcGIS system, such as park boundaries or sales territories for your organization, or specify a coordinate arrangement from a map or feature service on ArcGIS.

The location type determines how your information will be mapped and controls what's displayed in the style options. If you lot choose Address or Coordinates, your locations will exist mapped as points. If you choose Geography or ESRI JSON Geometry, your information will be mapped as polygons. You tin can as well map your data to custom location types, such as park boundaries or sales territories, that aren't included in the default list. For more data, see Location types.

ArcGIS for Office automatically uses the default location type set by your organization'due south ambassador. Multiple location types tin can be configured, and any one of these can be set as the default. For more information, contact your ArcGIS ambassador.

To choose a location blazon, do the following:

1. In the Add from Excel pane, choose one of the default location types from the Location types driblet-down menu.

   Depending on the location type you choose, different options appear. Use the drop-downward menus to choose the appropriate columns in your data to lucifer with the location fields.

2. Utilize the following options to cull and format your location type:

   • Coordinates—Utilize the Longitude (X) and Breadth (Y) drib-down menus to friction match columns in your data that incorporate coordinates. If necessary, use the Spatial Reference driblet-down menu to modify the spatial reference system.

   • Accost—Utilize the Geolocator and Country drop-down menus to specify these options. Select Unmarried column or Multiple columns to identify the information in your table or jail cell range every bit containing accost data. Apply the Address drop-down menu to choose a column or columns with address data.
   • ESRI JSON Geometry—Utilise the Geometry column driblet-down menu to identify which column contains the geometry. Esri JSON encodes both geometry and feature information into objects. An Esri feature set is a collection of features with the same geometry blazon and coordinate system. In a JSON certificate, a feature set is represented by a JSON object.
   • Geography—When this option is selected, you lot can use an ArcGIS feature service depicting geographic boundaries to map your data as a polygon layer. Enter a geography type, such as US states or Canada provinces, in the search field and printing Enter. Select the geography type you desire to apply and click Add .

     In the adjacent pane, utilise the drib-downwards menus to cull a field from the characteristic service and friction match it to a cavalcade in your information.

     In the adjacent pane, choose the attributes you want summarized on the map by selecting the appropriate column in the drop-down menu.

3. Click Add to map.

Layer names

If y'all add together data from Excel to a map using the jail cell range option, the layer name is automatically populated using the selected range—for example, $A$1:$I$21. If you programme to share the map or layer on ArcGIS, you must manually alter the layer name before doing so. Otherwise, when the layer is published with the hosted feature service, unsupported characters in the layer name may cause unexpected issues when y'all perform diverse tasks in ArcGIS.

Unsupported characters include the following:

Use a custom location type

If your organization has its own boundaries shared on ArcGIS, you can map your data using those boundaries by calculation them equally a location type. Custom boundaries can include sales districts, zoning boundaries, or other defined areas.

For information about configuring a custom location type for your organization, see Configure a custom locator in the ArcGIS for Office Installation Guide.

To add together a location type, practise the following:

1. In the Add from Excel pane, open up the Location types drop-down menu and choose Geography.

   An ArcGIS content pane appears, allowing you to search and scan for custom geographies and ArcGIS characteristic services.

2. In the drib-downwards bill of fare, select My organization or another pick, such as My content.

   The ArcGIS content pane opens, listing items that are available in your ArcGIS organization.

3. Search or browse your groups or content for the hosted service to utilize every bit a location type.
   • Type your search query in the search field and press Enter.
   • Utilise the drop-downward menu to view and search for items in your content, groups, favorites, ArcGIS Living Atlas, ArcGIS, or the curated Boundaries list.
4. Click Add to select the hosted service y'all want to use.

   A pane appears, instructing y'all to select a layer and a field to exist joined with each of the attributes you want to map.

5. From the first drop-downwards menu, choose a layer from the feature service to utilise as the location type. If there is only ane layer, this layer is selected by default.

   From the second drib-downward menu, choose a field in the layer that will be used to lucifer your table data to the features in the hosted service.

   From the tertiary drop-down carte du jour, select a column in your table to join to the layer. Be certain the values in both places (tabular array and hosted service) are of the same type (number or text) and formatted identically, or you won't be able to utilize your custom location type.

6. Click Add to map.

   The Summarize attribute pane appears. In this pane, choose the aspect in your data that you desire to summarize on the map. You can add multiple attributes. You can summarize integer attributes by Sum, Boilerplate, or Count. Y'all tin summarize string attributes by Mode.

7. Click Add together to map.

   The data is added to the map using the custom location type y'all selected.

Choose a coordinate system

To use a spatial reference other than the standard WGS, Web Mercator, or other well-known coordinate organization, you lot can specify a map service or feature service from your ArcGIS organization and import its coordinate system to display your data on a map.

To add a custom coordinate arrangement, do the post-obit:

1. In the Add from Excel pane, choose Coordinates from the Location Types drop-down menu.
2. Use the Longitude (X) and Breadth (Y) driblet-downwardly menus to choose the appropriate columns in your information to match to the x- and y-fields.
3. Choose one of the available existing systems from the Spatial Reference drop-down carte, or manually enter a spatial reference organization in the field.

---

Feedback on this topic?

sawyercooncers.blogspot.com

Source: https://doc.arcgis.com/en/office/design-and-use/add-layers-from-excel.htm

Share this post