Categories
Building-Furniture

How to add contacts to gmail using a csv file

Storing all of your contacts in your Gmail account is helpful when you get a new smartphone and want to quickly have access to your contacts on that device. It also makes it much simpler to find email addresses and phone numbers in Gmail when you need them.

But the process of adding new contacts one by one can be tedious through a Web browser or on your phone, so you might be looking for a way to add a lot of contacts at once by importing them to your Gmail account in bulk via a file upload. Fortunately this is something that you are able to do, so continue reading our tutorial below and find out how to import contacts to Gmail via a CSV file.

How to Add Contacts to Gmail With a CSV File

The steps in this article were performed using Microsoft Excel. The general process of importing contacts to Gmail through a CSV file will have you download the CSV template from your Gmail account, open that file in Excel so that you can add data, then you save the file and upload it back to Gmail.

A couple of important things to note about importing contacts to Gmail with a CSV file:

  • While we use Excel in the example below, you can also use any other application that can open and edit CSV files, like Google Sheets.
  • This process is going to export all of your existing contacts from Gmail, then you can add new contacts to the list.
  • This is going to result in duplicate contacts in your Gmail account, but you will have the ability to find and merge duplicates after you import the file back to your account. Alternatively you can delete all of the contacts from the exported file and only import new contacts. Just be sure to leave the column headings in row 1 intact.
  • You don’t need to fill in all of the information for new contacts that you add. For example, I only fill in a name file, email address and telephone number in my example below.

Step 1: Go to your Google contacts at https://contacts.google.com. If you aren’t already signed into the Gmail account to which you wish to upload contacts via CSV, then you will be prompted to sign in.

Step 2: Click the More option in the column at the left side of the window.

How to add contacts to gmail using a csv file

Step 3: Choose the Export option.

How to add contacts to gmail using a csv file

Step 4: Confirm that your contacts and the Google CSV options are selected, then click the Export button to download the file.

How to add contacts to gmail using a csv file

Step 5: Open the exported file in Excel, or whatever spreadsheet application that you wish. For example, you could also choose to open and edit this file in Google Sheets.

Step 6: Scroll to the bottom of the list of existing contacts, then begin adding new contacts either by typing them manually or by copying and pasting values from another existing sheet. Note that there may be a very high number of columns in this spreadsheet and that important fields like “E-mail Value 1” and “Phone 1 – Value” might require you to scroll pretty far. For example, these fields were columns AE and AG, respectively, in my exported CSV file. I have hidden a few columns in the image below so you can see what the important ones are labeled as and where they are located.

How to add contacts to gmail using a csv file

Step 7: Click the File tab at the top-left corner of the window.

How to add contacts to gmail using a csv file

Step 8: Select the Save option.

How to add contacts to gmail using a csv file

Step 9: Click the Yes button to confirm that some features may not be compatible with the CSV file format.

How to add contacts to gmail using a csv file

Step 10: Go back to your Google Contacts tab in your browser and click the Import option in the column at the left side of the window.

How to add contacts to gmail using a csv file

Step 11: Select the CSV or vCard file option.

How to add contacts to gmail using a csv file

Step 12: Click the Select File button.

How to add contacts to gmail using a csv file

Step 13: Browse to the CSV file on your computer, select it, then click the Open button.

How to add contacts to gmail using a csv file

Step 14: Click the Import button to import your CSV file contacts to your Google account.

How to add contacts to gmail using a csv file

Step 15: Click the Find Duplicates button at the top of the window.

How to add contacts to gmail using a csv file

Step 16: Select the Merge All option to combine any duplicate contacts that were created by this import.

How to add contacts to gmail using a csv file

If you are adding contacts from a number of different CSV files that are all in the same format, then you might be able to save some time by merging all of those csv files into one.

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.

This post will teach you the best method to import contacts from csv to Gmail account using both the browser or the Gmail app.

If you have a csv contact file which you want to send to a person through the Gmail account, you’re at the right place cause I will teach you how to do that.

So let’s proceed on how to import contacts from csv to Gmail.

Best way import contacts from csv to Gmail

There are two methods I’m using for this method on how to import contacts from csv to Gmail, that is using the browser and the Gmail mobile app.

1. import contacts from csv to Gmail app

If you don’t have the csv contact file on your phone, this is how to create one and after words import it to your Gmail.

