EN Sign in

Batch conversion from Excel/CSV

Up to 10,000 rows per file. Files are deleted after 7 days.

Download template
  1. Upload a fileExcel or CSV with an address or code columns
  2. ProcessingRuns in the background; you can close the page
  3. Download the resultWith a confidence level per row
Sign in to upload a file

The account is free. Results and history are kept in your account.

Sign in Create a free account

Columns are recognised by heading: "Address" (free text), or "Province", "District", "Ward", or the former province/district/ward codes. Up to 10 MB.

What batch conversion does

  • Excel and CSV

    Takes .xlsx, .xls and .csv (including CSV saved by Excel on Windows); up to 10,000 rows per file.

  • Finds the columns

    One free-text address column, or the three old province, district and commune codes; other columns are ignored.

  • Confidence per row

    Every row is marked Exact match, Needs checking or Not found, with the reason.

  • Excel and CSV results

    Rows keep the order of your file, with the new address, commune code and province code. Files are deleted after 7 days.

Recognised columns

Download template
dia_chi, address, địa chỉThe old address as free text, e.g. "12 Nguyễn Huệ, P. Bến Nghé, Q.1, TP.HCM".
province_code, district_code, ward_codeOld province, district and commune codes from the Statistics Office list (instead of an address column).
street_address, so_nhaHouse number and street; kept as they are in the new address.

Download the template for the exact format. The first row holds the column names.

Frequently asked questions

What if my old ward was split?
The answer is marked "Please check" and lists the possible new wards to choose from by house number and street.
Can I type without diacritics or with abbreviations?
Yes. The search box understands "p.", "q.", "tp", "hcm", text without diacritics and small typos.
How many rows can a batch file have?
10.000 rows per file. Files and results are deleted automatically after 7 days.