SHARE-ME GUIDE

Designing Fields and Input Rules for Managing Business Cards in Excel

Share-Me | Published October 29, 2026

When managing business cards in Excel, it is easier to determine where to make updates if you separate "contact details," "records of meetings," and "next steps" from the start, rather than simply adding columns. This design prevents you from re-entering a phone number every time you meet the same person or overwriting notes from a previous conversation.

This article provides a field dictionary and a blank template you can copy and use to get started with individual or small-team management. All examples are fictional. Since screen displays vary depending on the version of Excel, please check the official help documentation when performing operations.

Start Business Card Management with Three Sheets: Contacts, Interactions, and Next Steps

• Contacts:Manage who to contact. As a general rule, assign one contact ID to each person and record their current affiliation and contact details.
• Interactions:Record what was discussed, where, and when, with one row per interaction. If you meet the same person again, add a new row instead of deleting the previous one.
• Next Steps:Record who will do what and by when, with one row per action. Keep completed rows by changing their status.

The common field across all three sheets is the contact ID. Since names alone can make it difficult to distinguish between people with the same name or different spellings, assign a management code such as C0001. This design does not automatically link the sheets. Start by using the ID to match contacts.

For example, if you met the same person at an October trade show and an November meeting, there would be one contact row and two interaction rows. If "sending materials" and "answering questions" were separate commitments, you would also split the next steps into two rows. For recording conversations, also refer to the template for conversation notes after exchanging business cards.

Field Dictionary: Define the Meaning of Columns and How to Handle Blank Fields

Contact Sheet Fields

• Contact ID:Required, text. As a general rule, do not change it after creation, and do not use the row number as a substitute for the ID.
• Name, Company, Department/Title:Enter the information as it appears on the business card. The name is required, and do not fill in unknown departments based on assumptions.
• Email, Phone:Text. Record whether the phone number is for the main office or a direct line in the "Contact Notes."
• Verification Date, Verification Basis:Record when and on what basis—such as a paper business card or direct contact with the person—the information was verified.
• Verification Status:Choose from "Unverified," "Verified Against Original," and "Awaiting Confirmation from Person." "Verified Against Original" does not guarantee that the information is still current.
• Contact Notes:Record only necessary contact-related information. Do not include personal assumptions or unnecessary personal information.

Interaction Sheet Fields

• Interaction ID, Contact ID:Text strings that identify the record and the person.
• Interaction Date, Setting:The date and the name of the trade show, meeting, or other event. If the date is unknown, do not guess; leave it blank and write the reason in the notes.
• Discussion Topics, Agreements:Separate the person's statements from your own interpretation, and clearly state "No agreement" if no commitment was made.
• Recorder:The name of the person who can be contacted later for confirmation.

Next Steps Sheet Fields

• Action ID, Contact ID, Interaction ID:Link the action to the interaction that prompted it.
• Assignee, Task, Deadline:Write specific tasks such as "Send requested specifications" rather than just "Follow up." If a deadline has not been agreed upon, do not mark it as agreed.
• Status, Completion Date:Statuses are "Not Started," "In Progress," "Awaiting Response," "Completed," and "Canceled." Enter the actual date in the completion date field.

Blank Template You Can Copy

Create a new workbook with "Contacts," "Interactions," and "Next Steps" sheets, and paste the header row for each section into cell A1. Separate the fields with tabs, and start the data rows with blank cells. If the fields are in a single cell, specify the tab at the separator or split the headers into separate columns. The following is text for design purposes and is not an Excel file with pre-configured data validation or formulas.

Contacts

Contact ID	Name	Company	Department/Title	Email	Phone	Verification Date	Verification Basis	Verification Status	Contact Notes

Interactions

Interaction ID	Contact ID	Interaction Date	Setting	Discussion Topics	Agreements	Recorder

Next Steps

Action ID	Contact ID	Interaction ID	Assignee	Task	Deadline	Status	Completion Date

First, test the entry and matching process with one fictional person, and feel free to remove any unnecessary columns. However, if you use color alone to indicate the verification status or assignee, the meaning will be lost if the color is removed. Keep the text values as well.

Three Things to Set Before Entering Data

1. Set Phone Numbers and IDs as Text

Phone numbers are not numerical values for calculations. Before entering data, set the display format of the phone and ID columns to "Text." For the fictional format "0312345678," also check the original to ensure the leading zero and international number format, including the "+", are correct. Once a leading zero has disappeared, simply changing the format to text later will not restore it. Check the original business card and re-enter the information. For details, see Microsoft's method for preserving leading zeros.

2. Convert Headers and Data into a Table

Select the headers and data range on each sheet, then use "Format as Table." Confirm that the range and top row headers are correctly specified. For details, see Microsoft's steps for creating a table. Do not insert title rows or summary notes in the middle of the table, and treat each row as a single record.

3. Use Drop-Down Menus for Statuses

Set the "List" option in Data Validation for the verification status and action status. This prevents team members from writing "Finished," "Done," and "Completed" differently. Consider using a date validation for the date columns, and test the settings by entering both correct and incorrect values. For instructions, see Microsoft's Data Validation.

Data Entry Rules and Verifying Contact Accuracy Are Separate Tasks

Even if you can enter data in the specified format, it does not mean the phone number will connect you to the person. Simply because an email address contains an "@" symbol does not mean the recipient exists or that you have permission to send it. Separate the verification of the original, the current affiliation, and the purpose of the contact.

• □ Verified that the name and company match.
• □ Compared the phone number's leading zero and the email spelling with the original.
• □ The contact IDs in the interaction and next steps rows correspond to existing rows.
• □ Can identify rows without a deadline or assignee.
• □ Can confirm before sending whether the person does not wish to be contacted or the reason for cancellation.

Do not delete duplicates based on the same name alone; instead, match them using the procedure for checking duplicate business cards. Also, determine the storage location and person responsible for updating the shared workbook, and avoid making unlimited copies. You can also use the business card management rules to standardize notation and updates.

With Share-Me, Importing and Searching for Paper Business Cards Are Also Options

The official Share-Me guide explains how to digitize and save paper business cards using AI scanning, and how to search by name, company, phone number, email address, and other criteria. You can consider how to import paper business cards along with the design for manual data entry.

This article does not provide instructions for the template or Share-Me's automatic synchronization and CSV import/export. After scanning, check the content against the original. See the Share-Me Features and How-To Guide.

Reference information verified on October 29, 2026. The template is a management proposal unique to this article.