To create a csv contact file on android phone, kindly go to the contact app on your phone. Tap on the menu icon to open options for you to select.

You’ll see where it states manage contacts, kindly tap on the button. On the next page, you’ll see where it is import and export contacts just like on the picture below.

How to add contacts to gmail using a csv file

Tap on the import or export contacts to open the next page. As we’re focused on import contacts from csv to Gmail and to get a csv file, kindly tap on the export file on the next window.

On the next screen, select the location where the contacts are saved or stored. It can be your sim card, phone, internal storage or your SD card.

After you done so, you’ll see the number of contacts which will be exported.

This post is about import contacts from csv to Gmail and to create an csv contact file, kindly select internal storage or sd card to export the contact. Immediately you have done that, you’ll see that it saved the contact to your SD card or internal storage as an csv contact file.

Now we’re back to the topic of the post how to import contacts from csv to Gmail.

Kindly open the Gmail app on your android phone or iPhone. Click on the three horizontal line menu icon located at the top left corner of your screen.

Scroll down and you’ll see contacts.

Tap on the contacts and it will show you that your contact is empty and mind you it will redirect you to your contact app.

On your contact app, click on the three horizontal line menu icon and on the next screen click the settings icon.

Scroll down and you see import on the options that will be displayed to you. Click on import and select csv file by tapping on the box.

On the next option, select your device and it will display all the csv contact files on your phone. Go ahead and select the csv contact file and immediately it will be imported to your Gmail account.

This is how to import contacts from csv to Gmail app, and as you can see it is not easy at all and wouldn’t take up to five minutes and you’re done with everything.

2. Import csv contacts to Gmail on browser

How to add contacts to gmail using a csv file

NNow you have the csv file, kindly open the Google Chrome browser on your phone or the computer and login to your google account.

Open the Google Gmail on your computer and sign in if you haven’t done so. On the side of your computer screen, you’ll see import.

Tap on the import to get started with how to import contacts from csv to Gmail using the Google Chrome browser.

As you tap on import and select file, locate where you saved the csv file and tap to select the file. Finally click import and the contacts will be imported into your google gmail account.

This is another method on how to import contacts from csv to Gmail account.

3. Using the contact app for android

Apart from this two methods, there’s another method which you can use to import contacts to your google gmail account. This is possible if you’re using an android phone or tablet.

To import csv contacts to Gmail using this method, open the contact on your android phone and tap to open the contact application on your android phone.

Click on the option menu and select manage contacts by simply tapping on it.

On the next page click on import or export contact, and also tap import on the next window. Now select the internal storage or the SD (where the csv contact file is saved) and you’ll see the all the contacts inside the csv file.

Select all the contacts or your desired contacts and click done.

As we’re talking about how to import contacts from csv to Gmail account, please kindly select your google gmail account on the list of options displayed on your screen.

As you have done so, click the import button and it will import all the contacts straight into your google gmail account.

This is another easiest way to import contacts from csv to Gmail Google account, and this is my preferred best method.

By now I know that you must understood how to import contacts to gmail from csv, and as you can see they are not difficulty to implement.

How do I transfer contacts to a new phone

If you’re using an android phone, you will not encounter this problem if you used your Google gmail account to save contacts on your phone.

If you bought a new phone, you don’t need to transfer or import contacts to your new phone unless if it is contacts saved on your phone or sim.

If you used your Google account to save a contact or contacts on your android phone, all you need to do is to use the same Gmail account which you used on the old phone and use it on your new phone.

Immediately all the contacts will be synchronized and automatically will display on your phone contacts.

I’ve been using this and it is very helpful to me. As I add my Gmail account to the Google play services, all the contacts will show up on my contacts list. No importing, transferring or moving of contacts at all.

All these are same with how to import contacts from csv to Gmail, and as long as it is the Google Gmail account, there’s no difficulty or long process.

Don’t Miss.

I bet you understood all I have said on this tutorial on how to import contacts from csv to Gmail using the Gmail app or the Google Chrome browser. Please don’t forget to share this post using the share buttons.

How to add contacts to gmail using a csv file

Summary: Do you want to export contacts from Gmail to CSV files? If yes, then this guide is for you! There is a simple trick that you can follow to upload Gmail contacts to CSV directly. So, let’s start.

Download Gmail Contacts to CSV Explained

