Home > Articles > Home & Office Computing > eBay/Yahoo/Google

  • Print
  • + Share This
This chapter is from the book

Importing Contacts

You can import contacts from other mail programs like Outlook or Hotmail into Gmail as well. All you need is to store your contacts in a .csv (comma-separated value) file (see instructions in the following section) and import that.

When you have a .csv file, follow these steps to import it into Gmail:

  1. From the Contacts page, click the Import link on the top right. Gmail opens the page you see in Figure 5.15.
    Figure 5.15

    Figure 5.15 Importing a Contacts file.

  2. Click the Browse button. Gmail opens a dialog box that lets you browse to the .csv file to upload it.
  3. Browse to the .csv file to upload and select it.
  4. Click the Open button in the dialog box. Gmail closes the upload dialog box.
  5. Click the Import button. Gmail uploads the .csv file and adds it to your contacts.

Creating a .csv File

How do you create a .csv file? The procedure varies by email program. Here are some directions, starting with Microsoft Outlook:

  1. Select the File menu.
  2. Select the Import/Export submenu.
  3. Select the Export menu item. Outlook opens the Export page.
  4. Select Comma Separated Values (Windows).
  5. Select Contacts.
  6. Save the .csv file.

From Outlook Express:

  1. Select the File menu.
  2. Select the Export submenu.
  3. Select the Address Book menu item. Outlook opens an Export dialog box.
  4. Select Text File (Comma Separated Values).
  5. Click the Export button.

Here's a brute-force technique using Microsoft Excel for creating a .csv file of contacts from a Hotmail account:

  1. Sign in to your Hotmail account.
  2. Click the Contacts tab.
  3. Click Print View.
  4. Highlight your contacts by holding down the cursor and dragging it down the list.
  5. Press Ctrl+C to copy the contacts.
  6. Open Microsoft Excel.
  7. Select cell A1 in Excel.
  8. Press Ctrl+V to paste the contacts into Excel.
  9. Select the File menu.
  10. Select the Save As menu item. A Save As dialog box appears.
  11. Select the CSV (comma-delimited) file type.
  12. Enter the name you want to save the .csv file under.
  13. Click Save.

Here's what to do it with Hotmail Live:

  1. Sign in to your Hotmail account.
  2. Click Contact List on the left.
  3. Click the Manage drop-down menu at the top of the Contacts list.
  4. Select the Export item. The Export page appears.
  5. Click the Export Contacts button.
  6. When prompted to open or save the file, click Save.
  7. Select a location to save the file, and click Save.
  • + Share This
  • 🔖 Save To Your Account