Extract Phone Numbers from CSV

Extract Phone Numbers from CSV

Extract Phone Numbers searches the cells of a CSV for telephone numbers and lists each one on its own output row, together with the spreadsheet row and the column it came from. It suits exports where a notes, comments or description column mixes numbers into ordinary sentences.

A plain text search is weak here because one person's number can appear as 555-0147, (555) 0147 or +1 555 0147. The pattern used here accepts those shapes. Email addresses and URLs are removed from each cell first, so a local part such as 555-0147@mail.example is not reported as a phone number. Phone numbers are personal data, so the scan runs on your device and nothing is uploaded.

Key features

• Matches +country codes, brackets, dashes, spaces and dots
• Row and column reference for every match
• Skips email addresses and URLs in the same cell
• Digit-count and format checks to reduce false hits

About the CSV to CSV format

A match may begin with a + and a country code of one to three digits, may include a bracketed area code, and then continues in groups of digits joined by spaces, dots or dashes. A candidate is kept only when it contains between 7 and 15 digits. Dates written 2024-03-02, IPv4 addresses such as 192.168.10.10 and plain decimals such as 1234.5678 are rejected even when they fit the shape. Digits with no separator are ignored unless they start with +.

The row column uses spreadsheet numbering: the header is row 1, so the first data row is row 2.

How it works

Each data cell is cleaned of URLs and email addresses, then searched with a pattern that allows an optional country code, an optional bracketed area code and digit groups joined by separators. Each candidate is checked for 7 to 15 digits and rejected if it matches an ISO date, an IPv4 address or a plain decimal. Every surviving match becomes one row.

Common use cases

• Locating phone numbers hidden in a support ticket's notes column before a data subject access request
• Building a call list from a free-text comments field in a survey export
• Finding records whose number sits in a notes field rather than the dedicated phone column

How to use this tool

1. Paste the CSV or upload the file.
2. Click Extract to scan every cell.
3. Filter the output by column in your spreadsheet, or paste the phone values into your dialer or CRM import.

Example

contact,notes
Maria Lopez,Call +34 91 123 4567 after 5pm
Tom Reed,Office (212) 555-0147 or ext 22
Lee Park,Order #88421 shipped on 2024-03-02

row,column,phone
2,notes,+34 91 123 4567
3,notes,(212) 555-0147

Tips for best results

• Scan only the free-text columns when you can. Every cell is scanned by default, so order references that happen to contain separated digit groups can also match.
• Expect one output row per match. A cell with two numbers produces two rows that share the same row and column values.

Common errors and how to fix them

Provide file or paste input text.

Nothing was pasted and no file is selected. Add the CSV before clicking Extract.

A number is visible in the cell but missing from the output.

A run of digits with no separator, such as 5550147, is never matched. Add a space, dot, dash or bracket between the groups, or a leading + before the country code, and extract again.

Best practices

• Check each match against its cell before you call it a contact. The output has no surrounding text, so an order reference or tracking code written with dashes looks the same as a phone number.
• Normalize the formats after extraction if you need one style, using find and replace to remove brackets and dashes.

Frequently asked questions

For more background on data formats and conversion workflows, read our format guides.