What if I already have some map coordinates: latitude and longitude?
This is how this feature works:
- Assuming you already have a set of numeric map coordinates (Latitude and Longitude) for some or all your data
- These two coordinates have to be in a valid numeric format (it is the only way it works)
- example of valid numbers: 43.450471, -79.200666
- but not in other formats like
- 43.450471N, 79.200666W << invalid
- 43°27'01.7"N 79°12'02.4"W << invalid
- Latitude must be a number between -90 and 90, excluding the extremes
- Longitude must be a number between -180 and 180, including the extremes
- You need to add a couple of extra columns (Latitude and Longitude) on your Data sheet, and enter your coordinates there. The headers (usually in row #1) for these two extra columns must have exactly those names: Latitude and Longitude
- The column you select for Location (Address) in the sidebar dialog will only be used if there is no Latitude / Longitude values for that particular line
- The table below is a valid example from a sample spreadsheet
- in this case, the add-on will use the provided map coordinates (Latitude and Longitude) for Miles and Ferguson
- but calculate (Geocoding) the coordinates for the other three addresses.