This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
To split into latitude and longitude (with B2 being the address cell;
change as appropriate for your spreadsheet.) Latitude:
=QUERY(SPLIT(GEOCODE_GOOGLE(B2), “,”), “SELECT Col1”) Longitude:
=QUERY(SPLIT(GEOCODE_GOOGLE(B2), “,”), “SELECT Col2”)