Data Import & Export

How to Scan Business Cards into Excel using OCR

Algirdas Jasaitis Sep 28, 2026 869 views

Question details

The user wants to digitize business cards and extract the text directly into an Excel spreadsheet using Optical Character Recognition (OCR) technology.

How to Scan Business Cards into Excel using OCR

Product: Microsoft Excel
Device & OS: not provided
Scenario: Digitizing contact information from printed business cards into a structured spreadsheet format.
Observed behavior: The user needs to convert images of business cards into editable Excel data without manual typing.

Before you start

Ensure you have a clear, well-lit photograph or scan of the business card and an active internet connection if you are using cloud-based OCR features.

Solution 1Recommended

Use the Excel Data from Picture Feature

Excel's built-in Data from Picture tool is the fastest way to extract text from an image directly into your spreadsheet.

This built-in feature uses Microsoft's online OCR service to analyze images and convert them into editable spreadsheet cells. It works best with high-contrast images.

Capture the Image

Take a clear picture of the business card and save the image file to your computer.

Insert Data from Picture

Open Excel, navigate to the 'Data' tab on the top ribbon, select 'From Picture', and then choose 'Picture from File'.

Review and Insert

Wait for Excel to analyze the image. A sidebar will appear allowing you to review the extracted text, correct any OCR mistakes, and click 'Insert Data' to add it to your sheet.

Feature Availability: The Data from Picture feature is available in newer versions of Excel and Microsoft 365.

Solution 2

Use Microsoft Lens App

Use a mobile scanning app to capture the business card and extract text using OCR, then transfer it to your spreadsheet.

Try WPS Spreadsheet

Easily Extract Text from Images with WPS Spreadsheet

WPS Office offers a powerful built-in 'Picture to Text' (OCR) feature that allows you to seamlessly convert business card images into editable spreadsheet data without relying on external scanning applications.

1. Insert Picture: Open WPS Spreadsheet, go to the 'Insert' tab on the ribbon, click 'Picture', and upload the photo of your business card.
2. Extract Text: Select the inserted image, navigate to the 'Picture Tools' tab, and click on 'Picture to Text' (OCR).
3. Save as Data: Review the extracted contact information in the dialog box and convert it directly into your spreadsheet cells.

Built-in Picture to Text OCR tool for instant data extractionHighly compatible with Microsoft Excel (.xlsx) formatsFree and lightweight alternative for everyday office tasksCross-platform availability on Windows, Mac, iOS, and Android

microsoft office alternative - wps office

Frequently Asked Questions

Why is the OCR text from my business card scan inaccurate?

Inaccurate OCR results are usually caused by poor lighting, blurry photos, slanted angles, or highly stylized fonts on the card design. Ensure the business card is placed on a flat, contrasting background and photographed clearly in a well-lit environment.

Can I scan multiple business cards into Excel at once?

Most built-in spreadsheet OCR features process one image at a time. For batch processing, you may need a dedicated third-party business card scanner app that exports a consolidated CSV file, which can then be imported into Excel.

Is the Data from Picture feature available in all Excel versions?

No, the Data from Picture feature is primarily available in Microsoft 365 subscriptions and newer versions of Excel for Windows and Mac. Older versions may require third-party OCR tools or mobile scanning apps to bridge the gap.

Excel & Data Problems