Importing contacts into Google Contacts should be pretty straight forward. In theory, all you need do is import your .CSV file containing your contact list into Google Contacts.

1. Upload Contacts From Google To Iphone
2. Upload Contacts From Outlook

However, sometimes the import fails and it’s hard to know why.

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. Contacts are missing info: After you import your contacts, if you open Outlook and see that not all the info was imported, open the CSV file with Excel to see if the information was there. You can edit the CSV file using Excel to add names and other missing information. Outlook requires the column headings in the first row so don’t replace them with something else. Sign in - Google Accounts - Google Contacts.

The issue is often that the .CSV you are uploading is formatted incorrectly and Google rejects the data in the file.

One way to solve the problems of importing files into Google Contacts is to make sure that you are using the correct CSV file format that Google Contacts will accept.

Getting access to this format is as easy as downloading a Google Contact “template” CSV file. Then all you need do is copy/paste your data into the correct columns and upload the updated CSV back into Google Contacts.

Follow these steps:

1. Download a correctly formatted Google Contact CSV file. You can download one here or create your own (see bottom of this post).
2. Copy / paste your Name and Email contact data into the correct columns (B, D and AC)
3. Save the updates to the Google.csv file.
4. Upload the Google.csv file to your Google Contacts (See Importing Google Contacts)

We have created a Google.CSV file for you or you can create your own like this:

Related articles

Google’s Gmail is a popular email platform that is widely used across the globe. In fact, small and medium-sized businesses prefer to create Google Workspace (G Suite) accounts with their own domain to use all its features and functionalities. Also, many organizations and individuals use Outlook to manage their Gmail accounts However, Gmail is not the only email service supported by Outlook. It supports email services like Yahoo, Outlook.com, etc. in addition to Exchange/Office 365 accounts. But sometimes, we need Google contacts in other email services and accounts.

That’s where the need to import G Suite data to MS Outlook arrives. However, most organizations are not interested in moving the entire data at once; they just want to export the contacts first. Now, as you know, you can easily export them to Outlook PST.

Here, we will discuss how you can export Google’s contacts and then import them to Outlook with easy methods.

Instant Solution

Download Kernel G Suite Backup tool to import Google contacts to MS Outlook 2019 in secure and simple way.

Export Contacts from Gmail

1. Open your Gmail account and go to Contacts from the Menu section.
2. After opening Contacts, click the Export option in the left menu.
3. A pop-up window will appear on the screen; select the type of contacts that you want to export and choose the Outlook CSV option as an export format, and then click Export.
4. The contacts will be exported to your system in Outlook CSV format.

After exporting the contacts, you can now import them to MS Outlook.

Import Google’s Contacts to Outlook

To import Google’s contacts to Outlook 2013/2016/2019, make sure you have installed the specified MS Outlook on your system. After that, you can follow the below steps:

1. Launch MS Outlook on your system and go to the File tab.
2. Select the Open/Export option and then click the Import/Export option.
3. In the opened tab, click Import from another program or file and click Next.
4. Now, select the Comma Separated Values option and click Next.
5. From the Import a File section, click Browse and select the CSV file of your Gmail contacts.
6. Choose how you want to handle duplicated contacts and click Next.
7. In the next step, select the Contacts folder in your Outlook mailbox and click Next and then click Finish.

Outlook will import all the contacts from the .CSV file, and you can check the contacts in the mailbox. To view your contacts in MS Outlook, select the Address Book, and click Contacts. It will display all the contacts in your Outlook, including the recently imported contacts.

Upload Contacts From Google To Iphone

Common Issues with Importing Gmail Contacts

Upload Contacts From Outlook

Importing contacts from Gmail is not a big deal, but there are some challenges that you might face while doing so.

• Importing more than 2000 contacts could result in an unexpected error. In this case, try to split the CSV into smaller .csv files with MS Excel.
• Contacts might not appear after importing them to Outlook. In this case, check whether the CSV file has contacts.
• Contact info is missing in the CSV file after Import. In such scenarios, you can use MS Excel to edit information on the CSV file, such as names and other missing information.

Apart from the above errors, there is one more thing that you need to know. With the above method, you can only export/import contacts from a single Gmail account. However, if you have a G Suite account that holds multiple accounts with multiple contacts, then you need an advanced utility that allows you to export contacts from multiple accounts at a time.

Kernel G Suite Backup – To Import Contacts from Multiple Gmail Accounts to PST

Kernel G Suite Backup is an advanced tool that is designed to export all your Google Workspace data to Outlook PST format. Besides, it gives you advanced filtering options that allow you to export specific items like contacts from your Google account. It follows a simple working process that makes it even more suitable for all types of users.

Here, we will cover how you can export contacts from multiple Google accounts to Outlook PST.

1. Install and launch the Kernel G Suite Backup software on your system, and click the Add button to add the G Suite account.
2. In the G Suite login page, provide the details for the G Suite account, such as email ID, service account ID, and P 12 file path. Now, select the option ‘List all mailboxes’ and then click Get User Mailbox.
3. The software will fetch all the mailboxes linked to G Suite. Select the specific mailboxes and click Add.
4. Once the selected mailboxes are added, click the Set Filter and Migrate option.
5. The filter section window will appear on the screen, select the Contacts from every mailbox and click I am OK Start Migration.
6. Now, select the format in which you want to export the G Suite mailboxes and click OK.
7. Select a location to save the contacts on your system and click OK.
8. The tool will start exporting the contacts in PST format. Once it is finished, a notification will appear on your screen, confirming the same.

After finishing the process, you can save the report to CSV format as well.

Video Tutorial to Backup G Suite/Google Workspace Contacts to Outlook

Conclusion

Importing contacts from Gmail becomes a necessity, especially when you are using other email services or accounts in MS Outlook. But, importing multiple contacts from multiple Gmail accounts is not easy with manual methods. Thus, it would help if you have an alternate solution to import all your contacts to Outlook. In this article, we discussed how you could import contacts from G Suite mailboxes to Outlook PST with an advanced utility.

More Information