To fill a phone column in Google Sheets, run your company-name column through a lookup that returns each company’s number. The add-on writes the results straight into the column you choose, so nobody opens 480 browser tabs. But before you run anything, there’s one spreadsheet setting that will quietly ruin your results, and I learned about it the hard way.
Let me tell you about Rotterdam.
📌 TL;DR: Company websites and Google Business Profiles are free and slow, at roughly two minutes per company. An add-on fills the whole column in one pass. Format the output column as plain text BEFORE you run, or Sheets will eat your plus signs and leading zeros. Then check the calling rules before anyone dials.
Which Phone Number Are You Actually Looking For?
A switchboard number, a department line, or a person’s direct dial. They are three different jobs with three different difficulty levels.
The main switchboard. Published on the company’s own website, easy to find, and answered by someone whose job includes deciding whether you get through. Useful for verification and for reaching a department. Rarely a fast route to a buyer.
A department line. Sales, support, procurement. Often listed, often a queue, and genuinely helpful when you need the right team rather than a named person.
A direct dial. The number that rings on one person’s desk. This is the valuable one, and it is person-level data, not company-level data. A company lookup will not give it to you.
A mobile. Hardest to source and the strictest to use. More on the rules later, because they matter more than the sourcing.
This article is about the company-level numbers: the switchboard and the published lines you can fill in for a whole list at once. If you want the long manual version with every research trick in it, I wrote that separately in the guide to how to find business phone numbers. Person-level numbers live in the lead enrichment in Google Sheets workflow instead.
So let’s start where you should always start: without a tool.
How Do You Find Business Phone Numbers Without a Tool?
Check the company’s contact page, then its Google Business Profile, then its LinkedIn page. In that order.
The contact or imprint page. This is the most reliable source there is, because the company published it themselves. European sites are a gift here: German, Austrian and Swiss companies are legally required to run an Impressum page, and it usually carries a phone number, a postal address and a registration number. If you only have domains, or only have names, the find company websites step comes first, because the site is where the number lives.
The Google Business Profile panel. Search the company name and the panel on the right often shows a number straight away. Google’s own Business Profile documentation explains what businesses can list there. Best for local and physical-premises companies, thinner for pure software firms.
The LinkedIn company page. Sometimes carries a number in the About section, and usually confirms the head office location so you know which country code you’re looking for.
Directories and chambers of commerce. Industry associations and national business registers list members with contact details. Coverage is patchy and freshness varies, so treat them as a second opinion rather than a source of truth.
Now the arithmetic, because it is the whole argument. Finding and verifying one number takes me about two minutes. Forty companies is an evening. My Rotterdam list had 480, and that’s three working days of clicking. I know because I did the first forty by hand before I sat down and did the maths.
If you only need one or two numbers, the free routes are genuinely enough, and I compared them properly in the business phone number lookup guide. Past about fifty rows, you want the lookup running inside the sheet.
How Do You Fill a Phone Column in Google Sheets?
Install the add-on, point it at your company-name column, choose an output column, and run your rows.
Before any of that, do this one thing. Select your output column and set Format → Number → Plain text. Google’s number formatting help covers where the setting lives.
Why? Because my first Rotterdam run came back perfect and the sheet destroyed it. Sheets read “+31 10 …” as something arithmetic and stripped the plus sign. Every Dutch and German number lost its leading zero, too. My colleague spent a morning dialling numbers that could not connect, and the fault was one column format. Four minutes to fix, once I understood it.
Right. Now the run itself:
- Install the add-on. Grab the CUFinder add-on from the Google Workspace Marketplace. New to add-ons? Google’s help page explains how they install and where they appear.
- Copy your API key. Open your CUFinder dashboard and copy the API key from there.
- Enter the key in the add-on. Once, and you’re connected.
- Pick the service. Open the add-on from the Google Sheets menu. It opens as a right panel listing all the available enrichment services. For this job you want company name to phone, which takes company names and returns the company’s number.
- Map columns, set the range, run. Set the input column (your company names), the output column (the plain-text one you just formatted), and the row range, like rows 2 to 480. Then run it.
Two minutes of input hygiene will do more for your results than any setting. Use official company names rather than abbreviations. Keep one company per row. Add a country column if you have one, because “Nordwind Logistics” exists in three countries and they do not share a switchboard. And dedupe first, so you don’t pay twice for the same row.
An honest expectation before you press go: you’ll get company-level numbers for most rows, and blanks for some. Small firms without a web presence often have nothing published anywhere. That blank is the truth about the world, not a database failure.
💡 Pro Tip: Run rows 2 to 6 as a test batch first. Check that the plus signs survived, confirm the column mapping, THEN run rows 2 to 480. Five test rows have saved me from three separate mis-mapped columns.
A Worked Example: 5 Rows, Before and After
Say your target list looks like this. Company names in column A, the country in column B, and an empty column C formatted as plain text:
| A | B | C | |
|---|---|---|---|
| 1 | Company | Country | Phone |
| 2 | Vondel Freight Services | Netherlands | |
| 3 | Baltmark Shipping | Germany | |
| 4 | Corrib Pallet Systems | Ireland | |
| 5 | Saltmarsh Haulage | United Kingdom | |
| 6 | Heggen Kranverhuur | Netherlands |
Then I ran it: company name to phone, input column A, output column C, rows 2 to 6. A minute later, the same sheet looked like this.
| A | B | C | |
|---|---|---|---|
| 1 | Company | Country | Phone |
| 2 | Vondel Freight Services | Netherlands | +31 10 555 0182 |
| 3 | Baltmark Shipping | Germany | +49 40 555 0147 |
| 4 | Corrib Pallet Systems | Ireland | +353 1 555 0166 |
| 5 | Saltmarsh Haulage | United Kingdom | +44 20 5550 0139 |
| 6 | Heggen Kranverhuur | Netherlands |
Row 6 came back blank. Heggen Kranverhuur is a two-crane family business whose entire web presence is a listing on a regional directory, with no number on it. Nothing was found, so nothing was written. I’d take that over an invented number every day of the week.
Notice the plus signs survived, and the numbers stayed left-aligned as text. That is what a correctly formatted column looks like.
→ 480 companies → one run → 402 switchboard numbers → a morning your team spends talking instead of searching. That’s the whole point of putting sales prospecting data in the sheet where the work happens.
📌 Example: Rotterdam, summer 2023. Forty numbers in ninety minutes by hand, which projected to three working days for the full list. The bulk run returned 402 numbers from 480 companies in a single pass, and the 78 blanks were mostly firms with no published number at all.
How Do You Format and Verify Phone Numbers in a Sheet?
Store them as plain text in one consistent international format, then sample-check twenty rows before anyone dials.
This is the part nobody writes down, and it is where most phone columns quietly die. Let’s do formatting first.
When you get to the sample check, paste each test number into the free company-by-phone lookup and confirm the company it returns matches the company in that row.
Pick one format and normalise to it
Use the international convention: a plus sign, the country code, then the national number. That pattern is defined in the ITU’s E.164 recommendation, and it’s the format most dialers and CRMs expect. So +31 10 555 0182, not 010 555 0182 and not (0)10 555 0182.
Why bother? Because a national-format number is ambiguous the moment it crosses a border. Your SDR in Berlin cannot dial a Dutch number written the Dutch way without knowing to drop the zero and add +31. Normalise once, and nobody has to think about it again.
Keep extensions in their own column
Never glue “x123” onto the end of the number cell. It breaks click-to-dial, it breaks any import, and it makes deduplication impossible. One column for the number, one for the extension. Same rule for “ask for reception” notes.
Keep a country column beside it
Then you can spot a mismatch at a glance. A row marked Germany with a +44 number is either a UK office or a bad match, and either way you want to know before you call.
Verify with a twenty-row sample
Here’s my cheap and honest check. Take twenty rows at random. Confirm each country code matches the country column. Check the length looks plausible for that country. Then search two or three of the numbers and see whether they appear on the company’s own site.
If eighteen of twenty hold up, run the campaign. If twelve do, stop and look at your inputs before you burn anyone’s morning. That sampling habit is basic data verification, and it costs about ten minutes.
One last thing: date-stamp the column. Phone numbers move offices, get renumbered and get disconnected, and that kind of data decay is invisible until someone dials. A “found on” date tells the next person whether to trust column C or re-run it.
What Rules Apply Before You Dial a Business Number?
Business calls are legal in most places, but registries, consent rules and recording laws still apply.
None of what follows is legal advice, and the rules change by country. It’s the checklist I run before a calling campaign, and it has kept me out of trouble.
- United States. The Telemarketing Sales Rule sets out what telemarketers may and may not do, and the FTC publishes a compliance guide in plain language. Sellers who call consumers have to scrub against the Do Not Call registry, and access for that runs through the registry’s telemarketer site. Business-to-business calling is treated differently from consumer calling, which is exactly why you should know which one you’re doing.
- Mobiles and autodialers. Calling a mobile with automated dialling equipment carries stricter rules than dialling a published switchboard. If your list mixes the two, keep a “number type” column and treat mobiles as a separate campaign.
- European Union. A switchboard number is company data. A number tied to a named person is personal data under GDPR, so you need a lawful basis and an easy way for someone to ask you to stop. Several member states also run their own opt-out registers for business calls.
- Call recording. Consent requirements vary between one-party and all-party consent, sometimes within the same country. Check before you switch recording on, not after.
Here’s the honest framing. Cold calling a published business number is normal commercial behaviour. Dialling a personal mobile you scraped from somewhere, with an autodialer, into a market whose rules you haven’t read, is not. The difference is ten minutes of checking.
What Mistakes Should You Avoid With Bulk Phone Lookups?
Four of these have cost me real hours, and one of them cost a colleague a whole morning. Consider it a scar map.
- Leaving the output column on automatic format. The plus sign vanishes, the leading zero vanishes, and the numbers look fine until someone dials. Plain text, always.
- Enriching the header row. Start every range at row 2, or you’ll spend a lookup searching for a company called “Company”.
- Assuming a switchboard reaches your buyer. It reaches a gatekeeper. That’s a different conversation, and you should plan for it rather than be surprised by it.
- Dialling before checking the rules. Registries and consent requirements exist whether or not you looked them up.
- Storing extensions inside the number cell. It breaks dialers and it breaks dedupe.
- Never refreshing the column. Numbers go stale quietly. Re-run anything older than a year before a campaign leans on it.
🔍 Did You Know? My first bulk run returned 402 good numbers and I still wasted a morning, because one column was formatted as "Automatic" instead of "Plain text". The data was fine. The container wasn't.
If you want more than a phone number beside each company, that’s a wider job. Industry, size, location and the rest are covered in company enrichment in Google Sheets, which fills the same list with firmographic data. And if your list arrived as a column of domains rather than names, start by turning those into names with the domain to company name workflow.
FAQ: Company Phone Numbers
How do I look up a business phone number?
Start with the company’s own contact page, which is the most reliable source. Then try its Google Business Profile panel and its LinkedIn page. For a list rather than a single company, run the whole column through a lookup instead of opening tabs one at a time.
Are telephone numbers public information?
A number a business publishes on its own website is public. A personal mobile is not, even when it turns up somewhere online. Privacy rules and calling registries still apply to both, and they apply to how you use the number rather than how you found it.
Is there a 100% free phone lookup?
Free directories and search engines exist, and they work. The trade-off is coverage and freshness: you’ll find the big companies easily and the small ones inconsistently, and nobody tells you when a listing went stale. Free costs time instead of money.
How do I find phone numbers for a whole list of companies at once?
Run the whole company-name column through a company-to-phone lookup in one pass. Format the output column as plain text first, then set your row range and go. Expect blanks for very small firms with nothing published anywhere.
How do I get a business phone number for my own business?
That’s a phone-service question, not a data question. A VoIP or telecom provider issues you a new local, toll-free or virtual number. This guide is about the opposite job: finding the numbers other companies have already published, so you can contact them.
Why did my phone numbers lose their plus sign in Google Sheets?
Because the column was set to a numeric format. Sheets then read the value as a number and dropped the plus sign and any leading zero. Set the column to Format → Number → Plain text before you paste or run anything, and the characters survive.
Can I call any business number I find?
Business calling is broadly allowed, with conditions. Registries, consent rules for mobiles and automated dialling, and call-recording laws all vary by country. Check the rules for the markets on your list before the first call, and keep a record of what you checked.
How often should I refresh a phone column?
Every six to twelve months, and always before a campaign that depends on it. Companies move offices, change providers and renumber whole switchboards. A “found on” date column beside the numbers tells you at a glance whether a re-run is due.
It’s Time to Fill That Phone Column
Three honest routes, and one rule that matters more than all of them. The contact page for a handful of companies. Directories and profiles as a second opinion. An add-on for anything past fifty rows. And plain text on that output column, every time.
Picture the version of your list that has a clean, dated, country-tagged phone column beside every company. Nobody hunting. Nobody dialling a number with a missing digit. Just calls.
Phone is only one column, of course. The whole data enrichment in Google Sheets hub covers what else belongs beside it. So tell me in the comments: how many companies are on your list, and how many of them do you actually have a number for?
Bad
Okay
Good
Amazing