A file with a .csv extension is plain text. It is commonly used by people to import contacts in spreadsheet format. A user can use this spreadsheet with Microsoft Excel or Google spreadsheets. If we talk about organizations, they contain a large volume of data in the CSV file format. Now, the question is how can Gmail users export contacts in CSV file format.

Well, fortunately, Gmail provides a technique to export contacts from Gmail account to a CSV file. One does not need any external installation for the process. The requirement for the process is an active Gmail account.

The next section will let you know the simplest trick to export contacts from Gmail to CSV online.

Follow the Steps to Export contacts from Gmail to CSV file

To upload Gmail contacts to CSV file:

  1. Login Gmail account.
  2. Go to Grid icon and select Contacts
  3. Select Export option from Google contacts.
  4. Check the Google CSV button and Export.
  5. The contacts are getting downloaded.
  6. Open the CSV file to see the final results.

One can also take the help of the Screenshots to accomplish export Google contacts to CSV file process.

How to Make CSV File for Gmail Contacts with the Help of Screenshots

First, you need to login to your active Gmail account by entering login credentials.

Now, go to the grid icon as shown in the screenshot. Then, pick the Contacts from the Google Apps.

Here, select an Export option from the Google contacts.

How to add contacts to gmail using a csv file

Now, you need to pick which contacts you want to export from Gmail to CSV.

How to add contacts to gmail using a csv file

In this step, from the Export as check Google CSV to upload Gmail contacts to CSV.

How to add contacts to gmail using a csv file

Your Gmail contacts are getting downloaded in CSV file. Open the CSV file to check the final results. That’s it.

Now, let’s explore some real benefits of Exporting Google contacts to CSV file format.

How Exporting Google Contacts to CSV makes your Job Easy?

  • Share Contacts: After exporting contacts from Gmail to CSV, users can share contacts with most of the existing applications. Now, you can share the contact information with colleagues, friends, and others easily.
  • Open with Excel: One of the biggest advantages of saving Goggle contacts to CSV is that you can open in on any of the Excel sheets. This way your contacts get managed in a better way. Also, one can edit them according to the requirement.
  • Platform Independent: The CSV file does not need any specific platform to get open. One can open it in a simple text editor to simply read and understand.

Read the Expert Note: If you need to convert contacts from a CSV to multiple formats, this is also possible. Download Contacts CSV Converter Wizard to easily import CSV contacts to PST, vCard, and more. It is a Windows-supportive utility that comes with a consistent interface. The user can convert contacts from CSV to PST without Outlook. The tool is an independent platform and accomplishes the conversion on its own. One can also try the free demo edition of the CSV contacts converter tool to move 25 maximum contacts from CSV files to PST format.

Take a look at the simple working of the program to convert CSV contacts to PST without Outlook.

How to Convert CSV Contacts to PST files without MS Outlook?

  1. Download & open CSV to PST convertertool on Windows.
  2. Upload .csv contacts with Select Files and Select folder button.
  3. Check the folder containing CSV contacts to convert into PST.
  4. Now, choose PST as a file saving option as shown in the screenshot.
  5. Therefore enter the destination path to get the final results and Convert.

After that, in this way, one cab effortlessly converts CSV files to PST without Outlook configuration. However, the software is a valuable utility and performs the conversion smoothly.

Read Some Valuable Qualities of the Tool

  1. It is an easy-to-use program to convert CSV files to PST format.
  2. Allows converting CSV files to various email client applications.
  3. Recommended software for adding the bulk of CSV files without loss.
  4. It doesn’t require external installation for CSV to vCard conversion.
  5. Efficiently convert multiple CSV files to an individual PST file.
  6. In addition, unique options to create combine or individual VCF files.

Take a Look at the Frequently Asked Questions

Que 1 – I have Gmail exported CSV contact file but my Gmail account has been suspended. Can you tell me how can I save my contacts in vCard format?

Ans. Of course, you can use BitRecover CSV to vCard Converter. This software is compatible with CSV files from Gmail as well as G Suite accounts. The highlighted feature of this software is that you can set vCard encoding to your requirements like ASCII, UTF-8, Unicode, UTF-32, UTF-7, etc.

Que 2 – Does this tool allow me to move the bulk of CSV files to PST?

Ans. Yes, of course, the software is capable of converting the bulk of CSV files to PST format.

Que 3 – Can I download the CSV Contact converter tool on the Mac machine?

