ArcGIS Pro Spreadsheet Tutorial

Tutorial for Importing and Visualizing CSV Data in ArcGIS Pro

In this tutorial, you will learn how to import CSV Data in ArcGIS Pro and use the existing tools in ArcGIS Pro to visualize the data. Let’s get started!

Obtaining Data

The first step is to obtain a CSV/XLXS for your particular dataset! ArcGIS Pro will be able to work with any dataset!

If you do not have a dataset that you would like to work with, here are two repositories where you can find a significant number of CSV/XLSX datasets for download:

• New York City Open Data: https://opendata.cityofnewyork.us/

• Providence Open Data: https://data.providenceri.gov/ 

Create a new ArcGIS Project 

Now that you have your dataset, let’s create a new ArcGIS Project and open the dataset! Let’s follow the following steps:

1. Open ArcGIS Pro and sign in if necessary.

2. On the start page, create a new project from blank template “Map”.

3. Select a location on the map that corresponds to the dataset you wish to use. You may drag the map or go to a specific coordinate location with the “Go to XY” button.

4. Use the “Basemap” dropdown box to select the map type that you want to use (satellite, topographic, terrain, etc.).

Add an Excel Worksheet to the Project

1. On the ribbon, click the Map tab. In the Layer group, click Add Data Add Data.

2. Navigate to the Excel sheet (.xlsx file extension) and click “Okay”.

3. The Excel sheet should be added as a table to ArcGIS Pro and should appear in the Contents pane.

4. To display the Excel sheet, go to the Contents pane, under Standalone Tables, right-click your Excel sheet and click Open.

Transpose Table Fields

1. Open the Geoprocessing pane and search for Transpose Fields.

2. Open the tool.

3. For “Input Table”, click the drop-down arrow and select your Excel sheet.

4. Under “Fields to Transpose”, next to “Field”, click “Add Many”.

5. Select all checkboxes that you would like to transform in the drop-down list. Proceed to click “Add” when finished.

6. Enter the transposed and value field next.

7. Close the table, click run, and then under the contents pane you should be able to open the new sheet imported to “Standalone Tables”.

Join the table to the layer

1. Right click on the layer -> Joins and Relates -> Add Join.

2. A popup window should have appeared. Fill out the pane accordingly using the drop downs.

3. Click “Validate Join” to ensure that there are no errors before joining the tables.

4. The joined table should appear in the bottom panel.

Visualize trends with a line chart

1. Click “Select by Location” in the top menu bar.

2. A popup window should have appeared. Fill out the pane accordingly using the drop downs.

3. Make sure to change the “Relationship” value to contains, then run the tool after all information is filled out.

4. Right click on the layer -> Create Chart -> Line Chart.

5. Proceed to fill out the chart properties, including labeling the axis, providing a title, assigning color to each line.

6. The chart should appear in the bottom panel, and dynamically update as you mess with the properties of the chart.