If your table already has coordinates, PinPop maps them directly. Nothing is looked up and nothing is sent to Google for those rows, so a list with coordinates costs no geocoding at all.
Columns PinPop recognizes #
- Two columns with headers such as Latitude and Longitude, Lat and Lng, Lon or Long, Y and X, or Breite and Länge.
- One column with both values as text, for example
51.5072, -0.1276. Choose it as Coordinates (one column) under More columns in Match your columns if PinPop does not pick it by itself.
Headers with other names work too: choose them in Match your columns, under More columns (More options > Edit data link).
Formats PinPop reads #
- Decimal degrees as numbers or as text:
48.8566and2.3522. - A comma as the decimal mark, as Excel shows it in many European settings:
48,8566. - GPS notation in degrees, minutes and seconds or in decimal minutes, for example
48°51'24"N.
Latitude goes from -90 to 90 and longitude from -180 to 180. Rows outside those ranges, rows at exactly 0, 0 and cells PinPop cannot read are left off the map and listed in More options > Issues.
When most latitudes in a column are clearly longitudes, PinPop reads the two columns the other way round and says Latitude and longitude look swapped. PinPop reads them the other way round. Your cells stay as they are.
Coordinates for some rows, addresses for others #
A table can mix both. When PinPop knows the address columns and the coordinate columns, rows with coordinates are mapped as they are and rows with an empty Latitude or Longitude cell are looked up from their address. PinPop fills only empty coordinate cells.
Coordinates you typed are never overwritten #
PinPop writes a Match value next to every coordinate it looked up itself. Coordinates without a Match value, or next to Not found, count as yours:
- PinPop never changes them, not even with Look up all addresses again.
- If you type over coordinates PinPop wrote, they become yours from then on.
- To have PinPop look a row up again, clear its Latitude, Longitude and Match cells. The row is then looked up from its address.
A cell that is not empty but cannot be read as a coordinate is never overwritten either; it shows up in Issues so you can fix it.
