Everyone who can edit this spreadsheet can see this key. Use a separate key for shared spreadsheets. Formulas use the spreadsheet owner's key; tick this only if you aren't the owner or the owner has no key.
No key yet? Get a free key (no card). Use a key with no website limit. Unless you tick the box above, your key is kept in your Google account's settings for this add-on. It's sent only to MapIron and never written into a cell.
Tick several (street, city, state) to join them into one address.
Each image uses 1 static map image from your plan. Free-plan images carry a small mark.
Formulas (each address or point uses 1 address lookup; results are cached for 6 hours):
=MAPIRON_GEOCODE(A2) latitude and longitude
=MAPIRON_GEOCODE(A2:A100, "label,postcode") chosen fields for a range
=MAPIRON_LATLNG(A2) "lat,lng" in one cell
=MAPIRON_REVERSE(B2, C2) address at a point
For long lists use Geocode a column: it writes plain values, so they are never looked up again, and it can be stopped and resumed.
Paid MapIron plans may keep the results in your sheet indefinitely. On the Free plan you may keep them for up to 30 days.
Map data © OpenStreetMap contributors · MapIron