Split addresses into prefecture and city
To total customers by prefecture or print labels: drop the list and the addresses split themselves.
Steps
- Drop the list; a column named address is found for you.
- Prefecture, city, street and building columns are added after it.
- Addresses with no prefecture found are counted; fix them in the editor.
- Save, or hand it to Totals for a count per prefecture.
Questions
- Wards of designated cities and counties?
- They go into the city column.
The CSV is never sent anywhere; everything runs in this browser.