Ans. No, the utility is designed by an expert for the Windows supportive application.

The Final Thoughts

The above all blog explains the Goggle in-built technique to export contacts from Gmail to CSV file format. Moreover, one can use a fabulous tool to save contacts from CSV to other file formats. The process is user-friendly and doesn’t require any technical knowledge. It works smoothly on all the Windows platforms and gives 100% accurate results.

Do you want to import phone numbers from Excel to Gmail? Unfortunately, are you not aware of the manual process to do the same? Then, you are fortuitous indeed as you are reading the correct blog. In this write-up, we will focus mainly on the steps to import mobile numbers from an Excel spreadsheet to Gmail in a most comprehensive way.

How to add contacts to gmail using a csv file

Need to Transfer Excel Contacts to Gmail

Gmail being a user-friendly and free email application, it is used widely across the globe for both personal and business usage. Many times, contacts or phone numbers play an important role in one’ life. Moreover, users do not want to lose them in any way due to any technical or human errors in the future. Hence, it is important to backup or creates another copy to some reliable platform like Google Contacts. Apart from that, a user can upload phone numbers from Excel to Gmail in several ways as they can easily call or send emails from your Office computer.

As a result, there comes a circumstance wherein users look out to know the procedure to import mobile numbers from an Excel spreadsheet to Gmail. As Gmail provides an inbuilt facility to import the phone numbers in CSV format, hence it becomes easy to do the process in a hassle-way way.

Let’s have a quick glance at the below-described user-scenario to understand in a broad manner,

“Please help! Being a Sales Manager, I have some important phone numbers of my clients which I want to move them into my Gmail account. This will help me to sync a copy of my important contacts saved in excel spreadsheet to Gmail so that even if I lose any of the phone numbers I need not have to worry. Is there some way out to transfer phone numbers saved in an excel format to a Gmail profile?”

Manual Trick to Import Phone Numbers from Excel to Gmail?

In order to implement the process manually, the first one needs to create an excel file with all the phone numbers and later save the excel file in CSV format. Secondly, import the CSV file to a Gmail profile.

Step 1: Create a CSV File

  • Initially, enter the details like Phone number, First name, Last name, Email address and other details in MS Excel
  • Once the Excel file is created consisting of contact details, save the Excel file as CSV format to import phone numbers from excel spreadsheet to Gmail

Tip: In case the excel file, which carries the most crucial data is corrupted, then simply make use of Excel Recovery tool. It is a trustworthy and hassle-free tool, which not only repair corruptions from the Excel file but also performs the operation to recover data from the damaged excel file.

Step 2: Import CSV File to Gmail

  • To begin with, sign-in to the Gmail account. For that, provide the credentials i.e., Username and Password in the appropriate fields
  • Now, click on Google apps icon, from there select Contacts
  • Then, click Import Contacts to import phone numbers from excel to Gmail

How to add contacts to gmail using a csv file

  • After this, Import contacts wizard will appear, from there click on Choose file button and select the CSV file, which contains the phone numbers and other details to import into Google contacts

How to add contacts to gmail using a csv file

  • Once the CSV file is uploaded, click the Import button to successfully import phone numbers from excel to Gmail
  • It will take some time to get uploaded into the Gmail account based on the data saved in the CSV file

Do You Know About Automated Solution to Transfer Excel Contacts to Gmail?

Apart from CSV format, Google contacts can support vCard file format. Even if the phone numbers are saved in Excel format, one can smoothly convert Excel Spreadsheet to vCard format using the SysTools Excel to VCF Conversion tool. Moreover, the vCard format is also supported in different email applications like Outlook, Lotus Notes, Thunderbird, AOL Mail, Hotmail, etc.

Let’s Sum Up

In today’s era, phone numbers or contacts play a crucial role. However, we cannot survive without it, therefore it is important to backup the contacts to prevent from data loss. One can import phone numbers from excel to Gmail profile, so that they can access a backup copy in Gmail, if in case the actual data is lost. In this blog, we have described its steps in a clear manner, which anyone can easily implement and do the needful.

Frequently Asked Questions

A. In order to transfer excel contacts to Google Contacts, you can convert Excel to VCF file and then import the contacts into Google Gmail account. To do so, you can take the help of Excel Files to vCard files conversion tool.

