Local operations teams
Route planning
Favorable to scraping
Convert store, clinic, warehouse, or service-area addresses into coordinates before loading them into routing, dispatch, or territory-planning spreadsheets.
Directories$50Free
Address Converter Latitude and Longitude Scraper
This address converter latitude and longitude scraper turns a list of street addresses into a structured CSV export with address, latitude, and longitude columns. Import the workflow into the UScraper local desktop app, replace the sample Nominatim search URLs with your own addresses, and run a controlled address-to-coordinates batch without building a geocoding API integration.
Output
CSV
Columns
3
Input mode
Multi-URL
Pacing
1 sec
Template
Free
At a glance
Convert addresses to coordinates in a local workflow
The template uses OpenStreetMap Nominatim search URLs with format=json and limit=1. Each URL carries the cleaned geocoding query and an address_label parameter, so the CSV preserves your original address even when the lookup query is simplified.
This is useful for location cleanup, branch mapping, delivery-zone checks, and any address to CSV task where analysts want coordinates beside an existing list.
Who this is for
Address geocoder scraper use cases
Market researchers
Map analysis
Favorable to scraping
Build a quick coordinate table for competitor locations, public venues, or branch lists before moving the data into a GIS or business-intelligence tool.
Data enrichment teams
CSV cleanup
Favorable to scraping
Add latitude and longitude fields to internal address lists while keeping the original address string visible for QA and manual corrections.
How to use
Run the address to coordinates workflow
1
Download and import
Download the hosted JSON template, import it into UScraper, and open the workflow graph.
2
Replace the sample addresses
Edit the Navigate URLs with your own encoded Nominatim search queries. Keep address_label aligned with the original address you want preserved in the CSV.
3
Confirm the export folder
Structured Export writes address_converter_latitude_and_longitude.csv with headers and append mode. Change the save location before running client or project batches.
4
Run the loop
UScraper navigates to each lookup URL, waits for the body, parses the JSON response, exports the row, sleeps for one second, and continues to the next input.
5
Review the coordinates
Open the CSV, check blank rows or surprising coordinates, and manually verify edge cases such as suites, floor numbers, landmarks, or incomplete postal addresses.
Automation path inside the template
- 1
Navigate
Open each prepared Nominatim search URL from the multi-input list.
- 2
Wait and read
Wait for page load and confirm the
bodyresponse is visible. - 3
Structured export
Parse the JSON body and append address, latitude, and longitude into one CSV.
- 4
Loop continue
Pause briefly, then advance to the next address lookup.
Output preview
CSV columns for latitude longitude export
The export shape is intentionally narrow so it can drop into Excel, Sheets, CRM cleanup, routing tools, or a follow-up map workflow. Each row represents one configured lookup URL.
| address | latitude | longitude |
|---|---|---|
| 48 W 22nd St New York, NY 10010 | 40.741686 | -73.9925668 |
| 5 E 57th St New York, NY 10022 | 40.7629171 | -73.9731485 |
| 35 W 31st St Fl 6 New York, NY 10001 | 40.7473476 | -73.987609 |
address_converter_latitude_and_longitude.csvColumn
address
The original address_label value, or the query string when no label is supplied.
Column
latitude
The first matched lat value from the geocoder JSON response, with sample fallbacks for the bundled preview addresses.
Column
longitude
The first matched lon value from the geocoder JSON response, with blank output when no match is found.
Sample rows
2 of many
| address | latitude | longitude |
|---|---|---|
| 1590 3rd Ave New York, NY 10128 | 40.7809644 | -73.952646 |
| 77 Irving Pl New York, NY 10003 | 40.7369497 | -73.986783 |
Headers included - one row per configured address lookup
Pair this geocoding data extractor with the OpenStreetMap Scraper when you need POI tags after coordinates, the Google Search Scraper for source discovery, and the Contact Details Scraper when mapped businesses need public website enrichment. The broader UScraper template library has sibling workflows for directories, maps, and search exports.
Comparison
Local CSV workflow vs geocoding APIs
This UScraper template
Local CSVHosted geocoding APIs
APISetup
Import JSON and edit URLs
Good for no-code users who want a visible workflow.
Create account, key, and request code
Better for developers and production systems.
Output
address, latitude, longitude CSV
Append mode keeps the batch in one local file.
JSON responses or hosted batch files
Usually needs transformation before spreadsheet use.
Scale
Small reviewed batches
Use pacing and manual QA for sensitive data.
Contracted bulk throughput
Use when service levels, quotas, and billing are required.
Custody
CSV stays in your chosen folder
No UScraper cloud upload in the stock workflow.
Requests pass through provider systems
Check vendor retention, privacy, and compliance terms.
Frequently asked questions
Geocoding public or business addresses is common, but your use may still be limited by source rights, privacy rules, service terms, and local law. Use addresses you are allowed to process, avoid sensitive personal-location datasets, respect Nominatim usage policy, and get legal review before publishing or reselling coordinates.
Before you run
Practical limits and maintenance notes
Guardrails for reliable geocoding exports
Rate limits
Public geocoding services are not bulk infrastructure
Keep batches modest, avoid parallel loops, retain the one-second pause or increase it, and move to a contracted provider when you need guaranteed throughput.
Address quality
Ambiguous inputs can produce wrong or blank coordinates
Suites, floor labels, missing cities, postal-code errors, and landmark-only addresses may need cleanup before the first run. Preserve the original address so review is possible.
Compliance
Location data can become sensitive
Do not enrich personal-location datasets unless you have a lawful basis and a clear retention policy. For business addresses, keep source context and usage permissions with the export.
Download the free template, install the desktop app from UScraper download, and use this workflow when you need to convert addresses to latitude and longitude in a structured local CSV.
Get Started
Download and use this template instantly
$50Free
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates