How to Convert From Excel Into VCF Cards

Save

Microsoft Excel is used for the construction of spreadsheets. This application can hold a tremendous amount of information, such as long lists of contacts with details, like phone number, email address, physical address, fax number and website URL. A vCard, or Virtual Information Card, is a virtual form of a business card. It stores contact information for businesses or people, and it's used with Microsoft Outlook, which allows the user to import information from an Excel file.

Things You'll Need

  • Microsoft Excel
  • Microsoft Outlook
  • Open the Excel spreadsheet holding all the contact information you want to convert by locating and double-clicking the desired file where you have it saved on your computer.

  • Format the spreadsheet into fields similar to those in Microsoft Outlook. Change or add fields to include at least the following: first name, last name, email address and phone number. Add as many fields as you need.

  • Save the file by clicking "File," then "Save As" in the upper left-hand corner. Make sure to save the file as a CSV file (comma delimited) and close the file.

  • Open Microsoft Outlook by double-clicking the icon on your desktop or by clicking "Start," and typing "Microsoft Outlook" in the search bar.

  • Click "Contacts" on the left-hand bottom corner of Microsoft Outlook. If you want to create a new folder for the new contacts you will be adding, right-click on "Contacts" and then click on "New Folder." Name the folder and press the "Enter" key.

  • Click "File" on the upper left-hand corner, click "Open," and then "Import." If you have Microsoft Office 2003, just click "File" from the menu and then click "Import and Export." A new window will pop up. Click "Import from another program or file," "Next," then "Comma Separated Values (Windows)" and click "Next" again.

  • Click "Browse" and search for your CSV file that you saved in Step 3; when you find it, click "Open" and then "Next."

  • Select "Contacts," or the new contacts folder that you saved, and click "Next." Click and check the option that states "Import 'your.csv file' into folder: Contacts" and then click on "Map Custom Fields."

  • Drag the values from the source file on the left and drop them in the appropriate destination field on the right. For example, the "Name" from the source file should be dragged to the "Name" of the new Outlook file. After you are done dragging, click "OK."

  • Click "Finish" and your contacts will be imported to Microsoft Outlook as VCF Cards.

References

  • Photo Credit Photos.com/Photos.com/Getty Images
Promoted By Zergnet

Comments

Resources

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!