You probably find yourself in a situation where you need to know how to export contacts from Gmail to Excel either to have a backup of all your contacts, edit them to add more relevant information or import them to another account in either Gmail or Outlook. In this article we are going to explain what you need to do so that you can save all the information of your contacts stored in Google in an Excel table in a few simple and quick steps.

On the web we can find many articles that try to talk about this topic, but they are actually aimed at exporting Gmail contacts to a CSV format file without explaining much. Now, many times we need to edit, delete or add new phone numbers and using an Excel sheet will make this task much easier.

How to Backup and Export Gmail Contacts

In case you didn’t know, Gmail backs up all the contacts we have on our devices for a period of the last 30 days. However, backing up your contacts will allow you to access them at any time. It is a method to keep our contact information more secure.

The Most Popular Email Servers

Follow these steps to download an Excel backup:

  1. Sign in to the Gmail page, then sign in to the account you want to back up.
  2. Select Google Contacts from the product menu or go to contacts.google.com.
  3. Once inside we proceed to make the selection of the contacts we want to export, this can be done manually to select more personality to select those contacts we want to save.
  4. Locate the Export option in the menu on the left.
  5. Select between selected Contacts or if you want to export all of them ignore step 3 because at this point you can select the Contacts option to select all of them.
  6. Select Google CSV or Outlook CSV.
  7. Then the download will start and the backup will be ready.

What is Photocall TV and how to Watch free TV Channels

How to create an Excel contacts format

The file you will provide is designed to aggregate in a single column all the contact information separated by commas (,). If we want to be able to read our contacts in a faster and easier way, we will have to make some modifications so that it adapts better to what we are looking for. First of all, we must select all the column where all the information is located and we go to the Data section and click on Text in columns.

Download FREE MUSIC on Android, iOS and PC

Editing it is very simple, we only have to select “delimited values” and then in the next step choose the comma (,) as the separator of the values. We just have to click on accept and finish so that our contacts begin to be displayed in a more orderly way showing each of the details in columns with their proper name to identify them.

Keep Reading this Post:  5 KEYS to Finding a Good JOB Online

5 Responses

  1. Нellо all, guysǃ Ι knоw, my mesѕagе maу bе toо sресifiс,
    But my ѕiѕter found niсe man herе аnd thеy mаrrіеd, ѕо hоw abоut me?! 🙂
    Ι аm 24 yеarѕ оld, Μаrgarіtа, frоm Ukrаіne, I know Εngliѕh аnd Gеrman languаgеs аlѕo
    And… Ι hаve specifіc dіsеaѕe, nаmеd nymрhоmаnіа. Who knоw whаt іs this, сan undеrstand me (better tо ѕаy іt immеdіаtely)
    Аh yеs, Ι cook very tаѕtу! аnd Ι lоvе nоt only соok ;))
    Im rеаl gіrl, nоt рrоѕtitutе, and looking fоr ѕerіouѕ and hot relatіonѕhіp…
    Αnуwaу, yоu сan find my рrofilе herе: http://pawsocecacoudip.ga/user/51582/

  2. Morning

    Don’t you hate carrying a big bulky backpack when you are only going out for the day? This high quality shoulder bag solves that problem.
    Carry enough without bogging yourself down! Perfect for that fishing trip or day hike!

    50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time

    Buy now: https://fashionbag.sale

    Cheers,

    Gregorio

  3. Morning

    Defrost frozen foods in minutes safely and naturally with our THAW KING™.

    50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time.

    Buy now: https://thawking.store

    Many Thanks,

    Brock

  4. Hello аll, guyѕǃ Ι knоw, mу message maу bе toо ѕpесifіc,
    Вut my sіѕter found nice mаn herе and they mаrriеd, ѕo hоw abоut me?! 🙂
    I am 25 уеаrs оld, Αnika, from Rоmаnіa, I know Engliѕh and Gеrmаn languages alѕo
    And… Ι hаvе ѕpесіfіc dіsease, nаmеd nymрhomаnіа. Who know what іѕ thіѕ, саn understаnd mе (bettеr tо ѕay it immеdiаtеlу)
    Αh уеs, I сoоk vеrу tаѕty! аnd I lоve not оnlу соok ;))
    Ιm reаl gіrl, nоt рroѕtitute, and looking for sеrіouѕ аnd hоt rеlatiоnѕhip…
    Anуway, уou саn find my рrоfіle herе: http://secusbudeskte.tk/user/14025/

Leave a Reply

Your email address will not be published.