https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1051985#M25500 <P>I am working on my final project for a GIS class, and I have been given an excel spreadsheet (csv) with addresses, cities, zip codes, and some other information. I am supposed to geocode it into a shapefile, but I don't know how to do that without using x,y data. When I just add the table itself to ArcMap, it doesn't have an attribute table or anything I can work with further. I don't have an ArcGIS subscription that allows me to use the Geocode Addresses feature, and my professor hasn't been much help, so please let me know what I should do!</P> Tue, 27 Apr 2021 21:15:08 GMT caw0433 2021-04-27T21:15:08Z https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1051985#M25500 <P>I am working on my final project for a GIS class, and I have been given an excel spreadsheet (csv) with addresses, cities, zip codes, and some other information. I am supposed to geocode it into a shapefile, but I don't know how to do that without using x,y data. When I just add the table itself to ArcMap, it doesn't have an attribute table or anything I can work with further. I don't have an ArcGIS subscription that allows me to use the Geocode Addresses feature, and my professor hasn't been much help, so please let me know what I should do!</P> Tue, 27 Apr 2021 21:15:08 GMT https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1051985#M25500 caw0433 2021-04-27T21:15:08Z https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1052004#M25501 <P>If you don't have more than 250 records you can use&nbsp;<A href="https://batchgeo.com/" target="_blank">https://batchgeo.com/</A></P> Tue, 27 Apr 2021 22:16:47 GMT https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1052004#M25501 Roli 2021-04-27T22:16:47Z https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1052008#M25502 <P>Has the instructor provided a geocoding service with which to match your address table?&nbsp; If your class has an AGOL account you can upload the spreadsheet and it'll geocode the addresses for you that way.&nbsp; It takes AGOL credits though; your instructor should have all that set up for you. (In theory...)</P> Tue, 27 Apr 2021 22:40:54 GMT https://community.esri.com/t5/geoprocessing-questions/converting-excel-file-with-addresses-to-shapefile/m-p/1052008#M25502 JoeBorgione 2021-04-27T22:40:54Z