We use cookies.This website uses essential cookies to operate core features. With your consent, we also use analytics cookies to understand traffic and improve the service. For more details, see our .
We use cookies.This website uses essential cookies to operate core features. With your consent, we also use analytics cookies to understand traffic and improve the service. For more details, see our .
Batch Latitude & Longitude Converter
Was this tool helpful to use?
Your feedback helps us make it better
Batch convert coordinates between WGS84, GCJ02, and BD09 online. Supports text paste and Excel upload with easy data export.
Input Format
One record per line, format: Longitude (lng) Latitude (lat)
Supports space, comma, tab separators
The selected systems apply to every coordinate in this batch. When pasting legacy four-column data, these selections take precedence.
• Supports up to 500 records per batch
• Automatic Longitude (lng) validation after clicking 'Next'
• If deduplication is enabled, duplicate records will be removed automatically
Overview
Understand what the tool solves, how it works, and the boundaries of its data.
This page converts rows of geographic longitude and latitude between WGS84, GCJ02, and BD09. WGS84 is widely used for GPS data; GCJ02 and BD09 are coordinate references used by mapping services in China. A coordinate pair can represent the same place but contain different numbers when expressed in different systems, so the source and destination labels need to match the data and the map or dataset that will receive it.
Each row contains longitude first and latitude second. Longitude ranges from −180° to 180° and latitude from −90° to 90°. The batch uses one selected source system and one selected target system for all rows. Conversion accuracy is not independently stated here, so treat output as a coordinate-system conversion result and verify critical locations against the destination mapping specification.
Guide
Follow the workflow and verify inputs and outputs with practical examples.
Paste one pair per line as longitude,latitude, or upload an Excel, CSV, or TXT file with separate longitude and latitude columns. The page also offers a spreadsheet template. Use decimal degrees; degrees-minutes-seconds notation is not accepted as a numeric pair.
Select the system used by every input row and the system required by the destination. The defaults are WGS84 to GCJ02. The same source and target cannot be selected. These selections apply to the entire batch.
Check that longitude and latitude columns are in the right order and that the values fall within valid geographic ranges. Start the conversion and inspect the status and converted pair for each record.
Use the result controls to export the completed batch. Keep the original file so you can compare records or repeat the conversion with corrected system labels.
For example, a row written -73.9857,40.7484 means longitude −73.9857° and latitude 40.7484°. West longitudes are negative; south latitudes are negative. Reversing the pair changes the location, even when both numbers are valid. The import layout expects longitude and latitude as separate fields; the text input example puts them in longitude,latitude order.
Use cases
See how the tool fits into real work and everyday tasks.
A data editor receives a spreadsheet of points and needs to express them in the coordinate reference used by a particular mapping workflow. Convert the rows together, then spot-check known locations before importing the file.
An operations team combines location rows from a partner with an existing dataset. Confirm the partner’s stated source system first, apply the same source and destination choices to the batch, and retain the source file for audit and correction.
Notes
Review scope, result limitations, and important precautions before use.
Related
Discover related tools, collections, and available API capabilities.