A. Yes, the mentioned automated tool will help you to export multiple contacts from the Excel spreadsheet to Gmail account.

A. To transfer the Excel contacts list to the Gmail account, first, you need to export Excel to CSV file and then import the CSV file into Gmail.

A. There are multiple ways to import phone numbers into Gmail Contacts. You can use your Sim Card, Bluetooth, Cloud Storage, and other third-party utilities to do the same.

How to add contacts to gmail using a csv file

It seems you want to export Google contacts to CSV file on your computer system. In that case, we have got you covered. Here, you will learn how to convert Google contacts into CSV or VCF file and store it on your computer. The methods will cover both Gmail and G Suite user accounts. You will also know some problems that users come across when exporting address book, and the ways to overcome them.

Method to Export Google Contacts to CSV File

The following methods are applicable to one Google account at once.

I. New Layout Method

  • Open Google contacts in your web browser and log in with your credentials.
  • Google contacts page will open. Here, click the Export option from the left panel to export all contacts.
  • If you want to export only selected contacts, choose them and then click Export option.
  • Select Google CSV option from the list and click Export button.
  • The contacts file will be downloaded in CSV format.

II. Old Layout Method

  • Open Google Contacts and log into the Google account.
  • Click More and select Export from the dropdown menu.
  • Select the contacts that you want to export, choose the file format: Google CSV, then click Export button.
  • The browser will download the contacts to your computer. You can open the downloaded file using compatible application.

Errors While Converting Google Contacts

When exporting Google contacts to CSV file, some users come across errors that we have explained below. If you get these errors, overcome them with the given instructions.

Error 1: ‘Export’ option unavailable

How to add contacts to gmail using a csv file

This is not an error, but a misunderstanding. This problem arises when a user is using the new layout of Google contacts. But in the old layout, the Export feature is available in More Settings. But in the new layout, it is unavailable. In such case, simply opt for the method given above as per the layout you are using.

Error 2: Extraction of a lot of Junk contacts

How to add contacts to gmail using a csv file

This is a common problem when exporting Google contacts to CSV file. It can be avoided if you isolate the contacts with several lines in a separate group. Another way is to open the file in compatible application (MS Excel).

Method to Export Google Contacts from Multiple Accounts Collectively

Sometimes, users want to export contacts from multiple Google accounts. Take a look at the G Suite user query:

How to add contacts to gmail using a csv file

For such users, it is not possible to directly get CSV files. You can use G Suite Backup Tool to export Google contacts into VCF file. It is the universal format to store contacts/address books. If you specifically want CSV files, you can use some online converter. If you are a G Suite administrator and take backup of multiple user accounts at once, then opt for this method.

  • Download and Install the software on your system, click Backup tool.
  • Click Domain Users to export from multiple accounts.
  • Enter your admin id and import CSV file containing user accounts to process.
  • Select Contacts from the Category section and set format.

Tip: Selecting PST format will result in contacts stored in a PST file for MS Outlook. Choosing any other format will result in VCF files.

  • Click Start to initiate the export process.
  • That’s it, all the contacts are exported to vcf format.

Final Words

Exporting items from Google application is a constant query on the internet. Here, we have focused on exporting Google contacts to CSV or VSF format. The methods are explained for both Gmail and G Suite users. You can use the manual method to export contacts from single Gmail account. And the mentioned software easily converts address book from multiple Google Suite user accounts. You can use this software to easily import contacts into Outlook, Google, and all major applications. Whether you want to choose it or not entirely depend on your requirements.

Before starting the process of importing vCard to Gmail 2021 account, first get the basic important information related to the procedure because after that you can easily understand about exporting vCard to Gmail.

About vCard File

A vCard file is also known as VCF (Virtual Contacts File), which was specially designed to manage electronic business cards. A VCF file can contain all the information related to the business cards as Name, Email, Company, Job Title, Web Page Address, Business Address, Business Phone No, Home Phone No, Business Fax No, Mobile Phone No, Home Address, Profile Photos, Audio Clips, etc. A VCF file is used as data interchange format in various management programs like Personal Digital Assistants, Personal Information Managers, and Customer Relationship Management as well as most of the email clients and services allow to import and export contacts in vCard VCF format like Mozilla Thunderbird, SeaMonkey, Windows Live Mail, Mac Mail, Netscape, IncrediMail, Zimbra, eM Client, Gmail, G Suite, Yahoo, MS Outlook, Outlook Express, Eudora, Opera, etc.

