Need For Split Addresses In Excel And Get Geolocation Data
I have an Excel spreadsheet with around 500 lines of address data.
I need the addresses to be split into the following fields:
- Building name, e.g. Menara BCA (optional, only if the address contains a building name).
- Address (Some do not contain street address, you will need to use the BIZ and existing address field to find out on Google).
- Postcode (if it exists).
Followed by a search on Google Maps or similar services to retrieve the longitude and latitude for each location.
For most of the entries, we already have a phone number, but for the entries that don't, if you happen to come across it as part of your search, please enter it also.
As a trial, please complete the remaining 6 entries.