Transfer Google Apps Contacts to Excel Spreadsheet In Simple Steps

By -
Google Apps for Work, formerly known as Google Apps for Business is a cloud based productivity tool offered by Google. Some of the most popular applications of Google Apps for work include Gmail, Google Drive, Google Calendar, etc. Gmail, launched in 2004, has bagged the tag of the most popular email client owing to its 900 million users spread around the globe.
Since Google Apps is a cloud service, the user at times might want to keep a backup of some of the crucial data of Gmail.
One such important attribute of Gmail is the contacts stored in it. Losing these contacts means losing connectivity with your potential customers and clienteles. Therefore, having a backup of all the contacts ensure that even in case the contacts are lost somehow fromGmail, the user will still be able to get back all the contacts.
In this blog, we willdescribe the procedure by which the users can transfer Google Apps contacts to Excel spreadsheet.

I. To Transfer Selected Gmail Contacts

For exporting only a few contacts from Gmail to Excel spreadsheet, follow the below-mentioned steps:
  1. Login your Gmail account.
  2. Click on Gmail and select Contacts option.

  3. Click on More option and select Export option.
  4. Select those contacts, which you want to transfer.
  5. Select Selected Contacts option. Since we need to transfer the contacts in a file, which can be accessed in all of the supporting applications, we will choose the Outlook CSV Format and Click on Export to proceed.
  6. Open the output CSV file and click on File option.
  7. From the drop down menu, select Save As option.
  8. Give a name to the file and in the Save as type field, select Excel Workbook (*.xlsx) option. Click on Save option to save the Excel spreadsheet.

II. To Transfer Gmail Group Contacts

In order to export contacts residing in a particular group, follow the below-mentioned steps:
  1. Login your Gmail account.
  2. Click on Gmail and select Contacts option.
  3. Click on More option and select Export option.
  4. Select The Group option.Since we need to transfer the contacts in a file, which can be accessed in all of the supporting applications, we will choose the Outlook CSV Format. Click on Export option.
  5. Open the output CSV file and click on File option.
  6. From the drop down menu, select Save As option.
  7. Give a name to the file and in the Save as type field, select Excel Workbook (*.xlsx) option. Click on Saveoption to save the Excel spreadsheet.

III. To Transfer All The Gmail Contacts

  1. Login your Gmail account.
  2. Click on Gmail and select Contacts option.
  3. Click on More option and select Export option.
  4. Click on All Contacts option. Since we need to transfer the contacts in a file, which can be accessed in all of the supporting applications, we will choose the Outlook CSV Format.
  5. Open the output CSV file and click on File option
  6. From the drop down menu, select Save As option.
  7. Give a name to the file and in the Save as type field, select Excel Workbook (*.xlsx) option. Click on Save option to save the Excel spreadsheet.

Conclusion

The above-mentioned steps, when followed correctly, will enables the users in successfully transferring Google Apps contacts to Excel spreadsheet

Comments

Post a Comment

Popular posts from this blog

How to Repair Excel Strict Open XML Spreadsheet ?

By -
Image
File Format In Microsoft Excel Workbook Microsoft Excel application is utilized for spreadsheet management. When users create a new worksheet in Excel, it can be saved in two main formats of XLSX. One is Excel Workbook (.xlsx) and another is Strict Open XML Spreadsheet (.xlsx) . These two formats are a bit different from each other.  How Strict Open XML Spreadsheet is Different ? The ordinary Excel Spreadsheet is called the transitional variant while Strict Open file is known as the strict variant. As the file name suggests, there are some restrictions in Strict Open Excel files. For example, Strict XLSX file contains graphics done by DrawingML, as VML is not supported. This file format also contains UNICODE Characters only. Strict XLSX also does not allow legacy techniques. User Query 1: “I am in urgent need to open some Excel files. I keep getting this error message whenever I attempt to open those files: Strict Excel Spreadsheet .xlsx is not valid. I do not k...
Read more

Can I Copy And Paste a List of Email Addresses from Excel To Outlook?

By -
Image
“Hello, I have recently joined an organization, in which I have to take records of thousands of contacts. And for easy management, I keep those contacts list in Microsoft Excel file. But recently there is a need to transfer all email addresses from Excel contacts to Outlook account. Therefore, I want to know, can I copy and paste a list of email addresses from Excel to Outlook? If yes, then how?” Now let’s start. Sorry, the answer is no. You cannot copy and paste the email address from the Excel sheet to Outlook, but you can import them to Outlook contacts. In this blog, we will discuss various solutions available to import contacts from Excel spreadsheet to Outlook contacts . So first let's discuss the manual solution and the difficulties which come with it. Import Contacts (Email Addresses) From Excel File to Outlook Open the Microsoft Outlook & go to the File menu Choose open & Export category from the dashboard Hit on the import/export. Select Import from...
Read more