ArcGIS Online

Add spreadsheet data to ArcGIS Online

‘Why add spreadsheet data to ArcGIS Online?’ Maybe not a typical question from a 9-year-old. But my nephew, Gio, wanted to know. He recently learned about spreadsheets in school. For homework, he was creating a spreadsheet of trees in his neighborhood. I told him I used spreadsheets to make maps.

Tree data comes alive in 3D web apps. Learn how to make this app.

‘Maps are more interesting than spreadsheets. They have pictures instead of rows and columns of numbers and words.’ Exactly.

Maps help you discover patterns and trends in your data because they display the data visually. For example, with Gio’s tree data, we could create 3D visualizations of the trees based on their height, species, or condition. The map could help urban planners see the tree conditions and make informed decisions about how to manage the trees.

How do you get the data into a map? You add it to ArcGIS Online and publish it as a hosted feature layer. Hosted feature layers let you visualize, analyze, and share the data through maps. You can also update the features, edit related attribute information, and collect additional features. You can add almost any spreadsheet to ArcGIS Online if it has location information such addresses or coordinates.

In 4 steps, I showed Gio how to add a spreadsheet to ArcGIS Online. Here’s how.

Step 1: Sign in to ArcGIS Online with your ArcGIS account.

Your account needs privileges to publish hosted feature layers. If you don’t have these privileges, contact your ArcGIS Online administrator or get a free ArcGIS Online trial.

Step 2: On the Content page, click New item.

New item in Content

Step 3: Drag your spreadsheet file into the New item drop zone.

File in drop zone

Leave the default option to add your spreadsheet file and create a hosted feature layer.

Add file and create a hosted feature layer

Step 4: Review and change if necessary the default options for fields, location settings, and item details. Click Save to add your spreadsheet and publish it as a hosted feature layer.

The spreadsheet file and feature layer appear in your content page.

Items in My Content

In 4 quick steps, Gio and I added a spreadsheet data to ArcGIS Online.

As a best practice for sharing, we added additional information to our item page and enabled delete protection so we didn’t accidently remove the items from our content.

What’s next?

We could do any of the following with our feature layer:

Gio thought this seemed OK. But maybe not quite as fun as climbing a tree. Fair enough.

More information about adding data to ArcGIS Online

 

This article was originally published on September 25, 2018 and has been updated.

About the author

I'm a senior principal product engineer for ArcGIS writing and a member of the ArcGIS Online team. In addition to helping users make maps, I'm passionate about trail running, Nordic skiing, ski mountaineering, climbing, and English Pointers.

Connect:
0 Comments
Inline Feedbacks
View all comments

Next Article

Technology Enhancements in ArcGIS for Power BI Latest Release

Read this article