How can I transfer company contacts from Excel to Outlook or Gmail?

Hi @Kai henderson

Thank you for posting your question in the Microsoft Q&A forum. 

I have a document will help you.

Please follow the instructions in the article below.

Import contacts from an Excel spreadsheet to classic Outlook - Microsoft Support

Basically, you need to save your Excel file as .csv (comma separated value) and import it in Outlook Classic.

Finally, map your CSV file columns to Outlook contact fields.

I hope this information helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

If you know how, moving workplace contacts from Excel to Outlook or Gmail can be easy. Outlook and Gmail cannot handle Excel files (such .xlsx or .xls) for importing contacts directly. They will only take CSV or VCF (vCard) files. So, the first thing you need to do is have your Excel contact list ready and then convert it into the correct format.

Step-by-step process to transfer Excel contacts to Outlook or Gmail- Prepare your Excel file

• Check that the data in your Excel file is clean.

• Use the right column titles, such as First Name, Last Name, Email Address, Phone Number, Company Name, and so on.

• Get rid of any empty rows or cells that have been merged.

Convert Excel to vCard (VCF)

You can quickly import many contacts into both Outlook and Gmail using the vCard (VCF) format. But you are unable to convert Excel files into VCF files directly. You will need an advanced conversion tool to perform this.

Using an easy application like TrustVare Contacts Manager is one quick approach to convert your Excel file into a vCard. It helps you migrate all of your contacts from Excel to VCF format without losing any data. This includes names, phone numbers, emails, and company names.

Add the vCard file to Outlook

• Open Outlook.

• Click on File, then Open & Export, and then Import/Export.

• Select Import a vCard file (.vcf).

• Find the VCF file you converted and click Open.

Your Outlook address book will now have new contacts.

Add the vCard file to Gmail

• Click on the Google Apps button in Gmail and then on Contacts.

• Click Import on the left.

• Click Import after uploading your vCard file.

• All of your contacts from Excel are now in Google Contacts.

Benefits of using the Excel to vCard Converter-

• Works with all Excel file types, including .xls, .xlsx, and .csv

• In just a few clicks, it transforms Excel to VCF

• Helps you map fields like Name, Phone, Email, and Company accurately

• Protects the structure of your data while it is being converted

• Can import to any platform, such as Gmail, iPhone, Android, Outlook, and iCloud.

• Simple switching of both individual and bulk contacts

• Works with all versions of Windows.

This strategy saves you time and eliminates errors that can happen when you do things manually, especially if you have a lot of company contacts. You don't have to worry about complex manual mapping or format problems. Just convert the Excel file to vCard format, and then you can easily import it into Gmail or Outlook.

This technique works well and reliably whether you are migrating your corporate contacts to a new Outlook account or syncing your business address book with Gmail.