In the age of databases and cloud based data storage, many organizations still maintain valuable data in Microsoft Excel and comma-separated value (CSV) files. In this blog post, you will explore a workflow for importing geological data maintained by a mining company in Microsoft Excel and CSV files for use in an ArcGIS Pro project.<\/p>\n
The data used in this blog was collected and generated by Mike Price, Entrada\/San Juan, Inc.\u00a0 It consists of fictitious sample data, that is true to the underlying geology. Landownership information is imaginary,but reflects exploration trends around Battle Mountain, Nevada, in the early 1990s.\u00a0 Additional source data was derived from the Nevada Bureau of Mines and Geology County mapping series and the US Department of Energy National Uranium Resource Evaluation (NURE) program.<\/p>\n"},{"acf_fc_layout":"content","content":"
1. Click Import_Excel_to_Pro<\/strong> <\/a>and choose Download<\/strong>.<\/p>\n 2. Unzip the Import_Excel_to_Pro.zip<\/strong> in a project area on your local machine.<\/p>\n 3. Browse to your project area, expand the Battle_Mountain<\/strong> folder, then expand the XLSFiles<\/strong> folder.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647172,"id":647172,"title":"Locate Excel files","filename":"1-1.png","filesize":6083,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/1-18","alt":"","author":"9742","description":"Locate Excel files","caption":"Locate Excel files","name":"1-18","status":"inherit","uploaded_to":647132,"date":"2019-10-31 18:53:46","modified":"2019-10-31 18:54:15","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":605,"height":196,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1-213x196.png","thumbnail-width":213,"thumbnail-height":196,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","medium-width":464,"medium-height":150,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","medium_large-width":605,"medium_large-height":196,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","large-width":605,"large-height":196,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","1536x1536-width":605,"1536x1536-height":196,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","2048x2048-width":605,"2048x2048-height":196,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","card_image-width":605,"card_image-height":196,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/1-1.png","wide_image-width":605,"wide_image-height":196}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 4. Locate and open Sample_Locations.xlsx<\/strong> \u00a0in Microsoft Excel.<\/p>\n The Sample_Locations<\/strong> workbook contains two worksheets named Rock<\/strong> and Soil<\/strong>.<\/p>\n 5. If necessary, click the Rock <\/strong>worksheet, to review the table content.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647182,"id":647182,"title":"Review Rock worksheet","filename":"2-1.png","filesize":15122,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/2-19","alt":"Review Rock worksheet","author":"9742","description":"Review Rock worksheet","caption":"Review Rock worksheet","name":"2-19","status":"inherit","uploaded_to":647132,"date":"2019-10-31 18:56:26","modified":"2019-10-31 18:58:52","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":569,"height":520,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","medium-width":286,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","medium_large-width":569,"medium_large-height":520,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","large-width":569,"large-height":520,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","1536x1536-width":569,"1536x1536-height":520,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","2048x2048-width":569,"2048x2048-height":520,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1-509x465.png","card_image-width":509,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/2-1.png","wide_image-width":569,"wide_image-height":520}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" The Rock worksheet contains sample numbers, coordinates, and field information that will allow this data to be displayed on a map.<\/p>\n 6. Click and review the Soil <\/strong>worksheet.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647192,"id":647192,"title":"Review Soil worksheet","filename":"3-2.png","filesize":8434,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/3-20","alt":"Review Soil worksheet","author":"9742","description":"Review Soil worksheet","caption":"Review Soil worksheet","name":"3-20","status":"inherit","uploaded_to":647132,"date":"2019-10-31 18:58:02","modified":"2019-10-31 18:58:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":569,"height":319,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","medium_large-width":569,"medium_large-height":319,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","large-width":569,"large-height":319,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","1536x1536-width":569,"1536x1536-height":319,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","2048x2048-width":569,"2048x2048-height":319,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","card_image-width":569,"card_image-height":319,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/3-2.png","wide_image-width":569,"wide_image-height":319}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Similar to the Rock worksheet, the Soil worksheet also contains sample numbers, coordinates, and field information.<\/p>\n 7. Open and review the Rock_Data.csv<\/strong> file in Microsoft Excel.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647212,"id":647212,"title":"Review Rock_Data file","filename":"4.png","filesize":9679,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/4-22","alt":"Review Rock_Data file","author":"9742","description":"Review Rock_Data file","caption":"Review Rock_Data file","name":"4-22","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:04:17","modified":"2019-10-31 19:04:58","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":415,"height":486,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","medium-width":223,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","medium_large-width":415,"medium_large-height":486,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","large-width":415,"large-height":486,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","1536x1536-width":415,"1536x1536-height":486,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","2048x2048-width":415,"2048x2048-height":486,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4-397x465.png","card_image-width":397,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/4.png","wide_image-width":415,"wide_image-height":486}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Notice that the SAMPLENO field in the CSV files will support a one-to-one tabular join with the same field in the Soil and Rock worksheets.<\/p>\n 8. Open and review the Soil_Data.csv<\/strong> \u00a0file.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647232,"id":647232,"title":"Review Soil_Data file","filename":"5.png","filesize":9286,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/5-13","alt":"Review Soil_Data file","author":"9742","description":"Review Soil_Data file","caption":"Review Soil_Data file","name":"5-13","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:07:25","modified":"2019-10-31 19:07:54","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":410,"height":486,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","medium-width":220,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","medium_large-width":410,"medium_large-height":486,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","large-width":410,"large-height":486,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","1536x1536-width":410,"1536x1536-height":486,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","2048x2048-width":410,"2048x2048-height":486,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5-392x465.png","card_image-width":392,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/5.png","wide_image-width":410,"wide_image-height":486}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Both CSV files were obtained from an assay laboratory and contain results of chemical analysis of rock and soil samples taken at locations in the Battle Mountain area. Values in the tables represent trace elements used in gold exploration and are indicator minerals used to assess the potential for finding viable gold deposits.<\/p>\n 9. In the Soil_Data.csv<\/strong> \u00a0file, inspect the alignment of data in table columns.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647242,"id":647242,"title":"Review data column alignment","filename":"6.png","filesize":6327,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/6-10","alt":"Review data column alignment","author":"9742","description":"Review data column alignment","caption":"Review data column alignment","name":"6-10","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:14:39","modified":"2019-10-31 19:15:14","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":410,"height":268,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","medium-width":399,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","medium_large-width":410,"medium_large-height":268,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","large-width":410,"large-height":268,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","1536x1536-width":410,"1536x1536-height":268,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","2048x2048-width":410,"2048x2048-height":268,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","card_image-width":410,"card_image-height":268,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/6.png","wide_image-width":410,"wide_image-height":268}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Notice that SAMPLENO, AU_PPB and SB_PPM are aligned on the left side of the column. Left alignment generally denotes that a column contain text strings and not numbers that may be used to determine values greater than a specific range.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647252,"id":647252,"title":"Review right aligned columns","filename":"7.png","filesize":4732,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/7-6","alt":"Review right aligned columns","author":"9742","description":"Review right aligned columns","caption":"Review right aligned columns","name":"7-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:17:12","modified":"2019-10-31 19:17:50","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":505,"height":168,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7-213x168.png","thumbnail-width":213,"thumbnail-height":168,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","medium-width":464,"medium-height":154,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","medium_large-width":505,"medium_large-height":168,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","large-width":505,"large-height":168,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","1536x1536-width":505,"1536x1536-height":168,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","2048x2048-width":505,"2048x2048-height":168,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","card_image-width":505,"card_image-height":168,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/7.png","wide_image-width":505,"wide_image-height":168}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" The AG_PPM<\/strong>, AS_PPM<\/strong>, and HG_PPB<\/strong> columns are aligned on the right. Right alignment identifies a column as containing numeric values.<\/p>\n When ArcGIS Pro reads an Excel workbook with worksheets, the first data record\u00a0 in the workbook or file defines the field type. Consequently, for many worksheets, some data preparation is necessary to ensure the data is correctly identified in ArcGIS Pro. The next step will be to prepare the workbook containing rock and soil worksheets and convert and update\u00a0 the CSV files containing assay data\u00a0 before using them in ArcGIS Pro.<\/p>\n Some best practices are as follows:<\/p>\n Before making updates to the worksheet, lets make a copy of the workbook so you can retain the original data as an archive.<\/p>\n 1. In Excel, save the workbook to a new workbook named Sample_Locations_ Import.xlsx<\/strong>.<\/p>\n 2. In Sample_Locations_Import\u00a0<\/strong>workbook open the\u00a0Soil<\/strong> worksheet and review the first row of data containing the column names.<\/p>\n The table contains 20,096 records, representing soil sample points collected in UTM North American Datum 1983 (NAD83) Zone 11 Meters. Coordinates are maintained in the\u00a0Easting<\/strong>\u00a0and\u00a0Northing<\/strong>\u00a0fields and are displayed using a precision of 0.01 meters. In addition, many samples are coded by Claim Group.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647282,"id":647282,"title":"Review Soil worksheet column names","filename":"8.png","filesize":5414,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/8-6","alt":"Review Soil worksheet column names","author":"9742","description":"Review Soil worksheet column names","caption":"Review Soil worksheet column names","name":"8-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:38:58","modified":"2019-10-31 19:39:46","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":594,"height":182,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8-213x182.png","thumbnail-width":213,"thumbnail-height":182,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","medium-width":464,"medium-height":142,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","medium_large-width":594,"medium_large-height":182,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","large-width":594,"large-height":182,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","1536x1536-width":594,"1536x1536-height":182,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","2048x2048-width":594,"2048x2048-height":182,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","card_image-width":594,"card_image-height":182,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/8.png","wide_image-width":594,"wide_image-height":182}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" Notice that several column names contain spaces. Recall that field names must contain only letters, numbers, and underscores.<\/p>\n 3. In the Soil<\/strong> worksheet, for column names, change the spaces to underscores.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647292,"id":647292,"title":"Update Soil column names","filename":"9.png","filesize":4849,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/9-6","alt":"Update Soil column names","author":"9742","description":"Update Soil column names","caption":"Update Soil column names","name":"9-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:42:13","modified":"2019-10-31 19:42:37","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":607,"height":149,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9-213x149.png","thumbnail-width":213,"thumbnail-height":149,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","medium-width":464,"medium-height":114,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","medium_large-width":607,"medium_large-height":149,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","large-width":607,"large-height":149,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","1536x1536-width":607,"1536x1536-height":149,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","2048x2048-width":607,"2048x2048-height":149,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","card_image-width":607,"card_image-height":149,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/9.png","wide_image-width":607,"wide_image-height":149}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 4. In the Soil<\/strong> worksheet, change the Easting<\/strong> column name to UTM83Z11_E<\/strong>.<\/p>\n 5. In the Soil<\/strong> worksheet, change the Northing<\/strong> column name to UTM83Z11_N<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647302,"id":647302,"title":"Update Easting and Northing column names","filename":"10.png","filesize":4248,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/10-6","alt":"Update Easting and Northing column names","author":"9742","description":"Update Easting and Northing column names ","caption":"Update Easting and Northing column names ","name":"10-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:43:37","modified":"2019-10-31 19:44:16","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":609,"height":114,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10-213x114.png","thumbnail-width":213,"thumbnail-height":114,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","medium-width":464,"medium-height":87,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","medium_large-width":609,"medium_large-height":114,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","large-width":609,"large-height":114,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","1536x1536-width":609,"1536x1536-height":114,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","2048x2048-width":609,"2048x2048-height":114,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","card_image-width":609,"card_image-height":114,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/10.png","wide_image-width":609,"wide_image-height":114}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 6. In Sample_Locations_Import\u00a0<\/strong>workbook open the Rock <\/strong>worksheet and inspect the data.<\/p>\n 7. In the Rock<\/strong> worksheet, review the first row of data containing column names, and then update names by replacing spaces with underscores.<\/p>\n 8. In the Rock<\/strong> worksheet, change the Easting<\/strong> column name to UTM83Z11_E<\/strong> and the Northing<\/strong> column name to UTM83Z11_N<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647322,"id":647322,"title":"Update Rock column names","filename":"11.png","filesize":5769,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/11-6","alt":"Update Rock column names","author":"9742","description":"Update Rock column names","caption":"Update Rock column names","name":"11-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:47:58","modified":"2019-10-31 19:48:23","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":651,"height":153,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11-213x153.png","thumbnail-width":213,"thumbnail-height":153,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","medium-width":464,"medium-height":109,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","medium_large-width":651,"medium_large-height":153,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","large-width":651,"large-height":153,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","1536x1536-width":651,"1536x1536-height":153,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","2048x2048-width":651,"2048x2048-height":153,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","card_image-width":651,"card_image-height":153,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/11.png","wide_image-width":651,"wide_image-height":153}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 9. Save and close the Sample_Locations_ Import.xlsx<\/strong><\/p>\n Next, you will edit and format the companion laboratory assay data for the Rock and Soil worksheets.<\/p>\n 10. If necessary, open the Rock_Data.csv<\/strong> file in Excel.<\/p>\n 11. Save the file as Rock_Data_Import.xlsx<\/strong> \u00a0so you have the original CSV file and a new copy in Excel.<\/p>\n 12. Review the table for improper field names and inappropriate data formats.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647332,"id":647332,"title":"Review Rock_Data table","filename":"12.png","filesize":5487,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/12-6","alt":"Review Rock_Data table","author":"9742","description":"Review Rock_Data table","caption":"Review Rock_Data table","name":"12-6","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:50:21","modified":"2019-10-31 19:51:30","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":524,"height":240,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","medium-width":464,"medium-height":213,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","medium_large-width":524,"medium_large-height":240,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","large-width":524,"large-height":240,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","1536x1536-width":524,"1536x1536-height":240,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","2048x2048-width":524,"2048x2048-height":240,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","card_image-width":524,"card_image-height":240,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/12.png","wide_image-width":524,"wide_image-height":240}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" The field names appear to be correctly formatted, but a significant number of records are coded with a less than (<) symbol. These records each contain less than the minimum detectable amount of a specific element. Sometimes, a sample contains more than a maximum detectable amount and is coded with a greater than (>) symbol. The over-limit samples in this dataset have already been resolved, so only the less than values need fixing.<\/p>\n 13. In Excel, use Find and Replace<\/strong> to find < 0.5<\/strong> and replace all with 0.1<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647342,"id":647342,"title":"Find and Replace","filename":"13.png","filesize":8591,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/13-5","alt":"Find and Replace","author":"9742","description":"Find and Replace ","caption":"Find and Replace ","name":"13-5","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:52:49","modified":"2019-10-31 19:53:09","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":642,"height":253,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","medium-width":464,"medium-height":183,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","medium_large-width":642,"medium_large-height":253,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","large-width":642,"large-height":253,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","1536x1536-width":642,"1536x1536-height":253,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","2048x2048-width":642,"2048x2048-height":253,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","card_image-width":642,"card_image-height":253,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/13.png","wide_image-width":642,"wide_image-height":253}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 14. Use Find and Replace<\/strong> to change all additional values below the detection limit for arsenic, gold, mercury, silver and antimony with values shown in table below.<\/p>\n When done, review the table and search for the < and > characters to confirm that all the above and below limit values have been located and updated.<\/p>\n 15. In the table, right click the AU_PPB<\/strong> field and select Format Cells<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647352,"id":647352,"title":"Format columns","filename":"14.png","filesize":5045,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/14-4","alt":"Format columns","author":"9742","description":"Format columns","caption":"Format columns","name":"14-4","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:56:07","modified":"2019-10-31 19:56:26","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":238,"height":318,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","medium-width":195,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","medium_large-width":238,"medium_large-height":318,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","large-width":238,"large-height":318,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","1536x1536-width":238,"1536x1536-height":318,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","2048x2048-width":238,"2048x2048-height":318,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","card_image-width":238,"card_image-height":318,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/14.png","wide_image-width":238,"wide_image-height":318}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" The Format Cells<\/strong> pane displays. Notice that the field is currently categorized as General.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647372,"id":647372,"title":"General categorization","filename":"15.png","filesize":3944,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/15-4","alt":"General categorization","author":"9742","description":"General categorization","caption":"General categorization","name":"15-4","status":"inherit","uploaded_to":647132,"date":"2019-10-31 19:58:22","modified":"2019-10-31 19:58:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":424,"height":237,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","medium-width":424,"medium-height":237,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","medium_large-width":424,"medium_large-height":237,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","large-width":424,"large-height":237,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","1536x1536-width":424,"1536x1536-height":237,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","2048x2048-width":424,"2048x2048-height":237,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","card_image-width":424,"card_image-height":237,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/15.png","wide_image-width":424,"wide_image-height":237}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 16. In the Format Cells<\/strong> pane, click Number<\/strong> to change the field category.<\/p>\n 17. Change Decimal places<\/strong> to 0<\/strong>, and then click OK<\/strong>.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":647382,"id":647382,"title":"Change field category","filename":"16.png","filesize":4261,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/natural-resources\/working-with-excel-files-in-arcgis-pro\/16-5","alt":"Change field category","author":"9742","description":"Change field category","caption":"Change field category","name":"16-5","status":"inherit","uploaded_to":647132,"date":"2019-10-31 20:00:14","modified":"2019-10-31 20:00:42","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":313,"height":222,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","medium-width":313,"medium-height":222,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","medium_large-width":313,"medium_large-height":222,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","large-width":313,"large-height":222,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","1536x1536-width":313,"1536x1536-height":222,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","2048x2048-width":313,"2048x2048-height":222,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","card_image-width":313,"card_image-height":222,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/10\/16.png","wide_image-width":313,"wide_image-height":222}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" 18. In the same manner, change the field category from General<\/strong> to Number<\/strong> for the AG_PPM<\/strong>, AS_PPM<\/strong>, SB_PPM,<\/strong> and HG_PPB<\/strong><\/p>\n 19. For the SAMPLENO <\/strong>field, change the field category from Genera<\/strong>l to Text<\/strong>.<\/p>\n 20. Save and close the Rock_Data_Import.xlsx<\/strong>\u00a0table.<\/p>\n 21. On your own Update Soil Data<\/em><\/strong>.<\/p>\n"},{"acf_fc_layout":"sidebar","content":" 22. Save and close the Soil_Data_Import.xlsx<\/strong> \u00a0table.<\/p>\n You have completed data preparation of the battle mountain data currently stored and maintained in Excel and CSV files. Next, you will import and use the data in ArcGIS Pro.<\/p>\n Microsoft Office Excel tables may be used directly in ArcGIS Pro and you can work with them in the same way as other tabular data sources. For example, you can add them to the map, open them in the fields view, and use them as inputs to geoprocessing tools. However, to work with Excel files in the current release of ArcGIS Pro, you must download and install the ‘Microsoft Access Database Engine 2016 Redistributable’ from the Microsoft Download Center<\/a>.<\/p>\nUpdate and prepare data in Microsoft Excel<\/h2>\n
\n
\n
\n
\n
\n
\n\n
\n Element<\/strong><\/td>\n Abbr.<\/strong><\/td>\n Detection Limit<\/strong><\/td>\n Change From<\/strong><\/td>\n Change To<\/strong><\/td>\n<\/tr>\n \n Silver<\/td>\n Ag<\/td>\n 0.5 ppm<\/td>\n <0.2<\/td>\n 0.1<\/td>\n<\/tr>\n \n Silver<\/td>\n Ag<\/td>\n 0.5 ppm<\/td>\n <0.5<\/td>\n 0.1<\/td>\n<\/tr>\n \n Antimony<\/td>\n Sb<\/td>\n 5.0 ppm<\/td>\n <5<\/td>\n 1<\/td>\n<\/tr>\n \n Arsenic<\/td>\n As<\/td>\n 5.0 ppm<\/td>\n <5<\/td>\n 1<\/td>\n<\/tr>\n \n Gold<\/td>\n Au<\/td>\n 5.0 ppm<\/td>\n <5<\/td>\n 1<\/td>\n<\/tr>\n \n Mercury<\/td>\n Hg<\/td>\n 10.0 ppm<\/td>\n <10<\/td>\n 2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Update Soil Data<\/em><\/h3>\n
\n
Use Excel files in ArcGIS Pro<\/h2>\n