Ask Your Question
1

get addresses from google

asked 2018-11-20 14:52:42 +0200

glenn.jan@gmail.com gravatar image

updated 2018-11-27 20:26:28 +0200

EasyTrieve gravatar image

Is it possible to import or link my google contact address book?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-11-20 17:31:39 +0200

PhLo gravatar image

updated 2018-11-20 17:53:38 +0200

Import to where? Calc? Base? Writer?

The answer to all 3 is "yes." Calc is the easiest. From there you can get the data elsewhere.

1) Visit https://www.google.com/contacts and log in

2) Click on More -> Export... near the top.

image description

3) Choose Google CSV format and click Export

image description

4) After the CSV file is downloaded, locate the file where you chose to put it and open it with Calc (or open it with Calc via the prompt when downloading)

5) You should see a dialog like this one. Make sure the settings are similar, especially Separated by -> Comma. Click OK button.

image description

Now that you have your contacts in a Calc spreadsheet, there are a number of things you can do with the information. Perhaps the steps outlined are all you needed to do. Otherwise consider asking a separate question about what to do with the information once in LibreOffice. Search the forum first, as your question might already be answered. Do you want to print the list? Do you want to make mailing labels? Do you want to create a Base database? Do you have a Christmas letter and want to insert names in the salutation at the top (mail merge)?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-20 14:52:42 +0200

Seen: 52 times

Last updated: Nov 20 '18