Batch Geocoding (Address to Coordinates)

Typical Use Cases

You have hundreds of customer addresses to import into a map for a heatmap, or you need to batch-annotate store locations into your company's internal GIS. Searching a map and copying coordinates one by one is time-consuming and error-prone. With this converter, you can instantly turn addresses into latitude and longitude, export them, and paste them directly into your map.

• Batch positioning of customer addresses: For example, a company has 2,000 customers. Upload them in batches of 500, and the resulting coordinates can be used directly on data reports or visualization dashboards.
• Importing stores to maps: A chain brand opens 50 new stores. Organize the store addresses, convert them to coordinates at once, and import them into the Baidu Maps / Amap merchant backend to automatically tag store locations.
• Geocoding addresses for ad targeting: When delivering LBS ads, offline branch addresses need to be converted into lat/long geofences. Batch conversion is dozens of times faster than manual queries.

How to Use This Tool

1. Open our Batch Address to Coordinate Converter. You will first see a large text box and a "Choose File" button.
2. Prepare address data: Write one detailed address per line, such as "1 Jianguomenwai Avenue, Chaoyang District, Beijing". If the address information is incomplete (e.g., only the community name), we recommend adding the city or district to make parsing more accurate.
3. Paste directly into the text box, or click "Choose File" to upload an Excel file (.xlsx or .csv). The Excel file only needs one column named "Address".
4. Confirm the number of addresses (max 500 per batch) and click "Start Conversion". The system deducts 5 coins per address and prompts you to recharge if your balance is insufficient.
5. Once the conversion is complete, a table will appear in the right-hand result area: each row contains the original address, the parsed Province/City/District, and the coordinates (lng/lat). You can click "Export Excel" to download all the data.

Complete Example / Practical Steps

Let's use a real logistics company's delivery point list as a demonstration. Suppose you want to convert the following 3 addresses:

1. Paste these three lines of addresses into the input box.
2. Click "Start Conversion". The system calls the geocoding service and returns the results in about 2 seconds.
3. The result table shows:
   Address 1 → Province: Beijing, City: Beijing, District: Chaoyang District, lng: 116.4604, lat: 39.9094
   Address 2 → Province: Shanghai, City: Shanghai, District: Pudong New Area, lng: 121.5074, lat: 31.2430
   Address 3 → Province: Guangdong Province, City: Guangzhou, District: Tianhe District, lng: 113.3265, lat: 23.1291
4. Copy these coordinates into a map tool, and you can directly see the locations of the three points, which are basically near their corresponding landmarks.

Note: If the address is not precise enough (e.g., writing only "Guomao Building" without the city), the parsing result may be empty or the coordinates may have a large deviation. Try to complete the province, city, and district before uploading.

How to Read the Results / Value Meanings

Each address returns three key pieces of information:

• Province/City/District: The administrative divisions extracted from the address by the parser. If this part is empty, it means address recognition failed.
• lng (Longitude): East longitude is positive, west longitude is negative. China's range is between 73° and 135°.
• lat (Latitude): North latitude is positive. China's range is between 4° and 53°.

Coordinate accuracy can usually reach the street level (10-50 meters error). Some remote rural areas may only reach the township level (around 500 meters error). You can judge the quality of the current batch by comparing a few known landmarks (like a subway station near your company). If an entire row of results is empty, it means the address is written incorrectly (e.g., missing the city, or misspelled province/city/district names).

Common Mistakes / Pitfalls

• Incomplete addresses: Writing only the "community name" without the city name makes it impossible for the system to determine which city's community it is, resulting in coordinate errors or parsing failures. It is recommended to include at least the district/county level.
• Multiple addresses on one line: Some people write "Beijing...; Shanghai..." on the same line. The system will treat it as a single address to query, and the results will be completely wrong. Please ensure there is only one independent address per line.
• Excel format errors: If the column name in the uploaded Excel is not "Address", the system may not be able to read the data. Please ensure the first column or the column with the matching name contains the address content.
• Ignoring payment rules: This tool is a paid version, costing 5 coins per address, with a maximum of 500 addresses per batch. If the account balance is insufficient, the conversion will be interrupted, and consumed coins will not be refunded. Please check your balance before operating.
• Using the wrong map coordinate system: The coordinate system we use is WGS-84 (the internationally accepted latitude and longitude). If you want to apply the coordinates to Amap or Baidu Maps, you need to convert them to the corresponding GCJ-02 or BD-09 coordinate systems first (this tool does not provide conversion; you need to use other tools).

Frequently Asked Questions (FAQ)

Q1: How many addresses can be converted at a time?

A maximum of 500 addresses per batch. If you have 2,000 addresses, you need to perform the operation 4 times. You can upload up to 500 rows at a time; anything beyond that will trigger a prompt.

Last updated June 18, 2026 · Maintained by Toolkk