If this tool helped you, you can buy us a coffee ☕
Batch reverse geocode latitude and longitude coordinates into detailed addresses. Supports Excel upload and export, processing up to 500 records per batch.
Input Format
One record per line, format: Coordinate
Supports space, comma, tab separators
• Supports up to 500 records per batch
• Automatic Coordinate validation after clicking 'Next'
• If deduplication is enabled, duplicate records will be removed automatically
Scenario 1: Reverse Geocoding Device Locations
Logistics companies receive tens of thousands of vehicle GPS coordinates daily and need to quickly identify the street or neighborhood where each vehicle is parked for dispatch and delivery confirmation. Paste the coordinates into our tool to export a spreadsheet with addresses all at once, saving you from searching them one by one.
Scenario 2: User Distribution Profiling
App backends collect location coordinates when users log in. Operations teams want to analyze which provinces, cities, or business districts users are concentrated in. Batch import the coordinates, and the output will include province/city/district fields, ready for pivot table analysis.
Scenario 3: Converting Clustering Results to Addresses
Data scientists use clustering algorithms to group POI coordinates into clusters, with each cluster center being a latitude and longitude pair. Convert these center points into addresses so your reports can state, "The key area is near the intersection of X Road and Y Road."
116.397428,39.90923. If you have an Excel file, upload it directly (supports .xlsx/.xls).Suppose you have a set of mobile phone location coordinates (Latitude 39.90923, Longitude 116.397428) and want to see the exact location.
Input (Pasted Content):116.397428,39.90923
Output Result (Example):
| Input Coordinates | Full Address | Province | City | District |
|---|---|---|---|---|
| 116.397428,39.90923 | Tiananmen Square, Donghuamen Subdistrict, Dongcheng District, Beijing | Beijing | Beijing | Dongcheng District |
Interpretation: This coordinate corresponds to the vicinity of Tiananmen Square, with the address pinpointed to the street level. If you have hundreds of coordinates, each row will return an address in a similar format, which can be directly plotted on a map or used in reports.
1. My coordinates are from Baidu Maps. Can I use this tool?
Not directly. Baidu coordinates (BD-09) are secondary-encrypted and must be converted to WGS84 before input. You can use a third-party coordinate conversion tool or contact us for batch conversion services.
2. Why do some coordinates return "No Result"?
Possible reasons: The coordinates are in sparsely populated areas like oceans or deserts, or the coordinate precision is too low (e.g., fewer than 4 decimal places). Additionally, weak indoor GPS signals can also cause reverse geocoding to fail.
3. How many records can I convert at once? How is the cost calculated?
A maximum of 500 records per batch, at 5 coins per record. For example, if you upload 400 records, it will cost 2,000 coins. Conversion cannot start if your account balance is insufficient.
4. Can I use the addresses in the exported Excel directly for my project?
The addresses are for reference only and are not official administrative boundary data. They are recommended for internal statistical analysis. For legal documents or administrative registration, please refer to local government publications.
5. How do I preview data after uploading an Excel file?
After a successful upload, the table will display the first 5 rows of coordinates. Confirm the format is correct before clicking convert. If you find the column names are incorrect, you can adjust them manually.
6. How fast is the conversion?
500 records take about 5-10 seconds, depending on network conditions. Please do not close the page during the conversion process.
Now you can try your own coordinate data in the converter above.