Running one lookup is easy. Running the same lookup on two thousand rows is the part that eats an afternoon. The bulk CSV tool takes a spreadsheet of coordinates, applies a single analysis to every row, and hands back a results table you can download.
You choose what gets added: the administrative hierarchy each point sits in, how far it is from the nearest border or the nearest coastline, the nearest city, town or village, or — for files with a second coordinate pair per row — the distance from each source to its destination.
How it works
Your CSV needs a SourceLatitude and a SourceLongitude column, plus an optional Location column for your own labels. Point-to-point runs also need DestinationLatitude and DestinationLongitude on each row. Two ready-made templates are downloadable from the panel so the column names are right first time.
Once the file is checked, the run is submitted as a background job instead of being processed while you wait in the browser. Results appear in the results view that matches the operation you picked, where the whole table can be downloaded as a CSV with the new columns appended.
How to use the Bulk CSV Lookup
- 1
Start from a template
Open the MapGO workspace, choose CSV from the Upload tools, and download either the single-point or the point-to-point template so your columns match what the tool expects.
- 2
Fill in your coordinates
Put one location per row, with latitude and longitude in decimal degrees. Add your own Location column if you want your labels carried through to the results.
- 3
Upload the file
Drop the CSV into the uploader. Rows are checked before anything is submitted, so invalid coordinates are flagged rather than silently processed.
- 4
Pick the operation
Choose Location Hierarchy, Distance to Border, Distance to Coastline or Nearest City / Town / Village. Files containing destination columns get the Point to Point Distance option instead.
- 5
Collect the results
Submit the run and let it process in the background. The matching results view lists the finished job and lets you download the enriched table as a CSV.
What people use it for
Enriching a customer or asset list
Turn a column of coordinates into country, region and municipality names so the list can be grouped, filtered and reported on.
Risk and insurance screening
Add distance to the nearest coastline or border to a whole portfolio of addresses in one run instead of checking them one at a time.
Logistics and territory planning
Measure every source-to-destination pair in a route list at once, or attach the nearest town to each depot or delivery point.
Data cleaning and QA
Catch swapped, truncated or out-of-range coordinates by checking which country each row actually lands in before the data is used.
Frequently asked questions
- What columns does my CSV need?
- SourceLatitude and SourceLongitude are required, and a Location column is optional for your own labels. Point-to-point runs also need DestinationLatitude and DestinationLongitude on each row. Downloadable templates cover both layouts.
- How many rows can one file have?
- The per-upload cap depends on your plan: 500 rows on Starter, 1,000 on Pro and 2,000 on Business. Larger jobs can be split across several uploads, within your monthly row allowance.
- Is there a monthly limit as well?
- Yes. Rows are counted against your plan's monthly allowance across the calendar month, and an upload that would take you past it is rejected before it runs rather than part-processed.
- Do I need a paid plan?
- Yes, bulk CSV runs are available on paid plans only. The individual lookup tools — hierarchy, border distance, coastline distance and point-to-point — can be used one location at a time without a subscription.
- How do I get the results?
- Each operation has its own results view in the dashboard. Open the one matching your run and download the completed table as a CSV with the new columns added to your original rows.