how to format mac excel spreadsheet for importing into address book

Address Book can read these files and will help automate the import process.

As long as the spreadsheet is well-organized, the entire process should only take a few minutes even if you have hundreds of email addresses to import.

If you dont have Microsoft Excel on your Mac, you can use any computer with Excel to create the CSV file.

Exporting to a CSV 1 Launch Excel and open the worksheet containing the email addresses.

Click the File Save As Format CSV (Comma Delimited).

Type any name you want in the Save As field as long as it ends with the.csv extension.

Click Save. A dialog box may open to warn you that the CSV format will not save all of the features in the current worksheet.

Click Save. 3 Examine the worksheet.

If this isnt there, insert a new first row by clicking the first cell (A1) and then selecting Row from the Insert menu.

Identify each column by typing a title in the first row such as Last Name, First Name, Company, Home Phone, Company, Email etc.

Delete any rows or columns that do not contain information necessary for the address book.

Save the worksheet by selecting Save from the File menu.

Transfer the file via email or with a USB flash drive to the Mac computer if you used a different computer to create the CSV file.

Importing into Address Book 1 Launch Address Book on the Mac computer.

Select a group from the left menu or click the at the bottom left of the window to create a new group.

Select Import from the File menu.

Select the CSV file you created from the Excel spreadsheet and click Open.

Look at the information in the left pane of the Address Book window.

For example First in the Address Book should be paired with First Name in the worksheet.

Click any Address book entry that is not accurately paired with a worksheet heading and change it to the entry you prefer.

For example, Email (other) may be paired with the email address.

You can change this to Email (Work) or Email (Home) as desired.

Ensure the Ignore First Card option is selected.

The right pane of the window should state First Card Contains Column Headers.

Click the right arrow button to see the first contact.

The right pane shows you how the card will look when you have finished importing.

Make any changes to the individual card by clicking the information in the right pane.

Make any changes to all cards by selecting a new Address Book entry in the left pane.

Click the right arrow button again to review additional cards.

The data is imported into the selected Group of your Address Book.

Photo Credits JupiterimagesPixlandGetty Images About the Author A published author and professional speaker, David Weedmark has advised businesses and governments on technology, media and marketing for more than 20 years.

He has taught computer science at Algonquin College, has started three successful businesses, and has written hundreds of articles for newspapers and magazines throughout Canada and the United States.

Related How to Export NeatReceipts Contacts to Mac Contacts How to Make a Business Card Using Microsoft Office 2007 How to Open a.Cbk File How to Change to Business Cards in Word How to Add Business Cards to Send With Emails in MS Outlook How to Fix an SDXC Card on a Mac Most Popular How to Make a Card in Adobe Photoshop CS5 How to Change What Siri Calls You How to Design Business Cards in OpenOffice How to Connect SanDisk Adapter to a Computer How to Format a Picture Card to a Cellphone Trending Now 1 How to Export NeatReceipts Contacts to Mac Contacts 2 How to Make a Business Card Using Microsoft Office 2007 3 How to Open a.Cbk File 4 How to Change to Business Cards in Word Most Popular 1 How to Add Business Cards to Send With Emails in MS Outlook 2 How to Fix an SDXC Card on a Mac 3 How to Make a Card in Adobe Photoshop CS5 4 How to Change What Siri Calls You 5 How to Design Business Cards in OpenOffice Logo Return to Top About Privacy Notice Your California Privacy Rights Interest Based Ads Terms of Use Our Company Careers Advertise with Us Ad Choices Contact Customer Service Newsroom Contacts Connect Email Newsletter Facebook Twitter Pinterest Google Instagram Subscribe iPad app HoustonChronicle.com Houston Chronicle Archives eEdition Demo Todays eNewspaper Hearst Newspapers Copyright 2020 Hearst Newspapers, LLC.

How To Format Mac Excel Spreadsheet For Importing Into Address Book