I have a large Excel spreadsheet of addresses and project data. I would like to automatically convert this into a point shapefile based on the addresses.

Since these are not coordinates and are addresses, how do I do this using ArcMap?


2 Answers 2


The concept of converting physical addresses to locations on earth (and viceversa) is known as geocoding. Here is a good read on what geocoding is.

Furthermore, I suggest you take a look at Geocoding a table of addresses in ArcMap for a detailed guide on how to convert your Excel spreadsheet with addresses to a Shapefile.


The company I work for has a tool for geocoding of addresses in Excel. Actually, two tools. One is for batch processing of Excel files, and another is an Excel add-in for processing within the spreadsheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.