+687 phone number formatter for New CaledoniaPaste your numbers, however messy. They come out ready to send.
Every number in +687 format, duplicates counted, doubtful numbers set aside with the reason why. Your list stays in your browser.
Updated on · SMS PRO team
A tool from New Caledonia's bulk SMS pioneers, here since 2016: our own rules, applied right in your browser. Nothing is sent.
+687 format, across the board
56 00 01, 56.00.01 or 00687 56 00 01: they all come out as +687 56 00 01.
Nothing guessed, everything explained
A doubtful number is set aside with its reason, never patched up at random.
Duplicates counted
The same parent for two children? Only one line is kept.
It all stays with you
Formatting happens in your browser, and the CSV is created on your own computer.
Behind every file, someone kept it up to date.
A school secretary, a volunteer treasurer, a shopkeeper: each one noted numbers down their own way. Dots, dashes, the odd +687. The formatter brings them all into line, without losing any of their work.
Everything else is noise.
Spaces, dots, dashes, brackets, a stray “Tel.”: none of it counts. The +687 or 00687 code is recognised, then the six digits are checked. Pick a number and watch it go through.
Six digits, no leading zero. That's it.
56 00 01: that is a New Caledonian number. From overseas, you add +687 or 00687. The formatter produces the +687 form, which is also the one SMS PRO uses to send.
What gets recognised
| In the file | What the formatter does |
|---|---|
56 00 01Six digits, with or without spaces | Valid +687 56 00 01 |
56.00.01Dots between the pairs | Valid +687 56 00 01 |
(56) 00-01Brackets and dashes | Valid +687 56 00 01 |
+687 56 00 01The country code with a + | Valid +687 56 00 01 |
00687 56 00 01The country code with 00, as dialled from overseas | Valid +687 56 00 01 |
Tel. 56 00 01A label stuck to the number | Valid +687 56 00 01 |
Better a number set aside than a text to a stranger.
A file kept by hand for years mixes every way of writing a number. The formatter sets numbers aside without guessing, and tells you why.
| In the file | What the formatter does |
|---|---|
56 00 1A missing digit | Set aside Too short |
56 00 011One digit too many | Set aside Format not recognised: 6 digits for New Caledonia, +XX… for other countries |
16 00 01A first digit that cannot exist | Set aside A New Caledonian number does not start with 0 or 1 |
+687 +687 56 00 01The country code typed twice | Set aside 6 digits expected after +687 (9 found) |
87 56 00 01A truncated country code | Set aside Ambiguous format: write the 6 digits or +687 |
06 00 00 00 00A mainland France number without its country code | Set aside French number: write it as +33… |
56 00 01 / 56 00 02Two numbers in the same cell | Set aside Format not recognised: 6 digits for New Caledonia, +XX… for other countries |
Duplicates, on the other hand, are not mistakes. In SMS PRO, a number that sits in two groups gets a single SMS if the text is identical, and one SMS per text if they differ.
Before you send, you know who won't get it.
The formatter reads how a number is written, not the line behind it. When you send, SMS PRO sets aside landlines, unreadable numbers, duplicates and unsubscribed contacts, each with its reason. An overseas number is written with a + and its country code: +61 for Australia, +64 for New Zealand, +33 for mainland France.
Your list is clean. Now for the message.
Import the list as it is, write once, and everyone gets their own version with their first name. Sent under your name, just as organisations across New Caledonia have done with us since 2016.
Import without retyping
Paste from Excel or import a CSV, with a preview before anything goes in. See how to send SMS from Excel.
Write once for everyone
First name, class, appointment date: each contact gets their own version, and our SMS templates give you a strong text to start from.
Check before it goes
How many people, how many SMS each. Measure your text with the SMS character counter.
Your questions, answered.
Do I need to put +687 in front of my numbers?
No, not for a New Caledonian number. Six digits are enough, such as 56 00 01: SMS PRO adds the +687 country code itself. If your file already has +687 or 00687, those forms are recognised too.
What is an ambiguous number?
A number that could be read two ways. Take 87 56 00 01: eight digits starting with 87, possibly a 687 country code with its first digit lost. Rather than guess, the formatter sets it aside and asks you to write the 6 digits or +687.
Are my numbers sent anywhere?
No. Formatting happens in your browser: no number is passed on, neither to us nor to any audience-measurement service. The CSV file is created on your own computer.
How many numbers can I paste?
5,000 lines per pass. Beyond that, only the first 5,000 are processed: paste the rest in a second go.
Can the formatter tell whether a number is a mobile?
No. It checks how the number is written, not the line behind it. When you send, SMS PRO is the one that sets landlines aside and shows them to you, with the reason.
Related pages
Send SMS from Excel
Your file as it is, with every column usable in the message.
Sending SMS in New Caledonia
Numbers, characters, sending hours and sender ID, explained step by step.
SMS templates
Ready-made messages for every line of business, yours to adapt.
Clean numbers. All that's missing is the message.
An adviser in Nouméa calls you back and shows you how to import your file as it is, then send each person their own message, under your name. Your list stays with you until your account is open.
50 free SMS to try, no commitment: contact@smspro.nc