How to Import Contacts from vCard to Gmail Account?

Just follow given steps for importing vCard to Gmail 2021 edition.

  • Login to your Google Mail account and click on 3×3 grid of dots as shown in the screenshot.

How to add contacts to gmail using a csv file

  • From here, choose Contacts option.

How to add contacts to gmail using a csv file

  • Now press More button.

How to add contacts to gmail using a csv file

  • Choose the Import option.

How to add contacts to gmail using a csv file

  • This popup window is asking to import contacts from other accounts and other files. From here, hit on the CSV or vCard file option.

How to add contacts to gmail using a csv file

  • Choose GO TO OLD VERSION from this popup message.

How to add contacts to gmail using a csv file

  • Select Import Contacts… option from old Gmail contacts.

How to add contacts to gmail using a csv file

  • Showing a message “ We support importing CSV files from Outlook, Outlook Express, Yahoo! Mail, Hotmail, Eudora and some other apps. We also support importing vCard from apps like Apple Address Book ”. Please select a CSV or vCard file to upload by clicking on Choose File.

How to add contacts to gmail using a csv file

  • Select VCF or vCard file from your computer and press Open button.

How to add contacts to gmail using a csv file

  • A vCard file is selected for importing, now click on Import button as shown in the screenshot.

How to add contacts to gmail using a csv file

  • Now view vCard contacts in Gmail 2021 edition including proper information.

How to add contacts to gmail using a csv file

Conclusion

After reading this informative blog post anyone can easily import vCard to Gmail contacts (upload VCF contacts to Gmail) without facing any difficulties as it is written by using real screenshots. The process to export vCard to Gmail is most helpful for many users who are looking for a reasonable solution for solving “ how to add vCard to Gmail contacts ” related queries.

Does your company have lots of existing business contacts that you want to include in the shared address book (also called the global address list) in Exchange Online? Do you want to add external contacts as members of distribution groups, just like you can with users inside your company? If so, you can use Exchange Online PowerShell and a CSV (comma-separated value) file to bulk import external contacts into Exchange Online. It’s a three-step process:

After you complete these steps to import contacts, you can perform these additional tasks:

Step 1: Create a CSV file that contains information about the external contacts

The first step is to create a CSV file that contains information about each external contact that you want to import to Exchange Online.

Copy the following text to a text file in NotePad, and save it on your desktop as a CSV file by using a filename suffix of .csv; for example, ExternalContacts.csv.

If your language contains special characters (such as å, ä, and ö in Swedish) save the CSV file with UTF-8 or other Unicode encoding when you save the file in NotePad.

The first row, or header row, of the CSV file lists the properties of contacts that can be used when you import them to Exchange Online. Each property name is separated by a comma. Each row under the header row represents the property values for importing a single external contact.

This text includes sample data, which you can delete. But don’t delete or change the first (header) row. It contains all of the properties for the external contacts.

Open the CSV file in Microsoft Excel to edit the CSV file because it’s much easier to use Excel to edit the CSV file.

Create a row for each contact that you want to import to Exchange Online. Populate as many of the cells as possible. This information will be displayed in the shared address book for each contact.

The following properties (which are the first four items in the header row) are required to create an external contact and must be populated in the CSV file: ExternalEmailAddress, Name, FirstName, LastName. The PowerShell command that you run in Step 2 will use the values for these properties to create the contacts.

Step 2: Create the external contacts with PowerShell

The next step is to use the CSV file that you created in Step 1 and PowerShell to bulk import the external contacts listed in the CSV file to Exchange Online.

Connect PowerShell to your Exchange Online organization. For step-by-step instructions, see Connect to Exchange Online PowerShell. Be sure to use the user name and password for your global administrator account when you connect to Exchange Online PowerShell.

After you connect PowerShell to Exchange Online, go to the desktop folder where you saved the CSV file in Step 1; for example C:UsersAdministratordesktop .

Run the following command to create the external contacts:

It might take a while to create the new contacts, depending on how many you’re importing. When the command is finished running, PowerShell displays a list of the new contacts that were created.

To view the new external contacts, go to the Exchange admin center (EAC), and then click Recipients > Contacts.

For instructions for connecting to the EAC, see Exchange admin center in Exchange Online.

If necessary, click Refresh to update the list and see the external contacts that were imported.

