HomeNewPandaContacts How-To's and Help TopicsHow do I Export my contacts from.....

4.29. How do I Export my contacts from.....

Updated 01.14.16

So you're trying to get your data into NewPanda, but don't know how to get it out of wherever it currently lives, huh?  Well, while we will never claim to be tech support for (or even remotely knowledgeable about) any other product than ours, we do have basic instructions for some other programs you may use. 

Of course, please remember the following:

  1. We claim no responsibility for the accuracy of the instructions herewith as we did not "create" them.
  2. We cannot provide technical support for any non-NewPanda contact manager products or address books.
  3. If you notice any of the instructions herewith are incorrect, please let us know, and if possible, send us the correct ones!  =)
  4. If you have instructions for another program that may be helpful, send 'em on in!  Be sure to let us know which program the instructions are for.

Once you've got the data exported, follow the instructions in our Importing / Exporting Contacts page to import your data!

Apple (Mac) Address Book - First, let us caution you (in case you don't already know) that your Apple Address book does not have an Export feature. A forum contributor offers the following instructions; however we can't guarantee what kind of additional manipulation will be necessary when copy/pasting your Mac Address Book contact data using the instructions herewith:

Instead of using File > Export, you can do this.

If you have Numbers 2.3:

Select multiple contacts in Contacts (you can drag all contacts into a new group and select them all from that group) and drag them to the Numbers 2.3 canvas.  Then File > Export > CSV...

If you have Numbers 3:

Select multiple contacts in Contacts, command-c to copy, click once in a cell of an existing table, and command-v to paste.  Then in Numbers 3 File > Export to  > CSV...

If this doesn't work or the results are poor, you will need to use a separate utility to get your data exported.  We've heard good things about several utilities, but please understand that you use them at your own risk:

Gwenhiver.net Export Utility - this helps you export data into a .txt file.  See instructions below for converting to a .csv file

Apple Export Utility - exports into a .csv file.  We still request that you carefully look at the exported data to be sure it looks right and can be mapped to the NewPanda fields available to you BEFORE importing.

If your data is now in .csv or .txt format:

  1. Open the file through Microsoft Excel (right click, choose OPEN or OPEN WITH, then Excel)
  2. Verify that column headers are present (like "First" "Last" "MobilePhone" etc.).  You can name your columns anything you like, just as long as you know what the headers mean when mapping to our system. 
  3. Please note that the import fields in your NewPanda tools may not exactly match the fields in your Apple address book, and you may have to do some formatting in Excel to get your data "in shape" before importing into our system.  Be SURE to SAVE OFTEN while working with your data. 
  4. If your data export program does not offer duplicates removal, we encourage you to sort your data by Name, Address and Email Address to remove duplicates before importing. Our system will try to detect duplicates upon the import process, but an exact match is required either for First AND Last name, OR email address.
  5. Once you're done verifying and formatting, save the file once more.  THEN, choose File, then Save As from the menu options.
  6. Choose the location to which to save your file.   Be sure to save it where you can easily locate it, like your desktop or your "My Documents" folder.  
  7. Enter a name for your datafile.  You will want to remember or write down the file name since you will need to browse for it when importing into your NewPanda system.
  8. From the Save as Type menu, select CSV (Comma delimited).  Click Save.

Comcast - click here to view instructions for exporting from this program

Entourage - To export a tab-delimited text file from Entourage:

  1. Open Entourage
  2. Select "Export" from the "File" menu
  3. Select "Local Contacts to a list (tab-delimited text)"
  4. Click the "Next" arrow
  5. Choose a filename and a place to save the file (for instance, "Contacts.txt" on the Desktop), then click "Save"
  6. Click "Done" in the confirm dialog

Facebook - Click here to view Facebook's page about exporting your Friends list into .CSV format.

Gmail - Click here to view Gmail's instructions for exporting your Gmail contacts into .CSV format (choose OUTLOOK option).

iPhone / iPad / iPod - Click here to view instructions to export your data from iPhone.  You'll be required to download,
               install and run iTunes in order to do this (hey, we don't make the rules).

LinkedIn - To export a CSV file from LinkedIn:

  1. Sign into LinkedIn
  2. Visit the Address Book Export page
  3. Select "Microsoft Outlook (.CSV file)" and click "Export"
  4. Choose a filename and a place to save the exported file (for instance, "Contacts.csv" on the Desktop)

Mac OS X Address Book - To export a vCard file from Mac OS X Address Book:

  1. Open Mac OS X Address Book
  2. Select the contacts you would like to export
  3. Select "Export vCards..." from the File menu
  4. Choose a filename and a place to save the file (for instance, "Contacts.vcf" on the Desktop), then click "Save"
  5. Open the new file and SAVE IT AS A CSV file to import into NewPanda

                 Here's some free software for converting .ABBU files to .CSV.  We can't vouch for it, but hey, it IS free.

Outlook - Check the latest instructions from Microsoft here: https://support.office.com/en-us/article/Export-contacts-from-Outlook-10f09abd-643c-4495-bb80-543714eca73f#ID0EAADAAA=2016,_2013 

To export a CSV or tab-delimited text file from Outlook:

  1. Open Outlook
  2. Select "Import and Export" from the File menu
  3. When the wizard opens, select "Export to a file" and click "Next"
  4. Select "Comma separated values (Windows)" and click "Next"
  5. Select the Contacts folder you would like to export and click "Next"
  6. Choose a filename and a place to save the file (for instance, "Contacts.csv" on the Desktop), then click "Next"
  7. Confirm what you are exporting: make sure the checkbox next to "Export..." is checked and click "Finish"

Still having trouble with Outlook? Try this.

Trying to export Outlook 2007 or 2010 categories? Try this.  (Outlook 2003 does not support export of Categories)

Top ProducerŽ 7i - Click here to view the instructions for this application

Top ProducerŽ 8i - Click here to view the instructions for this application

Palm Desktop - To export a CSV file from Palm Desktop:

  1. Open Palm Desktop
  2. Display your contact list by clicking the "Addresses" icon on the lefthand side of the screen
  3. Select "Export" from the "File" menu
  4. When the dialog box opens, enter a name for the file you are creating in the "File name:" field; select "Comma Separated" in the "Export Type" pulldown menu; be sure to select the "All" radio button from the two "Range:" radio buttons
  5. A second dialog box "Specify Export Fields" opens. Leave all of the checkboxes checked, and click "OK"

Windows Address Book - To export a CSV file from Windows Address Book:

  1. Open Windows Address Book
  2. From the "File" menu, select "Export", then "Other Address Book..."
  3. When the "Address Book Export Tool" dialog opens, select "Text File (Comma Separated Values)" and click "Export"
  4. Choose a filename and a place to save the file (for instance, "Contacts.csv" on the Desktop) and click "Next"
  5. Click to select the check boxes for the fields that you want to export, and then click "Finish". Please be sure to select the email address and name fields
  6. Click "OK" and then click "Close"

Windows Mail - To export a CSV file from Windows Mail:

  1. Open Windows Mail
  2. From the menu options, choose File, then Export from the sub-menu, then Windows Contacts  from the sub-sub-menu.
  3. The Export Windows Contacts dialogue box will open.  Choose CSV (Comma Separated Value),  then click Export.
  4. The CSV Export dialogue box will open.  In the Save Exported File As field, enter a name for your file.  Name your file something you'll remember, or jot down your file name on a note pad.
  5. Now browse for the location to which to save your file.  Be sure to save it where you can easily locate it, like your desktop or your "My Documents" folder.  Jot the location down if necessary.
  6. Click Save.  The CSV Export dialogue box will now display the file name and location you've chosen for your data.  Verify the information is correct, and click Next to continue. 
  7. You will now need to select the information you'd like to export for each contact.  Check the boxes for the information you'd like to bring into your NewPanda database (we suggest AT LEAST "First  Name," "Last Name," and "E-mail Address").  Please note that all fields in your Microsoft Window Mail may not perfectly match the fields in your NewPanda database.  Click Finish
Yahoo Mail

Other - Many email clients and PIM programs allow contacts to be exported to a file. NewPanda supports .CSV (Comma Separated Value) files, which are virtually universal.  Please check your email client's documentation to see whether contact export to .CSV format is supported. If it's not, you may be able to export your data into some other format and then SAVE IT AS A .CSV FILE.

Related Pages
This page was: Helpful | Not Helpful