Orihako Data

Split addresses into prefecture and city

To total customers by prefecture or print labels: drop the list and the addresses split themselves.

Open “Split addresses into prefecture, city and street”

Steps

  1. Drop the list; a column named address is found for you.
  2. Prefecture, city, street and building columns are added after it.
  3. Addresses with no prefecture found are counted; fix them in the editor.
  4. Save, or hand it to Totals for a count per prefecture.

Questions

Wards of designated cities and counties?
They go into the city column.
Cities whose names contain "city" or "county" (Yokkaichi, Yamatokoriyama)?
Their whole names are read correctly.

The CSV is never uploaded; everything runs in this browser.