# Address Clean: Clean an Israeli address list once: official city and street and flagged house numbers, with zip codes only once Israel Post approves.

> Address Clean takes a CSV or Excel file of Israeli addresses and returns it with city and street in the official names published by Israel's Population and Immigration Authority, missing or malformed house numbers flagged, and Hebrew and English output. A zip code column will come only from Israel Post's address file, and only after Israel Post approves its use in writing. We do not have that approval yet, and until we do, cleaning is half price and has no zip codes. Rows without a confident match are flagged, not guessed.

- Page: https://rotomal.com/en/address-clean-il/
- Category: Addresses and delivery
- Language: en
- Billing: one-time payment
- From: ₪149 one-time
- Request (free, no card): https://rotomal.com/en/address-clean-il/request/

- Any layout: one full-address column or separate fields, in Hebrew, English or mixed; we agree the column mapping with you before we start
- Every row gets a clear status: valid, corrected (with the original next to it), missing house number, city not found or street not found in that city
- Before you pay, we confirm the column mapping, the row count and the final price in writing

## A list collected over years doesn't match what couriers expect

Lists built from web forms, old exports and manual entry hold several versions of the same city: TLV, Tel Aviv, Tel Aviv Jaffa. Regional council names stand in for settlements, streets lack house numbers and old 5-digit zip codes linger. Each such row is a parcel that may come back.

Israel Post's zip code finder works one address at a time, and its full address file costs ₪8,000 plus VAT under a restrictive licence, according to the published contract. The government's open settlement and street lists are a good base, but they hold almost 64,000 street records, and someone has to match your file against them.

Address Clean does that matching once and returns a file you can load straight into your shipping system.

