topic Re: How to build my Excel data for tracking organizational projects by City and County for mapping in ArcGIS for Excel Questions

How to build my Excel data for tracking organizational projects by City and County for mapping

JoshYoungSCEDD — Mon, 03 Feb 2025 16:20:10 GMT

Help mapping data, my organization has asked me to use my ArcGIS skills to take an existing Excel file to map the projects we are currently engaged in by City and County. I'm looking for the appropriate file type and data fields required to alter an existing Excel document to be able to upload the data set into our ArcGIS Online account and map the locations.

Any assistance would be greatly appreciated. I'm open to scheduling a Zoom or Teams meeting to share the current file and talk through the necessary steps to be able to map the data.

Thank you,

Josh Young

josh@scedd.us | 308-455-4773

Re: How to build my Excel data for tracking organizational projects by City and County for mapping

ShannonCardoza — Mon, 10 Feb 2025 23:14:49 GMT

Good Afternoon @JoshYoungSCEDD,

Thank you for posting your workflow inquiry here. If your end goal is to upload the Excel worksheet to ArcGIS Online, I can suggest a workflow but I would recommend following up with the ArcGIS Online Communit as well. If you have a specific question using ArcGIS for Excel, the add-in, I can assist you further.

To upload an Excel file to ArcGIS Online, you can:

Log in to your ArcGIS account
Click Contents
Click New Item
Drag and drop the Excel file or select it from your device
Review the location fields in the Excel file
Provide information for the file, such as a title, tags, and summary
Select a folder to save the file in
Click Save

Here is an additional resource I also found that may be helpful called, Turn your Excel data into an ArcGIS Online layer.

Please let me know if you have additional questions.

Best,

Re: How to build my Excel data for tracking organizational projects by City and County for mapping

JoshYoungSCEDD — Tue, 11 Feb 2025 15:02:58 GMT

I'm looking for direction on what are the most appropriate location fields to use for input.