Hey Shana,
I hope these answers help as I do not currently know how to create points from the spreadsheet as this isn't much information to go on within the spreadsheet. I'm working on creating a service, dashboard, and web app for the step crews to use when adding this tank information once the certificate of occupancy is issued. We need points to get started as we didn't start GPS data collection on step tanks until three years ago with Collector. We currently have 1,500 tanks GPS'ed but this list of tanks has over 6,000 from when our company began installing tanks in the late 1990s and early 2000s.
1. What application and version are you using or have available for this task? ArcMap, ArcGIS Pro - W have access to both software platforms and I prefer to use ArcGIS Pro.
2. Do you have spatial features that represent the step tank? No, as this data is different from our current step tank feature class. If so, does it include the same step # that is in the spreadsheet? No, it seems our Step Department was keeping separate records for all certificate of occupancy once the that was approved by building and codes inspectors.
3. Do you need to geocode to the lot level or step tank level? We were thinking goe-coding to the lot level to at least get a point created for these tanks
4. What attributes do the subdivision and parcel features have that would help? We receive data from our local county's GIS department. The parcel data has subdivision and lot number attributes while the subdivision polygons only contain the subdivision boundary and general information about the development. I trust the parcel data to be authoritative.