Leads in Google Sheets or Excel when a spreadsheet stops working
A spreadsheet is a fine first lead list. It stops working when more people, more files and more history arrive. Here are the signs, and what to do next.
- No credits, no data tax
- You own your data
- Map included
- GDPR-first
Every lead list starts as a spreadsheet
A Google Sheets lead list or an Excel file is where most small teams begin, and that is a good start. It is free, everyone knows how it works and you can add a column whenever you need one.
The trouble comes later. A second file appears with overlap, a colleague sorts the sheet and the notes no longer match the rows, and nobody can say who was emailed last month. At that point the spreadsheet is no longer the list; it is one of several versions of it.
Moving on does not mean throwing the spreadsheet away. Download it as CSV or keep it as an Excel file, and import it: columns are matched, duplicates flagged and the original file stays attached to the import. Riftjaw has no Google Sheets connection; the file is the route.
Spreadsheet or lead database: where each one fits
The spreadsheet does not have to go. Many teams keep using it to collect, and import the new rows into the lead database every week.
| Situation | A spreadsheet | A lead database |
|---|---|---|
| One person, one list | Works well | More than you need yet |
| Several files with overlap | Duplicates are easy to miss | Duplicates flagged at import |
| Who was emailed when | A column someone has to keep up | Every email visible on the company record |
| Where a company came from | Often lost after copy and paste | Source file and date kept per record |
| A group to email next | A filter you set again each time | A saved filter or segment |
Signs your spreadsheet has stopped working
There are several versions
When the team asks which file is the right one, the list has split. One import brings the versions back together.
Companies get emailed twice
Overlap between files leads to double messages. See duplicate contacts for how that happens.
The history lives in people's heads
If nobody can see who replied or when, the next message starts from zero.
Unsubscribes are hard to keep
A row deleted in one copy may still be in another. A database skips unsubscribes in every later campaign.
Before you move a Google Sheets lead list
- Download each sheet as CSV or Excel.
- Make sure the first row holds the column names.
- Keep one company per row.
- Add a column for the source if you know it.
- Keep the original file as your own copy.
Frequently asked questions
Is Google Sheets good enough for a lead list?
For one person and one list, yes. Once several people and files are involved, duplicates, lost notes and unclear history make a spreadsheet hard to trust.
Does Riftjaw connect to Google Sheets?
No, there is no Google Sheets connection. Download the sheet as CSV or Excel and import that file; the columns are matched and duplicates are flagged.
Can I keep using my spreadsheet next to a lead database?
Yes. Many teams collect new companies in a sheet and import the new rows regularly. Duplicates against the database are flagged at every import.
What happens to my spreadsheet columns when I import?
Each column is matched to a field such as company name, website or email. Columns that do not match can become your own fields, so nothing has to be thrown away.
Do I need credits?
No. There are no credits and no data tax: enrichment runs automatically without a per-row meter.
What is Riftjaw?
Riftjaw is a self-hosted B2B lead pipeline: collect companies from any public list, enrich them for free, put them on the map and reach them - from one dashboard you host yourself.
Bring your spreadsheet into one list
Import your Google Sheets or Excel lead list, keep the source of every row and stop emailing companies twice. Start free, without a credit card.
Start free