- Israel's Population and Immigration Authority publishes its settlement list on data.gov.il for free public use: 1,316 settlements, almost all with an official Latin name. Official names often differ from common spellings, for example QIRYAT ONO, PETAH TIQWA and RISHON LEZIYYON (last updated 1 November 2026). (source: https://data.gov.il/dataset/citiesandsettelments)
- According to the contract template Israel Post released after a 2019 freedom-of-information request, its address file costs ₪8,000 plus VAT. Third-party software that does anything other than show zip codes on a map needs prior written approval, and separating the zip codes into a new zip file is prohibited. (source: https://www.odata.org.il/dataset/056677d1-d3aa-43e5-9291-9ae77bf2af9f)
- Israel Post publishes a list of localities without street addresses where mail goes to boxes at distribution centres and the locality has one zip code, for example Rahat 8535700. (source: https://israelpost.co.il/media/3587/ישובים-ללא-כתובת-עם-חלוקה-מעורבת-164607.pdf)

## How it works

1. **Send your file.** Upload CSV or Excel through an encrypted link. We map the columns and confirm them with you on the first business day.
2. **Confirm the price.** We confirm by email the row count, the plan and the final price in writing, and that the zip code column is not available yet (hence half price).
3. **Pay once, get the file.** After payment the whole file is cleaned and returned within 2 business days, in the same layout with new columns beside your originals.
4. **Review what was flagged.** Rows not found or missing a house number are collected in a separate sheet.

## Features

- **Official city name.** Spelling variants, abbreviations and English names are matched to the official name and code. Regional council names are flagged, as they are not delivery addresses.
- **Streets that exist in that city.** Streets are matched only against the streets of the same city, including synonyms. A street not found there is flagged, never replaced by a similar street elsewhere.
- **House numbers.** Missing numbers, ranges, entrances, apartments and PO boxes are detected and split into columns; box-delivery localities are marked.
- **Zip codes.** A 7-digit zip code column from Israel Post's address file, only after Israel Post approves its use in writing; until then there is no zip code column. Old 5-digit codes are always flagged, and rows without a confident match stay without a code.
- **Hebrew and English.** City in Hebrew and its official Latin name; street in Hebrew and a marked transliteration.
- **Duplicates.** After normalisation, rows with the same name and address are flagged even if they were written differently. We flag, we never delete.

## Who it's for

- **International sellers with Israeli customers.** Addresses collected in English that need the Hebrew form and zip code before a local courier takes them.
- **Israeli online stores.** Before a platform migration, a big sale, or loading customers into a new courier's system.
- **Nonprofits and mailers.** Donor and member lists gathered over years, before sending letters, receipts or holiday packages.
- **3PLs and CRM teams.** Onboarding a client with a messy recipient list, or cleaning addresses before a CRM move.

## Works with

Excel (xlsx), CSV (UTF-8), Google Sheets (export and import), Shopify customer export, WooCommerce order export, Population and Immigration Authority lists (data.gov.il), Israel Post address file (only after written approval, not yet live)

## Pricing

One-time price per file, in shekels before VAT. We confirm the final price in writing before you pay. Founding customer pricing for early-access orders. The zip code column is not available yet: it needs Israel Post's written approval to use its address file in a service like this, and we do not have that approval today. Until it is in place, every order is half price (₪74.50, ₪195 and ₪495) and has no zip code column, or you can wait for the approval with no commitment. Over 50,000 rows: quote on request.

| Plan | Price | Includes |
| --- | --- | --- |
| Small file | ₪149 one-time | Official city and street names; Missing and malformed house numbers flagged; Zip codes (only after Israel Post approval); Hebrew and English output; Review sheet for flagged rows |
| Medium file | ₪390 one-time | Everything in Small file; Duplicates flagged after normalisation; Full-address column split into fields; One re-run of rows you fixed; 20-minute call on the results |
| Large file | ₪990 one-time | Everything in Medium file; Up to three files or sheets per order; Output layout for your target system; Two re-runs; Delivery in priority batches |

## Compared with the alternatives

- **Israel Post zip code finder.** Free and official, but one address at a time: days of manual work for thousands of rows.
- **Israel Post address file.** Per the published contract: ₪8,000 plus VAT, paid updates and restricted use. Suits an organisation that needs the file all the time and has developers, not a one-off clean.
- **A freelancer with Excel.** Can merge common spellings, but usually without matching each row to the official street list of its city, and unmatched rows tend to get "fixed" by guesswork.
- **GeoPostcodes and global data vendors.** License postal code and address validation data per country, on quote. Check their Israel coverage with the vendor; you still have to match your own file against it.

## Security and data

- Files arrive through an encrypted upload link and are stored encrypted at rest.
- Only the person cleaning your file and one reviewer can open it.
- Original and cleaned files are deleted 30 days after delivery, or sooner on request.
- We never contact your customers or use the list for anything else.
- If Israel Post approves, you receive zip codes for your own rows only, subject to its terms; Israel Post's file is never handed over.

## From request to clean file

Send a file, get the scope and final price in writing, then decide. Work starts as soon as the file arrives.

- Day 1: Encrypted upload link and column mapping agreed with you.
- Day 2–3: Row count, plan and final price in writing (half price while zip codes are unavailable).
- Day 3–5: After payment, the full cleaned file and the review sheet.
- Within 14 days: Re-run of rows you fixed, on plans that include it.

## FAQ

### What format should I send?

Excel or CSV, with one full-address column or separate fields, in Hebrew, English or mixed. We agree the column mapping with you before starting.

### Where do zip codes come from, and are they always right?

Only from Israel Post's address file, and only if Israel Post approves its use in the service in writing. We do not have that approval yet; until we do, orders are half price and have no zip code column. Israel Post does not guarantee the accuracy of its data, so neither do we: a row without a confident match stays without a code and is flagged.

### Do you fix addresses you can't find?

Not by guessing. A row we can't match is flagged with the reason, for example a street that doesn't exist in the stated city, and left as it is.

### Will every parcel arrive after cleaning?

Address Clean is a data cleaning service, not a courier. Clean addresses cut errors, but each courier's own acceptance and delivery rules still apply.

### What about privacy?

We process the file only to clean it and delete it 30 days after delivery, and sign a data processing agreement on request. This is not legal advice; check your obligations under Israeli privacy law with a lawyer.

### What if new addresses arrive every day?

Then validate them at the form instead. That is what Mikud Check does: an API and checkout plugin on a monthly plan.

### How long does it take?

The scope and final price in writing within 2 business days of receiving your file, and the full file within 2 business days of payment: up to 5 business days from request to clean file, not counting the time you take to approve and pay. On a large file you can get the urgent rows first.

## Guides

- [Israeli addresses in English: official names and spelling](https://rotomal.com/en/address-clean-il/israeli-address-in-english/): How Israeli city names are spelled officially in English (TEL AVIV - YAFO, PETAH TIQWA, RISHON LEZIYYON), why it matters for shipping, and how to store them.

---
Rotomal · https://rotomal.com/en/address-clean-il/ · hello@rotomal.com