No formula in Google Sheets pulls a company’s funding round. So you enrich instead. Put your company names or domains in one column and run a funding enrichment across the row range. The round, the amount raised, and the investors land in the columns you choose. Manual research answers one company. Enrichment fills a column.
I’m going to be honest with you. In March 2024 I had 340 target accounts and one question from my VP: “which of these just raised?” So I spent a Tuesday in a database’s free tier, hit the view limit before lunch, and ended the day with 41 rows and a spreadsheet I didn’t trust.
Full disclosure before we start: I work at CUFinder, and one of the tools in this guide is ours. That’s why the free routes come first: for six accounts, they’re genuinely enough.
Let’s get into it.
📌 TL;DR: A company funding data column tells you who raised, how much, and from whom. Free routes: SEC EDGAR filings, company newsrooms, news alerts, and university library databases, all one company at a time. GOOGLEFINANCE can't help, because a private round has no ticker. For a whole list: run a funding enrichment on your company column, set the input and output columns, then sort by round.
What Counts as Company Funding Data?
Five things, mostly: the round, the amount raised, the date, the investors, and the stage. A Funding Round is one event where a company sold equity to investors: Seed, Series A, Series B, and up the alphabet. Richer records also carry the valuation and the lead investor’s name.
And that’s all I’m covering here, because I already wrote the field-by-field version. If you want the full breakdown of what company funding data includes and where it comes from, read that one first. This guide is about the spreadsheet.
Why Can’t GOOGLEFINANCE Pull Funding Data?
Because GOOGLEFINANCE returns public market data for listed tickers, not private funding rounds. Different data, different universe. And the mismatch is worth understanding, because thousands of people try this formula every month.
Public markets run on tickers. A listed company has a symbol, a live price, and a feed anyone can query, exactly the job Google’s GOOGLEFINANCE function was built for. Its reference lists what comes back: price, volume, market cap.
A private funding round is a different animal. It isn’t a price. It’s an EVENT: it happens once, gets announced in a press release on some Tuesday morning, and then goes quiet. No symbol. No feed. Nothing for a formula to point at.
So there is no formula. Not a hidden one. And not a clever IMPORTXML trick that survives a real list. A scrape breaks the week the source redesigns its layout.
Which leaves two honest options: research each company by hand, or enrich the column from a funding data source.
🔍 Did You Know? GOOGLEFINANCE only speaks tickers. Google's own function reference lists the market attributes it can return: price, volume, market cap. A private Series B has no ticker at all, so no formula can fetch it.
Where Can You Get Company Funding Data for Free?
SEC filings, company press pages, news alerts, and university library databases, one company at a time. All four are real. All four share the same ceiling.
SEC EDGAR and Form D
A Form D is the short notice a company files with the SEC after selling securities without registering the offering. In plain words: a US company raises private money, then tells the regulator who it is and what it sold. The SEC’s own Form D explainer covers the exemption.
So you can search a company on EDGAR full-text search, open its filings, and find raises that never made the news. Free, official, primary source.
The honest catch? Three of them. SEC EDGAR is US-only. Whether a raise shows up depends on the exemption used, so coverage has gaps. And a Form D is a legal notice: names and dates, not a story.
Press Releases, Newsrooms and News Alerts
Almost every announced round starts life as a company press release. So the newsroom on the company’s own site is often the fastest, most accurate source. No middleman, free.
Set up news alerts on your top 20 accounts and the announcements come to you. Decent early warning for a short watchlist.
But it’s completely unstructured. You get paragraphs, not fields, so somebody still has to type the numbers into a cell. And nobody reads 340 newsrooms on a Tuesday. Ask me how I know.
Library and University Databases
Notice who ranks for funding questions: university library guides. There’s a good reason. Business school libraries license the expensive deal databases. Their research staff also write excellent instructions for using them. Stanford GSB’s research library FAQ on finding funding round and deal data is a fine example.
So if you’re a student, an alum, or a member of a public library with business database access, use it. Best free-to-you data in this guide.
Free Tiers of the Big Databases
Crunchbase and PitchBook are the category leaders, and I won’t pretend otherwise. Their free tiers are real, and for a handful of lookups they work fine.
Then the limits arrive. View caps, export caps, and a ceiling on how many rows you can get OUT, which is where spreadsheet people hit the wall. I’ve written separately about working around export limits on a funding list.
This is my Tuesday, by the way. March 2024, free tier, 340 target accounts: view limit before lunch, 41 rows at close of play.
Here’s the pattern across all four routes. Every one answers “tell me about THIS company.” None of them gives you bulk funding data. None of them fills a column.
So if your list is six accounts, close this tab and go use EDGAR. Seriously. If your list is 340, keep reading.
How Do You Add Funding Data to a Company List in Google Sheets?
Put company names or domains in a column and run a funding enrichment across the range. Second disclosure, right where it counts: the add-on below is CUFinder’s, and CUFinder pays my salary. So judge it against the free routes above, not against my enthusiasm.
If your Prospect List already lives in a sheet, you’re most of the way there. Five steps:
- Install the add-on. Grab the CUFinder add-on from the Google Workspace Marketplace. New to add-ons? Google’s add-ons help page shows how they install and where they turn up.
- 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 funding service. Open the add-on from the Google Sheets menu. It opens as a right panel listing all the enrichment services. Choose the one that adds each company’s latest funding round.
- Map columns, set the range, run. Set the input column (company names or domains), the output column where the funding details land, and the row range (rows 2-341 for my file). Then run it.
Two minutes on input hygiene first. My pre-run checklist:
- One company per row: no two-companies-in-one-cell entries.
- Legal name or a clean domain: “Junco Health,” not “Junco Health, Inc. (formerly Junco Labs).”
- Domains beat names when you have both, because a domain can’t be mistaken for another company.
- Duplicates removed: Sheets does this natively under Data → Data cleanup → Remove duplicates.
And if your list lives in a CSV rather than a sheet, the CSV enrichment guide covers that round-trip instead.
Now the limits, because you deserve those before you spend credits. Coverage is strongest where a round was actually announced (true of every provider, ours included). Bootstrapped and quiet raises come back empty, and an empty cell is the tool being honest rather than inventing a Series A.
Each record is also a snapshot, with an announcement lag baked in. And runs cost credits, so test five rows before committing the whole range. That’s funding data in Google Sheets, start to finish.
A Worked Example: 5 Rows, Before and After
Say your sheet looks like this. Five made-up companies for the demo. Names in column A, domains in column B, and two empty columns waiting:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Company | Domain | Latest Round | Amount Raised |
| 2 | Harbourline Analytics | harbourline.com | ||
| 3 | Pelham Robotics | pelhamrobotics.com | ||
| 4 | Junco Health | juncohealth.com | ||
| 5 | Ardent Freight | ardentfreight.com | ||
| 6 | Wexley Labs | wexleylabs.com |
Then I ran it: the funding service, input column B, output columns C and D, rows 2 to 6. A minute later, the same sheet looked like this:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Company | Domain | Latest Round | Amount Raised |
| 2 | Harbourline Analytics | harbourline.com | Series A | $12M |
| 3 | Pelham Robotics | pelhamrobotics.com | Series B | $34M |
| 4 | Junco Health | juncohealth.com | Seed | $4.2M |
| 5 | Ardent Freight | ardentfreight.com | Series C | $60M |
| 6 | Wexley Labs | wexleylabs.com | Seed | $2.5M |
Those companies and numbers are invented for the example. On a real list, expect a few rows to come back empty too. That’s honest, not broken.
Now the part that actually changes your week. Select the range, open Data → Sort range, and sort by column C or D. Suddenly your “who just raised” shortlist writes itself: the big rounds float to the top, the seed rows settle below. Then add a “checked on” column beside them, because funding data ages the morning after the announcement.
→ 340 companies → one ranged run → sort by round → a shortlist before stand-up.
💡 Pro Tip: Add a "checked on" date column next to the funding column and fill it the day you run the enrichment. In six months, that date is the only thing telling you whether to trust the row.
Funding is one column, though. The wider company enrichment run adds industry, size, and location in the same pass: the firmographic context around each round. And revenue is the sibling money metric worth having beside it. Just don’t blur the two: money raised is not money earned. The company revenue in bulk guide handles that column.
📌 Example: My March 2024 file: 340 accounts, one Tuesday, 41 rows filled by hand, and a spreadsheet I didn't trust. Same file today: one ranged run, sorted by round, shortlist ready before stand-up.
How Do You Use Funding Data Without Sounding Like a Stalker?
Treat a raise as timing, not as a need. A round is a Buying Signal, and a signal only tells you WHEN to reach out. It never tells you the company wants what you sell.
Three caveats I learned the expensive way:
- A raise is not a budget line for YOU. That money arrived with a plan, and the plan was written for investors.
- The first 90 days go to hiring and tooling. So if you sell what a growing team needs, good. If not, your timing is still wrong.
- Big rounds attract every vendor on earth. A $60M Series C means that CRO’s inbox is a war zone by Friday.
So segment by stage before you write a single line. A seed company is two founders and a shared inbox: you’re talking to the CEO, and you’d better be quick and cheap. A growth stage company has a VP of Operations and a procurement process. Two different opening lines, and your Ideal Customer Profile should already say which one you serve.
A round also points at look-alikes. When three of your best-fit accounts raise in one quarter, go find similar companies and enrich that batch next. Reading the lead investor’s portfolio does the same job by hand. Then run one person-level pass: find the buyers who mirror the ones who bought before, so each new account comes with a name to write to.
Then pitch the problem the raise created: 40 new hires, a second region, a new team. Never the raise itself. And if you’d rather run this on a schedule, I mapped the automated version in the funding-triggered outreach API workflow, which pushes signals to your CRM.
What Mistakes Should You Avoid With Funding Data?
The big ones: reading an announcement date as the money-in date, and never refreshing the column. I’ve made most of these personally, so treat the list as a scar map.
- Treating the announcement date as the money-in date. The press release usually lands weeks after the term sheet. So “just raised” might really mean “raised last quarter, told everyone this week.”
- Enriching the header row. Start your range at row 2. Otherwise you’ll spend a credit looking up the funding history of a company called “Company.”
- Mixing currencies in one column. An £8M round and an $8M round are not the same number. So add a currency column, or normalize and say so in the header.
- Assuming silence means no raise. Plenty of rounds are never publicised. An empty cell means “no announced round found,” not “this company has no investors.”
- Never refreshing. A funding column is stale within a quarter. Re-run it quarterly, and keep that “checked on” column so you see which rows are drifting.
- Pitching the raise instead of the problem. “Congrats on the Series B!” is what 60 other emails said that week. Talk about what the money now has to build.
FAQ: Funding Data in Google Sheets
How do I check a company’s funding?
For one company: EDGAR filings, its own newsroom, or a funding database. Those three cover almost every case. For a list, though, playing company funding checker one row at a time stops paying off around row 20. That’s the point where enriching the whole column wins.
Where can I find free company funding data?
EDGAR, company press pages, news alerts, and library database access are the four free routes. All of them are useful, and all of them answer one company at a time. So the free routes cost you time rather than credits.
Can Google Sheets pull funding data automatically?
No built-in formula does it. GOOGLEFINANCE covers public market tickers only, so private rounds sit outside its reach entirely. An add-on running inside the sheet, or an import from a funding data source, is the practical route.
How do I see the investors in a company?
Announcements and filings name them. A round announcement usually lists the lead investor plus the participants, and Form D filings name related persons. For a whole list, an enrichment run returns the investor names per row, so nobody has to open 300 announcements.
Is there a company funding data Google Sheets template?
Yes, but a template is only headers. The data is the hard part. Four columns are worth having: Company, Latest Round, Amount Raised, and Date Announced. Add your “checked on” date beside them and you’ve built the template yourself.
How do I track startups that just raised?
Two ways: a refreshed funding column with a sort, or alerts. A quarterly enrichment run plus Data → Sort range gives you a working startup funding tracker. News alerts catch the rest, though they only watch companies you already know.
How fresh is company funding data?
It’s as fresh as the announcement behind it. Every provider, ours included, depends on public announcements and filings, so assume a lag of days or weeks. Refresh quarterly, date-stamp the column, and you’ll know how old each row is.
Can I get funding data for private companies outside the US?
Yes, but coverage thins outside the US. EDGAR is US-only, and announcement coverage is denser in North America and Western Europe than elsewhere. That applies to every provider, ours included. So test a sample from YOUR region first.
It’s Time to Fill That Funding Column
You’ve got the honest routes to company funding data now. EDGAR and Form D for filings. Newsrooms and alerts for the accounts you already watch. Library databases if you have access. And past 25 rows, one enrichment run inside the sheet.
Picture that 340-row file on a Monday morning, sorted by round. The Series B rows at the top, a “checked on” date beside each one, and a shortlist you can hand to sales before the coffee’s cold. That’s the March 2024 I wish I’d had.
Funding is only one column, though. The whole data enrichment in Google Sheets hub covers what to add next: industry, revenue, headcount, tech stacks. Tell me in the comments: how many rows are you staring at right now, and how many just raised?
Bad
Okay
Good
Amazing
