How to Scan Business Cards to Excel Without a Data Cleanup Mess

You got home from the conference with a fistful of cards and a few scribbled notes on the backs. Here's the honest answer: for a handful of cards, copy the text with your phone and type it into columns yourself. For a real stack, use a scanner that writes contact fields straight into a CSV or Excel file. Either way, a filled spreadsheet isn't a finished one until each row agrees with the paper card it came from.

If you're planning a bigger system for paper and digital contacts together, start with our guide to organizing business cards digitally. This piece covers the narrower job of getting paper cards into one clean Excel sheet.

Pick the route that matches your pile

Three routes cover almost everyone, and the deciding factor is how many cards you have and where they need to end up.

A few cards, and you don't mind placing text yourself. On a supported iPhone, Live Text can read a saved photo of a card. Open the photo, tap Detect Text, touch and hold the text, drag the grab points over what you want, and choose Copy Text, according to Apple's iPhone guide. Live Text depends on your language and region, and the setting lives under Settings > General > Language & Region, so check there first if the Detect Text button never shows up. You paste each piece into a column by hand, which suits a small handful and gets tedious as the pile grows.

A real stack, or a pile you'll keep refilling. Use a scanner that outputs contact fields directly. ScanCardPro describes camera capture with Google Sheets or CSV output for Excel, one row per contact. Parseur says its converter returns Excel, CSV or JSON files with name, company, title, phone and email. CamCard Business is a third option with a documented path, covered below. These are vendor descriptions of what the tools do, not tested results, so run a few cards through one before you commit the whole pile.

You only want these people saved as contacts. Then skip the spreadsheet. On Android, Google Photos can open Lens on a saved card photo, and Google says its business card action saves the phone number or address to a contact. That gives you a contact, not a sheet. If a contact is all you need, our guide to scanning a card into Google Contacts is the shorter road. If you later want a file anyway, select the contacts in desktop Google Contacts, choose More actions > Export, pick Google CSV, and click Export, per Google's export steps.

A LinkedIn QR code on a card is a dead end for this job: LinkedIn's in-app scanner opens the member's profile, not a spreadsheet row. If what you already have is a contact file rather than paper, see turning a VCF file into Excel.

Capture each card once, in good light

Glare, shadows and angled photos create cleanup work later. Wondershare's vendor guide warns that glossy cards cause OCR errors under direct overhead light. Keep the card flat and aligned, and for small batches use one card per image. If an image looks unclear, retake it before you rely on its fields.

If you use CamCard Business, its user guide gives the sequence:

1. Open the app and go to the Company CardHolder page.
2. Tap Capture Card at the bottom.
3. Make the card fill the frame in good light. The app focuses and captures on its own.
4. If the image looks off, tap Retake in the lower left.
5. If the back has a handwritten note or a second language, tap Add Backside in the upper right.
6. Tap Next to keep scanning, or Done to save the card.

Give every card one row, and add the context

Set up your columns before you import anything. One row per card works best, with name, title, company, phone, email, notes and source event. ScanCardPro's column map splits a card into Name, Title, Company, Email, Phone, Website and Social, which is a sensible starting point if your tool lets you choose.

Notes and source event are the columns that make the list useful in a week. ExpoSnap's guide suggests recording the event, the conversation topic, what the person asked for, or the agreed next step. Type "Austin trade show, wants pricing by Friday" while the conversation is still fresh, because a name and email with no context is just a stranger in a spreadsheet.

Open the CSV so phone numbers survive

Here's the quiet failure. You export, double-click the file, and Excel helpfully strips the leading zero from a phone number or turns a long digit string into scientific notation. Microsoft documents both problems in its guide to keeping leading zeros and large numbers. Formatting the column afterward won't bring back a zero that's already gone, so import the file the right way from the start. In desktop Excel:

1. Open a blank workbook and choose Data > From Text/CSV.
2. Pick your exported file and look at the preview. This is also where you can change the delimiter if the columns look jammed together, per Microsoft's import guide.
3. Choose Transform Data (Microsoft's steps call this Edit) to open the editor.
4. Click the Phone column header, then choose Home > Transform > Data Type > Text.
5. When asked, select Replace Current.
6. Choose Close & Load.

Menu names can shift a little between Excel versions, and these steps are for desktop Excel. If you used CamCard Business instead, its export goes through the PC website: sign in at b.camcard.com, open Toolbox, choose Export to Excel, then Export Business Card Holder to Excel, and pick Open to view or Save to keep it. The guide says export is PC only, and exporting a company card holder needs a super administrator or someone they've authorized. If that button isn't there, ask your administrator for permission. If access stays blocked, keep the card photos and use another supported scanner route, or type the fields into a simple spreadsheet template.

Check every row against the paper card

With the data safely in the sheet, this is the step that decides whether you can trust it. A scan can look complete and still be wrong in one character. In a 2019 Computerworld test, reviewer Howard Wen found an out-of-focus ABBYY capture read a 5 in an office address as an S, and he noted omissions and language-related errors in the other apps too. That was one test of older apps, so don't read it as a verdict on any scanner today. Read it as a reminder that a filled cell isn't a verified cell.

Compare the things you'll act on: the person's name, company, email, phone number, and any address you need for follow-up. Wondershare singles out its OCR checklist of email addresses, phone numbers, country codes, unusual name spellings and company suffixes like Ltd., GmbH or LLC, because one wrong character in an email makes the contact unusable. If a field looks doubtful, retake the capture or fix it by hand, and keep the card image or the original card until the sheet is done.

Know what a free scanner actually costs

If you'll scan cards after every event, compare current terms before you build a habit around a tool. These were what the vendors' own pages showed on October 16, 2026, so confirm them before you pay.

Parseur's conversion page says card images are "not stored after extraction," while its pricing page lists 90 day retention for free plans. Those two statements may describe different things, so if your cards carry sensitive details, ask Parseur what is kept and for how long before uploading them.

Remove duplicates last, and keep a raw copy

You may meet the same person twice, say once at the booth and once at the dinner. Resist deleting on sight. First copy the raw import to its own worksheet, because Microsoft warns that Remove Duplicates permanently deletes the matching rows.

Then look before you cut. Select the cells you want to check, choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values, pick a style, and click OK. Scan the highlighted rows yourself. Excel finds exact matches in the cells you select, but it can't tell you whether "Dana Ruiz" and "D. Ruiz" are one person.

When you're sure, select your data, choose Data > Remove Duplicates, and tick only the columns that truly identify a person, usually email, or name plus company. Leave notes and source event unticked, or two different conversations with the same contact will look like different people. Click OK, and keep the raw sheet until the follow-ups are done.