On this page
- What column layout should you use?
- What are the four ways to get cards into a sheet?
- How do you import a CSV into Google Sheets?
- How do you import a CSV into Excel without breaking phone numbers?
- How do you keep the sheet clean?
- When should you move from a sheet to a CRM?
- How does SuperBound put cards into Google Sheets?
- Summary
- Sources
Short answer: Capture each card with a scanner that exports CSV (or writes straight to a sheet), use one fixed column layout, import the phone column as text, and add a note, an owner and a status for every row. A sheet with those three columns is a follow-up list. Without them, it is an address book you will not open again.
Excel and Google Sheets are still where many Indian teams keep event contacts, especially before a CRM is in place. Getting cards into a sheet is simple. Getting them in cleanly, so the sheet is still useful a month later, takes a little planning.
What column layout should you use?
Decide the columns before the event and never change their order. A layout that works:
| Column | Example |
|---|---|
| Date met | 2026-11-07 |
| Event | Engineering Expo, Pune |
| First name / Last name | Ravi / Mehta |
| Title | Head of Procurement |
| Company | Northwind Industries |
| Mobile | +91 98200 12345 (stored as text) |
| ravi@example.com | |
| Note | Wants 40 units before Diwali |
| Owner | Neha |
| Status | Followed up / Replied / Meeting / Not now |
What are the four ways to get cards into a sheet?
- Type them in. Fine for ten cards, painful for a hundred, and typing errors in email addresses are common.
- Scan with an app, then export CSV. Most scanner apps and CRMs can export contacts as a CSV file that Excel and Sheets can import.
- Use Google Lens to copy the text. Lens can pull text out of a photo, which you paste into the sheet. It saves typing but you still split the fields by hand.
- Use a tool that writes each card straight into the sheet. The row appears as soon as the card is read, with the note attached. This is the only method that keeps the sheet current during the event.
How do you import a CSV into Google Sheets?
- Open the sheet and choose File, Import.
- Upload the CSV file.
- Pick an import location: a new spreadsheet, a new sheet, or append to the current sheet.
- Choose the separator (usually comma) and import.
Google's help page on importing data sets covers each option. Use append when you add a new event to an existing list, so every event lives in one place.
How do you import a CSV into Excel without breaking phone numbers?
In Excel, use Data, From Text/CSV rather than double-clicking the file. In the preview, set the phone column to Text. Otherwise Excel can drop leading zeros and plus signs, or show long numbers in scientific notation. Microsoft's support page on importing text and CSV files walks through the options.
How do you keep the sheet clean?
- One row per person. Before you add a row, search by mobile number and email. If the person is already there, add the new event to the note instead.
- Freeze the header row and turn on filters, so anyone can sort by event or status.
- Use a dropdown for status so values stay consistent.
- Write the note the same day. "Wants 40 units before Diwali" is worth more than the whole rest of the row.
- Limit who can see it. The sheet holds personal data, so share it only with people who follow up.
When should you move from a sheet to a CRM?
When more than one person follows up from the same list, when you need reminders, or when you want to see every touch with a buyer over months. A sheet is a fine start. Many teams keep the sheet as an export even after they adopt a CRM.
How does SuperBound put cards into Google Sheets?
For teams, SuperBound can save every card you send on WhatsApp straight into a Google Sheet, HubSpot or Salesforce, with the event and your note. The follow-up draft comes back in the same chat, and you send it from your own WhatsApp or email. See SuperBound for teams and the guide to card scanners for CRM.
Summary
- Fix your column layout before the event, with note, owner and status columns.
- Scan with a tool that exports CSV, or one that writes straight into the sheet.
- Import phone numbers as text so Excel does not change them.
- De-duplicate by mobile and email, and add the note the same day.
Sources
- Google Docs Editors Help: Import data sets and spreadsheets
- Microsoft Support: Import or export text (.txt or .csv) files
- Google Lens
- MeitY: The Digital Personal Data Protection Act, 2023 (PDF)
Frequently asked questions
How do I scan business cards into Excel?
Scan the cards with an app or tool that can export a CSV file, then open Excel and use Data, From Text/CSV to import it. Check that phone numbers are imported as text, or Excel may drop the leading zero or the plus sign.
How do I get business cards into Google Sheets?
Export the scanned contacts as a CSV file, then in Google Sheets choose File, Import, upload the file and pick whether to create a new sheet or append to the current one. Some tools can also write each new card straight into a sheet.
What columns should a business card spreadsheet have?
At least: date met, event, first name, last name, title, company, mobile, email, website, city, note, owner and follow-up status. The note and status columns are what turn a list into a follow-up tool.
Why do phone numbers break in Excel?
Excel treats a number like 09820012345 as a number and drops the leading zero, and long numbers can turn into scientific notation. Import the phone column as text, or store numbers in +91 format as text.