Batch Excel address converter

Upload a list of old addresses, and this tool fills in the new Province and Ward for every row. Runs right in your browser — the file is never uploaded to a server.

Download template (.xlsx)
📄

Drag and drop a .xlsx file here, or click to browse

Frequently asked questions
How does this tool work?

Upload an Excel file with a list of old addresses (Province, District, Ward), pick the matching columns, and the tool looks up and appends the new Province and Ward for every row based on Vietnam's 07/01/2025 administrative merger data, then lets you download the result. All processing happens right in your browser — the Excel file itself is never uploaded to a server, keeping your data private.

Is my file uploaded to a server?

No. Reading, looking up, and writing the result file all happen with JavaScript in your browser. Only province/district/ward reference data queries (which contain none of your file's content) are sent to the server.

What format should the address names be in?

Use the full official name as shown in the lookup tool, e.g. "Thành phố Hà Nội" rather than "Hà Nội". The tool still tries to match case- and diacritic-insensitively, but full names give more accurate results.

My file has several thousand rows, can it handle that?

Yes. The tool processes rows in small batches so your browser doesn't freeze, with a progress bar to track it.