TL;DR
- Photograph a whole stack of cards, then export straight to Google Sheets as structured rows.
- Decide your column schema first: name, title, company, email, phone, event, date scanned.
- Keep one row per lead and dedupe on email so lists stay clean.
- OCR struggles with foil, glossy, and low-contrast cards, so shoot flat and well lit.
- A business card holds personal data, so log a lawful basis before you export.
Why does a business card scanner for Google Sheets beat manual typing?
Manual typing is slow and error prone, and it delays follow-up by days. A business card scanner for Google Sheets extracts every field, then drops clean rows into a sheet you share. Your team sees new leads the same day, not next week. Speed is the point.
Research on sales response shows firms that respond too slowly lose qualified leads to faster competitors. A shared sheet closes that gap. New leads appear where sales already works, minutes after the booth closes.
What columns should your lead spreadsheet use?
Pick your columns before the first import, then never change the order. A reliable lead sheet uses name, job title, company, email, phone, event, and date scanned. Consistent columns mean every card fills the same blanks. That structure is what lets you sort, filter, and dedupe later without breaking formulas.
Google's own guidance on importing a CSV explains choosing the separator so fields split into the right columns. Set it to comma, keep the header row, and your export lands clean the first time.
How do you scan a whole stack into one sheet?
You do not scan cards one at a time. Lay the stack out flat, non-overlapping, under even light. Photograph 20 or more cards in a single shot. Review the extracted fields, then export the batch to your connected Google Sheet. The whole stack lands as clean rows in minutes.
- Group the cards by event so the sheet stays attributable.
- Lay them flat on a dark, matte surface with no overlap.
- Shoot in bright, even light to avoid glare on glossy cards.
- Capture 20-plus cards per photo, then check each extracted field.
- Export the batch to Google Sheets, or to HubSpot or Slack.
For the full technique, see our guide to scanning multiple business cards at once. The same layout rules keep the batch split accurate.
How do you keep one row per lead and dedupe on email?
Treat email as the unique key for each lead. One person, one row, one email address. After an event, sort the sheet by email, then remove duplicate rows so nobody gets two follow-ups. Google Sheets can flag repeats, but capturing clean data first is what keeps the list honest.
Event grouping helps here too. When leads attach to a single event, your sheet stays attributable, and cost per lead is easy to calculate later against that show.
Where does OCR break on a business card, and how do you avoid messy rows?
OCR is strong on clean, flat cards, but it struggles in specific cases. Foil, glossy, and low-contrast cards lose fields under glare. Handwriting on a card is not reliably extracted. Overlapping cards confuse the batch split before extraction even runs. Shoot flat, matte, and well lit to avoid messy rows.
This is a hard limitation right now, and naming it is fairer than pretending OCR is perfect. Review each row after import, and fix the handful of cards the model reads poorly. Clean capture up front means less cleanup in the sheet.
Should you stop at Google Sheets or push straight to your CRM?
Google Sheets is a great shared inbox for raw leads, but it is not a CRM. Use the sheet to review and dedupe, then push qualified leads into HubSpot so reps can work them. ScanBusinessCard exports to Sheets, HubSpot, and Slack, so you choose the destination per event.
Remember that a scanned card is personal data, so log a lawful basis before you export or email. Compare the routing on our HubSpot scanner comparison, or start free and move to Pro for unlimited scanning and CRM export.
FAQ
Can I scan business cards directly into Google Sheets?
Yes. A business card scanner extracts each field, then exports the row to a connected Google Sheet. With ScanBusinessCard you photograph a stack, review the data, and send the batch to Sheets. You skip manual typing, and the leads land in labeled columns you already share with your team.
Does bulk scanning work for a whole conference stack?
Yes, that is the main use case. Lay 20 or more cards out flat and non-overlapping, then photograph them in one shot. The tool splits the image, extracts each card, and exports the batch. A 200-card stack becomes clean spreadsheet rows in minutes, not an evening of manual typing.
What columns should a business card spreadsheet have?
Use seven columns: name, job title, company, email, phone, event, and date scanned. Set them before your first import, then keep the order fixed. Consistent columns let you sort, filter, and dedupe without breaking formulas. Email is the key column, because it is the one field that is unique per lead.
How do I stop duplicate leads in my sheet?
Dedupe on email. Sort the sheet by the email column so repeats sit next to each other. Remove the extra rows, or let Google Sheets flag duplicate values for you. The cleaner your capture, the less cleanup you do, so scan flat, well-lit cards and review each field.
Is scanning business cards into a spreadsheet GDPR compliant?
Scanning is a tool, not a compliance status. A business card holds personal data, so you need a lawful basis to store and use it. The ICO lists options like consent and legitimate interests. Decide yours before you export, keep the data secure, and let contacts opt out on request.
Sources
- Harvard Business Review, The Short Life of Online Sales Leads
- Google Docs Editors Help, Import and convert existing files
- Information Commissioner's Office, A guide to lawful basis
Stop retyping cards. Photograph the stack and export clean rows to Google Sheets, HubSpot, or Slack. Start free or see Pro plans.