The imported contacts will appear in the shared address book in Outlook and Outlook on the web.

You can also view the contacts in the Microsoft 365 admin center by going to Users > Contacts.

Step 3: Add information to the properties of the external contacts

After you run the command in Step 2, the external contacts are created, but they don’t contain any of the contact or organization information, which is the information from most of the cells in the CSV file. This is because when you create new external contacts, only the required properties are populated. Don’t worry if you don’t have all the information populated in the CSV file. If it’s not there, it won’t be added.

Connect PowerShell to your Exchange Online organization. For step-by-step instructions, see Connect to Exchange Online PowerShell.

Go to the desktop folder where you saved the CSV file in Step 1; for example, C:UsersAdministratordesktop .

Run the following two commands to add the other properties from the CSV file to the external contacts that you created in Step 2.

The Manager parameter might be problematic. If the cell is blank in the CSV file, you will get an error and none of the property information will be added to the contact. If you don’t need to specify a manager, then just delete -Manager $_.Manager from the previous PowerShell command.

Again, it might take a while to update the contacts, depending on how many you imported in Step 1.

To verify that the properties were added to the contacts:

In the Exchange admin center, go to Recipients > Contacts.

Click a contact and then click Edit to display the contact’s properties.

That’s it! Users can see the contacts and the additional information in the address book Outlook and Outlook on the web.

Add more external contacts

You can repeat Steps 1 through Step 3 to add new external contacts in Exchange Online. You or users in your company can just add a new row in the CSV file for the new contact. Then you can run the PowerShell commands from Step 2 and Step 3 to create and add information to the new contacts.

When you run the command to create new contacts, you might get an error saying that the contacts that were created earlier already exist. But any new contact added to the CSV file is created.

Hide external contacts from the shared address book>

Some companies may use external contacts only so they can be added as members of distribution groups. In this scenario, they may want to hide external contacts from the shared address book. Here’s how:

Connect PowerShell to your Exchange Online organization. For step-by-step instructions, see Connect to Exchange Online PowerShell.

To hide a single external contact, run the following command.

For example, to hide Pilar Pinilla from the shared address book, run this command:

To hide all external contacts from the shared address book, run this command:

After you hide them, external contacts aren’t displayed in the shared address book, but you can still add them as members of a distribution group.

How to add contacts to gmail using a csv file

If you have a large number of contacts in an Excel spreadsheet that you need to import into Gmail Google Contacts. If so, then you must first export Excel contacts to vCard or CSV file format. Because Gmail does not support the import of Excel XLS / XLSX files. In today’s blog, we will keep you informed about the complete method to import Excel contacts into Google Contacts via CSV and vCard file.

Microsoft Excel is a well-known name used to store and manage a large amount of data. Most users prefer to save contacts in an Excel spreadsheet with details such as first name, last name, phone number, email id, and much more.

On the other hand, Gmail is a free email service used to send receive emails, save contacts & calendar, chat, and more. In today’s modern era, nobody wants to lose their contacts so they want to create a backup of contacts, and Gmail is a secure platform to store them. Users can easily synchronize their contacts with the phone. So, it is needed to import contacts from Excel to Gmail Account.

User Query – How Can I Transfer Excel Contacts to Gmail?

“Hi, I would like to add multiple contacts in Gmail from Excel Spreadsheets because Gmail is helpful for accessing contacts in my phone. But I am confused on how to save contacts from Excel to Google Contacts because Google does not support Excel XLSX file. Does anyone know any of a solution to upload Excel contacts to Gmail account?

You May Also Like:

Manual Approach to Import Excel Contacts into Google Contacts

As mentioned earlier, Gmail does not support Excel XLS / XLSX files. Therefore, you must first save Excel contacts in CSV file format and then import the CSV file into the Gmail account. In the following section we show the step-by-step method to do this:

Step 1: Save Excel File to CSV Format

  • First, arrange your contact information properly in an Excel spreadsheet. Separate columns and rows for First Name, Last Name, Mobile Number, Email Address and other details.
  • Next, save as Excel file as CSV format (Comma Separated Values).
  • You are done with the first part to transfer excel contacts to Gmail. Now move to the second part.

