Exporting Address Book to a spreadsheet
Posted 29 October 2008 - 07:40 PM
A quick look at Numbers help will show other ways that Address book can tie into existing spreadsheets.
Posted 30 October 2008 - 08:10 AM
Posted 31 October 2008 - 02:35 AM
Posted 06 January 2012 - 07:06 PM
1. (optional, but helps) Give your Excel a header row with field names. If those happen to match Address Book field names, it will make a good guess at what matches what.
2. Put your data under those names. Blank cells are no problem. Not everyone has a nickname or a company, for example.
3. Save your Excel file in CSV (comma-separated values) format.
4. Switch to Address Book and select the group where you want the new contacts. Last Import is the only one that won't work. (All Contacts is fine.)
5. Select File>Import (command-O). Navigate to the file you just saved.
6. Make any necessary adjustments to the column mapping in the equivalence panes that show up. Make sure "Ignore first card" is checked if have column headers and you don't want them imported as a contact. You can check the mapping via the navigation arrows at the bottom of the dialogue box. When you're happy with it, click OK.
7. Check the new cards in the Last Import group to confirm that it worked.
Posted 21 December 2012 - 09:01 PM
Get Directmail App (which i s great App anyway)
Go to Addresses
1. Select which group you want to import
2. Highlight the contacts you want to import from that group
3. Customize the fields (remember your field names)
5. Highlight which addresses you want to export
6. Go to Addresses
8 . Open a new Sheet
9. Then import your CSV file to a new excel sheet - follow the steps
Then you can export to excel
There's a few more, just checking