The fastest way to find company websites in Google Sheets: run a name-to-domain add-on on your company-name column. It matches each name against a company database and writes the official website into the column you choose. In this guide, I’ll show you the manual routes first (because for a short list they’re genuinely fine) and then the bulk workflow I use when the list has hundreds of rows.
I’m going to be honest with you. I once tried to Google my way through 300 company names by hand. It cost me two evenings, and it still ended with a proposal that quoted the WRONG company’s blog. I’ll tell you that story in a minute.
Let’s get into it.
📌 TL;DR: Three ways to turn company names into websites: (1) Google each name and copy the domain (fine for 20 rows, brutal for 300); (2) build a helper formula that opens a ready-made search per row (faster manual checking, still manual); (3) run a name-to-domain add-on on the whole column: input column of names, output column of official websites, row range like 2-300, one run. Same logic works for Excel via a CSV round-trip.
What Does Finding Company Websites in Google Sheets Actually Involve?
It means converting a column of company names into official website domains, in bulk, right inside your spreadsheet. The technical name for the job is name-to-domain conversion: “Hansel Logistics” goes in, hansellogistics.com comes out.
And the word “official” is doing real work in that sentence. For most companies there are lookalike domains, reseller pages, and old rebrand leftovers floating around. A company URL finder worth using gives you the domain the company actually operates, not the first thing a search engine coughed up.
Why does this column matter so much? Because the website is the INPUT for everything else about a company record. Enrichment services, email finders, and B2B data enrichment tools all match more reliably on a domain than on a name. Two companies can share a name. Only one owns the domain.
So the real question is speed. How fast can you fill that column without filling it with junk? Let’s start with the free routes.
How Do You Find a Company’s Website Manually?
You Google the name plus “official website,” check the company’s LinkedIn page, or speed things up with a helper formula. Each route works. Each has a ceiling. Here’s the honest version of all three, plus the formula tricks that don’t work. And if you’re researching a single company outside a spreadsheet, the full walkthrough on how to find a company website based on its name goes deeper on the same checks.
Googling It, Properly
Search the company name plus a word like “official site” or its industry. Then read the domain in the result, not just the title. Does it match the brand? Does the snippet describe the right company, in the right country? That check takes 1-2 minutes per row when you do it carefully.
And carefully is the catch. In 2021, I had a 300-row trade-fair exhibitor list: names only, no URLs. I got through about 60 rows in two evenings. Worse: for one logistics company, I grabbed a lookalike domain owned by a similarly named firm. My proposal referenced their blog. The wrong company’s blog. The prospect noticed. I still cringe.
📌 Example: My 2021 exhibitor list: 300 rows, 60 done manually in two evenings, one wrong-company proposal sent. The remaining 240 rows later took one add-on run and a 20-row spot-check. The list didn't change. The method did.
A Helper Formula That Speeds Manual Up
If you’re doing manual checks anyway, make the sheet work with you. The HYPERLINK function can build a click-ready search for every row:
→ =HYPERLINK(“https://www.google.com/search?q=”&ENCODEURL(A2&” official website”),”Search”)
Drag it down the column and every row gets a one-click search link. Honest caveat: this speeds up manual checking. It does not fill cells for you. You still read, judge, and paste. It just kills the retyping.
LinkedIn Company Pages
Most company LinkedIn pages list the website in their About section, and that field is usually maintained by the company itself. So it’s a solid cross-check when Google gives you two candidates. I’ve written before about how to find a company’s website from a LinkedIn profile. The same logic applies row by row. Fine for 15 companies. Not for 300.
Why the Guessing and Scraping Formulas Break
You’ll be tempted to concatenate: company name, lowercase, strip spaces, add “.com”. Don’t. Brand names differ from legal names, legal names differ from domains, and half the world doesn’t live on .com. “Marlow & Sons” is not marlow&sons.com. The guess LOOKS filled, which makes it worse than empty.
The other temptation is scraping search results with IMPORTXML. But search engines block automated result scraping, so the formula fails or silently returns junk. And one more honest flag: tools like domain-name-search sites and ICANN Lookup (which dominate this keyword’s search results) solve a different job. They check whether a domain is available to REGISTER. You’re trying to find a site that already exists.
🔍 Heads-Up: Search "how to find company website" and half the top results are domain REGISTRATION tools. Buying a new domain and finding an existing one are different jobs. If a tool asks whether your domain is "available," you're in the wrong aisle.
Manual routes cap out around 30-50 rows. Past that, you want the lookup running inside the sheet. Here’s how.
How Do You Find Company Websites in Google Sheets With the CUFinder Add-On?
Install the add-on, add your API key, pick the name-to-domain service, map your columns, and run your rows. That’s the whole loop. Step by step:
- 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 live.
- Copy your API key. Head to your CUFinder dashboard and copy the API key from there.
- Enter the key in the add-on. Paste it 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 enrichment services. For this job, pick Company Name to Domain, which converts company names into verified website domains.
- Map columns, set the range, run. Set the input column (your company names), the output column (where websites should land), and the row range (rows 2-300, say, to skip the header and cover the list). Then run it.
Two honest expectations. First, ambiguous names exist: when two real companies share a name, a country hint in a neighboring column or a quick human check settles it. Second, some rows come back empty. No database resolves 100% of company names, and an empty cell beats a confident wrong guess every single time.
Because here’s the thing: this column feeds your CRM, your outreach, your reporting. One wrong domain quietly poisons all three.
💡 Pro Tip: Run rows 2-6 as a test batch first. Check the five domains by eye, confirm the columns are mapped right, THEN run rows 2-300. Five test rows cost almost nothing and have saved me from mis-mapped columns more than once.
A Worked Example: 5 Rows, Before and After
Say your sheet looks like this, with company names in column A and an empty column B waiting for websites:
| A | B | |
|---|---|---|
| 1 | Company Name | Website |
| 2 | Hansel Logistics | |
| 3 | Bluepine Software | |
| 4 | Corvid Analytics | |
| 5 | Marlow & Sons | |
| 6 | Tidewater Robotics |
Then I ran the add-on: Company Name to Domain, input column A, output column B, rows 2 to 6. About a minute later, the same sheet looked like this:
| A | B | |
|---|---|---|
| 1 | Company Name | Website |
| 2 | Hansel Logistics | hansellogistics.com |
| 3 | Bluepine Software | bluepinesoftware.com |
| 4 | Corvid Analytics | corvidanalytics.com |
| 5 | Marlow & Sons | marlowandsons.com |
| 6 | Tidewater Robotics | tidewaterrobotics.com |
Happy with the test? Change the range to rows 2-300 and run the real list. If a name can’t be matched confidently, its cell stays blank: no guess, no lookalike junk.
→ 300 company names → one run over coffee → an official website domain column → your sales prospecting list finally has its backbone.
By the way, this is the small-batch version of a bigger workflow. When you need to find company websites in bulk from files rather than sheets, the same name-to-domain logic scales up. And when the direction flips (you have domains and need names), that’s the get company names from domains job, which has its own guide in this folder.
How Do You Find Company Websites in an Excel Sheet?
Export your company-name column to CSV, run it through the Sheets add-on or a bulk enrichment upload, then import the results back. That’s the honest Excel answer: there’s no native Excel version of this add-on, and pretending otherwise wastes your afternoon.
So if you live in Excel, the round-trip looks like this:
- Save the name column as a CSV (or copy-paste it into a Google Sheet).
- Run the name-to-domain service on that column, via the add-on or a file upload to the Enrichment Engine.
- Download or copy the filled column back into your Excel workbook.
People also ask how to get website URLs for a list of companies in Excel. Same answer: the CSV round-trip. One clarification, because the names confuse everyone: Excel’s built-in “Import data from the web” feature pulls data FROM a webpage INTO your sheet. It’s the reverse of what you want here. And if you’re doing bigger cleanup jobs in Excel, the data enrichment in Excel guide and the CSV enrichment walkthrough cover the full file workflow.
What Mistakes Should You Avoid When Finding Company Websites?
The big ones: trusting the first search result, guessing domains, and confusing registration tools with lookup tools. I’ve made half of these personally, so consider this list a scar map.
- Trusting the first Google result. Lookalike domains and resellers rank surprisingly well. Check the snippet, the country, and the brand before you paste. My 2021 wrong-blog proposal came from skipping exactly this.
- Guessing name+”.com” for the whole column. Brand names, legal names, and domains are three different strings. A guessed column looks done and isn’t.
- Confusing WHOIS and availability checks with website finding. ICANN Lookup and registrar searches answer “who registered this domain” and “can I buy it”, not “what is this company’s site.”
- Ignoring the canonical-domain question. Multinationals run regional domains and subsidiary sites. Decide ONE rule (usually the global .com or the HQ-country domain) and apply it to every row.
- Never marking verified rows. Add a “checked on” column. Future you will thank present you when the list resurfaces in six months.
- Enriching the header row. Start at row 2, and always run a five-row test batch first. Basic data quality hygiene, and it’s free.
FAQ: Finding Company Websites in Google Sheets
How can I find a website based on a company name?
Search the name plus “official site,” check its LinkedIn page, or run a name-to-domain lookup. For one company, searching works fine. For a list, run the lookup on the whole column in your sheet.
How do I find the URL of a company?
The company’s URL is its official website domain: find it via search, LinkedIn, or a company URL finder. Cross-check the domain against the brand name and country before you save it.
How do I find a website without knowing the company name?
Start from whatever you DO have, usually an email address. The domain after the @ is often the company website already, and you can find a company website from an email address for a whole column at once.
How do you get website URLs for a list of companies in Excel?
Export the name column as CSV, run a name-to-domain service on it, and import the filled column back. Excel has no native add-in for this job, so the CSV round-trip is the honest route.
Is there a free way to find company websites in bulk?
Manual searching is free, and most enrichment tools, CUFinder included, offer free credits to start. Fully free at scale usually means scraping, which breaks, gets blocked, and produces lookalike junk you then clean by hand.
How do I find out who owns a website?
That’s a WHOIS question, not a website-finding question: check ICANN Lookup. Fair warning: since GDPR, registrant details are usually redacted, so ownership lookups often come back mostly empty.
What website can I use to find company information?
Company registries, LinkedIn, and enrichment databases all show company profiles. If you want that information IN your spreadsheet (industry, size, revenue, socials), that’s a company enrichment job, and it has its own guide here.
It’s Time to Fill That Website Column
You’ve got the full picture now. Manual searching for a handful of rows. The HYPERLINK helper when you’re stuck doing it by hand anyway. And a name-to-domain run for everything past 30 rows: mapped, ranged, spot-checked, done.
Picture it: Monday morning, coffee in hand. You paste in 300 names from the event export, set rows 2-300, hit run, and read your messages while column B fills itself. That’s my actual Monday now. No wrong-company proposals since.
And the website column is just the start. Once the domains are in, the email finder in Google Sheets guide turns that list into reachable people, and the whole data enrichment in Google Sheets hub covers every other column you might need. Tell me in the comments: how many company names are sitting in your sheet without websites right now?
Bad
Okay
Good
Amazing
