Map Extract
Free tool

Scrub a call list against TPS, CTPS or do-not-call numbers

Choose the suppression file you already hold and the CSV you plan to call. The scrubber matches every phone number regardless of how it was typed, then splits your list into rows that are clear to call, rows to leave out and rows with no usable number.

Runs in your browser. Nothing you enter is uploaded.

Scrubbing a list

  1. Load the suppression file

    Under 1. Your suppression file, choose a CSV or text file. Every cell is read, so it does not matter which column holds the numbers. The note underneath shows how many numbers were found and how many lines had none.

  2. Load the call list

    Under 2. Your call list (CSV), choose the file you intend to work through. Leave First row is a header ticked if it has column names.

  3. Check the phone column

    The scrubber picks the column where most cells look like phone numbers, with a nudge for headers containing phone, tel or mobile. Change it in Phone column if it guessed wrong.

  4. Read the totals

    You see four figures: clean to call, suppressed, no usable number, and repeated numbers that were kept. The suppressed rows are shown in a table so you can see what was removed.

  5. Download the three files

    Download clean list is the one to call from. Keep the suppressed file as a record of what you excluded, and fix or discard the rows with no number.

Six prospects, three on the do-not-call file

The suppression file holds three numbers written as 01632960102, +44 7700 900456 and 0161 496 0333. The call list uses different formatting for each, and one row has no number at all.

All three matches are caught even though none is written the same way in both files, because each number is converted to its international form (+441632960102 and so on) before comparing. Brookside Vets and Easton Bakery share one number, so both stay on the clean list and the repeat counter shows 1: decide whether that is one business or two before you dial.

Input
Suppression file:
01632960102
+44 7700 900456
0161 496 0333

Call list:
business,contact,phone
Ashworth Joinery,Dan,01632 960102
Brookside Vets,Reception,0161 496 0111
Copperleaf Florist,Mel,07700 900456
Dene Valley Plumbing,,
Easton Bakery,Sue,(0161) 496-0111
Fairfield Opticians,Raj,+44 161 496 0333
Result
Clean to call: 2   Suppressed: 3   No usable number: 1   Repeated numbers kept: 1

Suppressed rows:
Ashworth Joinery,Dan,01632 960102
Copperleaf Florist,Mel,07700 900456
Fairfield Opticians,Raj,+44 161 496 0333

TPS, CTPS and your own list

The Telephone Preference Service is the UK register where individuals, including sole traders and many partnerships, opt out of unsolicited sales calls. The Corporate Telephone Preference Service does the same for companies and other corporate bodies. Under the Privacy and Electronic Communications Regulations (PECR), live marketing calls should not be made to a registered number unless that subscriber has told you they are happy to hear from you. The ICO's guidance on telephone marketing sets out the detail.

Separately, anyone who tells you directly not to call again should go on your own do-not-call list, whether or not they are registered. That list is the easiest one to forget, and it is the one this tool handles best, because you control how current it is. You can add your own numbers to the same suppression file as a TPS extract; the scrubber treats every number in it the same way.

This page explains what the tool compares. It is not legal advice on whether a particular call is allowed.

Before you start dialling

  • Your TPS or CTPS extract is recent enough for the campaign, and you know the date it was downloaded.
  • People who asked you not to call are in the suppression file too.
  • Repeated numbers have been checked, so one office is not called twice in a day.
  • You keep the suppressed file, so you can show what was removed and when.

Questions people ask

Does this tool check numbers against the live TPS register?

No. It compares your call list with a suppression file you choose, such as an extract from a TPS or CTPS screening service. It does not connect to either register, so it can only be as current as the file you supply. Download a fresh extract before each campaign if you rely on one.

Will it match numbers written in different formats?

Yes. Each number in both files is converted to international format before comparing, so 0161 496 0333, (0161) 496-0333 and +44 161 496 0333 are treated as the same number. Numbers too short or too long to be a real phone number are put in the no usable number file instead.

What is the difference between TPS and CTPS?

TPS is for individual subscribers, which includes sole traders and some partnerships using their own lines. CTPS covers corporate subscribers such as limited companies, public bodies and LLPs. A business call list can contain both kinds, so screen against both if you hold both files, and keep your own do-not-call list alongside them.

Are my files uploaded?

No. Both files are opened with your browser's file reader and compared in this tab using a lookup set held in memory. Nothing is sent to Map Extract or to a screening company, and the three CSV downloads are created on your device.

Where your data goes

Both files stay in your browser. Numbers are compared in memory on this page and the clean, suppressed and no-number files are generated locally; nothing is uploaded or looked up.

Checked against the tool on

Top