Www.cookfamilyfoundation.org



Exporting Contacts from Google Apps

1. Go to

2. Sign in to your @ account (if necessary)

3. Click on the desired contact group that you would like to export on the left side of the screen (below the red “NEW CONTACT” button)

4. Click on the “More” tab near the center of the screen and then select “Export”

5. When the dialog box appears, select “The group ______________” under “Which contacts do you want to export?” and ensure that the correct group is selected.

6. Under “Which export format?” ensure that Google CSV format is selected

7. Click Export and the spreadsheet will be downloaded

8. Open the spreadsheet in Excel

9. Once the spreadsheet is open, you may notice additional unnecessary columns that Google has created which can be deleted or hidden, if desired

a. To delete the columns:

i. Use the shift or Apple key to select the columns that you wish to remove ensuring to click on the letter of the column to select the entire column(s)

ii. Right click (or Ctrl + click) and select delete

b. To hide the columns:

i. Use the shift or Apple key to select the columns that you wish to remove ensuring to click on the letter of the column to select the entire column(s)

ii. Right click (or Ctrl + click) and select hide

iii. To unhide columns, select the column to the left and the right of the hidden columns (i.e. A and C if column B is hidden), right click, and select “Unhide”

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download