Make sure the first row of the worksheet is properly formatted.

The next step will be to prepare the workbook containing rock and soil worksheets and convert and update the CSV files containing assay data before using them in ArcGIS Pro. Consequently, for many worksheets, some data preparation is necessary to ensure the data is correctly identified in ArcGIS Pro. When ArcGIS Pro reads an Excel workbook with worksheets, the first data record in the workbook or file defines the field type. Update and prepare data in Microsoft Excel Right alignment identifies a column as containing numeric values. The AG_PPM, AS_PPM, and HG_PPB columns are aligned on the right. Browse to your project area, expand the Battle_Mountain folder, then expand the XLSFiles folder. Unzip the Import_Excel_to_Pro.zip in a project area on your local machine.ģ. Click Import_Excel_to_Proand choose Download.Ģ. Download and review rock and soil sample dataġ.

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. Landownership information is imaginary,but reflects exploration trends around Battle Mountain, Nevada, in the early 1990s.

It consists of fictitious sample data, that is true to the underlying geology. The data used in this blog was collected and generated by Mike Price, Entrada/San Juan, Inc. 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. 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.

How to open gdb file in excel