Step 2: Import CSV File into Gmail

  • Log in your Gmail account.
  • Click on “Google Apps icon” and select “Contacts”.
  • Select the “Import” option to import contacts from Excel to Gmail.
  • In the Import Contacts wizard, “select the CSV file” created in step 1
  • After selecting .csv file, click the “Import” button.

Done! This is how you can easily save contacts from Excel to Google Contacts for free.

Why Not Go with Automated Way to Import Excel Contacts into Google Contacts?

Google Gmail supports CSV and vCard file format for importing contacts. You can also convert Excel contacts to vCard file and easily import contacts from Excel to Gmail. You can do this by using Excel to vCard Converter, which lets you export Excel XLSX contacts to vCard VCF file with all contact details. The vCard is an electronic business card that stores contact information in a standard format. Vcard file is compatible with almost all devices and applications such as Android Phone, Google Contacts, Outlook, iPhone, iCloud, etc.

This conversion tool makes it easy to convert multiple contacts from Excel to VCF file without any size and data loss issues. It supports each and every version of Excel and is compatible with all Windows OS versions including Win-10. Download the tool and get multiple features.

Let’s Learn How to Transfer Excel Contacts to Gmail via vCard File

Here are the steps to import Excel Contacts into Google Contacts with a vCard (VCF) file.

Step 1. Start the tool and Browse to load Excel XLS /XLSX file.

How to add contacts to gmail using a csv file

Step 2. Preview Excel Contacts Data and click Next.

How to add contacts to gmail using a csv file

Step 3. Map Excel Fields with vCard Fields and click Next.

How to add contacts to gmail using a csv file

Step 4. In the Export selection, check the required boxes and choose the vCard version.

How to add contacts to gmail using a csv file

Step 5. Click Browse to save Output and click the Convert button.

How to add contacts to gmail using a csv file

When the conversion process is complete, the software will display a confirmation message. Now you can review the contacts from the selected location and save contacts from Excel to Google Contacts by following the same process as the CSV file.

Closing Words

We know the importance of Contacts today. Therefore, we have described the proven solution to import contacts from Excel to Gmail account. You simply export Excel contacts to CSV or vCard file to import contacts into Gmail. Here we explained both solutions of how to transfer excel contacts to Gmail via CSV file and how to import Excel contacts into Google Contacts via vCard vcf file.

Google Mail allows you to import a contact group from an Excel file into Google Contacts. This process consists of two steps: saving the contact group Excel file as a .CSV file and then importing the .CSV file into your Google Contacts.

Step 1: Entering contacts into an Excel file and saving it as a .CSV

How to add contacts to gmail using a csv file

  1. Open Microsoft Excel. In the first row, label the first three columns as follows:
    • First Column: First Name
    • Second Column: Last Name
    • Third Column: Email Address
  2. In the rows below those, enter the corresponding information for each contact.
  3. When you are done entering all the information for each contact, navigate to “File” > “Save As”.
  4. From the “Save as type:” drop-down menu, select “CSV (Comma delimited) (*.csv).”
  5. Select a location to save the file.
  6. Click [Save]. If a window pop-ups asking if you want to keep the workbook in this format, click [Yes].

Step 2: Importing the .CSV file into Google Contacts

How to add contacts to gmail using a csv file

The new Google Mail only offers a preview version of your Google Contacts. Google will prompt you to restore your old contacts in order to import them. If you already have the old version of Google Contacts, you can skip to Step 5.

  1. Navigate to cedarville.edu/google.
  2. Click the “Mail” link and log in using your CedarNet credentials.
  3. In the upper-left corner, click the “Mail” drop-down menu > Select “Contacts.”
  4. From left side panel, select “More” > “Import.”
  5. In the resulting dialogue box, click [GO TO OLD CONTACTS].
  6. Click [More] > Select “Import. “
  7. Click [Choose File] and double-click the file containing the shared contact group > Click [Import].
  8. Click the name of the contact group in the sidebar. (The name will be “Imported” along with the date.) You will have a notification that “These contacts have been imported, but not yet merged.”
  9. Click [More] > Select “Find & merge duplicates.”
  10. Click [Merge]. The contacts are now merged and imported.
  11. To rename the group, select the group from the left side panel.
  12. Click [More] > Select “Rename group”.
  13. In the resulting dialogue box, enter a new name in the provided field, and then click [OK]. The group is renamed and will appear as that name in the contact groups list.

Keywords: import contacts from Excel, create .CSV file from Excel, make .CSV file