You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Creating A CSV File in Numbers to Import Into Outlook Contacts on An Imac

Have created and edited some 500 or so contacts into a numbers spreadsheet in a CSV format - names -addresses -email phone -etc - The goal is to import these details in a 365 outlook contacts on a new iMac - When imported it copies over the names but all other details are in a the notes area not in the correct fields within the outlook contacts ? Any suggestions please ?

iMac 24″, macOS 14.6

Posted on Oct 22, 2024 2:15 AM

Reply
2 replies

Oct 22, 2024 9:28 AM in response to Grant-WM

You need to make sure the header row (the first row) contains the correct labels for the columns, so that the app know how to import the data.


Sometimes it can be difficult to ascertain the exact headers, for example, some applications may require 'First Name', others may use 'Firstname'. Similarly, with addresses, there may be localized issues where, for example, Contacts requires 'Zip Code' even though the field may be known as 'Postal Code' or some such in your region.

Even more complicated is how it handles multiple addresses. For example, Work vs. Home addresses. Maybe 'Address' isn't sufficient to allow the app to interpret the data.


The best approach is to export some existing contacts. This will give you the correct header fields the application expects. You can apply that to your .csv file and should have better luck matching the data to the contacts.

Creating A CSV File in Numbers to Import Into Outlook Contacts on An Imac

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.