Batchbook Knowledge Base Import ContactsExport Outlook Contact on Mac to csv for import

Export Outlook Contact on Mac to csv for import

Exporting your Contacts from Outlook on a Mac takes a little more finagling but isn't difficult! Take a look below for step by step instructions on how to get your contacts out of Outlook and into Batchbook!

From Contacts in Outlook - go to Tools

  1. Choose the Tools menu from the Navigation bar.
  2. Select 'Export' from menu

Choose to Export to a list

Choose to Export to a list

Give the file an easy to remember name & Click Save

Give the file an easy to remember name & Click Save

You'll be notified when it's complete

You'll be notified when it's complete

Open a new Spreadsheet & Import file

Use Excel, numbers, openoffice or your favorite spreadsheet program that is capable of making csv. If you have lots of special characters we'd suggest Open Office as it handles them well. Use the prompts to import the information you just exported.

Select to save it as a Text File

Select to save it as a Text File

Choose the File you just exported from Outlook and choose 'Get Data' at bottom

Choose the File you just exported from Outlook and choose 'Get Data' at bottom

Text Import Wizard

You'll be led through the Text Import Wizard to format the data you're importing. Choose that your file data is 'Delimited' and then choose next

Text Import Wizard

Confirm that it is 'tab' delimited and select Next

Confirm that it is 'tab' delimited and select Next

Keep data format as General and click Finish

Keep data format as General and click Finish

Confirm where data should go

If you opened a brand new sheet for the import you should be all set.

Confirm where data should go

You have a handy new Excel file!

You should now have a nice new Excel file of your contact data including headers. Be sure however to turn it into a csv before importing into Batchbook. See below for instructions on turning it into a csv.

Create csv of your Excel file

Select 'Save As' from the File menu

Give the file an easy to remember name and choose 'Comma Seperated Values (.csv)' from the Format option. Click Save.

Click Continue to confirm any formatting changes.

Click continue and you're all set! Now you're ready to import the file to Batchbook. Need help importing to Batchbook? Check out How do I import my contacts into Batchbook?

Click Continue to confirm any formatting changes.