SINGAPORE ADMINISTRATIVE DIVISIONS DATA
Ready-made administrative divisions of Singapore: 5 regions → 55 planning areas → 332 subzones. Delivered as Excel, CSV, SQL and JSON with local names, Latin names and codes. Drop it into address pickers, location pages, CRMs and customer-data filters.


What is in the pack
- 332 lowest-level units with every parent level: 5 regions → 55 planning areas → 332 subzones
- Excel with filters and frozen header; CSV opens cleanly in Excel
- SQL file creates and fills the table in MySQL / MariaDB in one run
- Tree JSON for cascading address pickers, flat JSON for code
- Local-script names, Latin (English) names and a code for every unit
- Working address-picker demo, README in English and Vietnamese
- Singapore has no wards; the file uses the URA Master Plan 2019 planning hierarchy.
Set up in 3 steps
- Pay, download the zip and extract it
- Open the .xlsx to use it right away, or import the .sql file into your database
- For an address picker: copy the -tree.json file and follow demo.html
Good to know before buying
- Singapore has no wards; the file uses the URA Master Plan 2019 planning hierarchy.
- Compiled from open datasets, credited inside the pack. Snapshot of 9 October 2026; administrative units may change afterwards.