instructions to import contacts in office 365

After editing the list in Excel, make sure you save it as the same, CSV file, format.

Start by exporting a contact list from Outlook – this way, you will have all the columns you need and you won’t have to map custom fields to be able to import everything correctly.

If you want to edit your CSV file in Excel, follow these two good practices to avoid problems:

A CSV file is the simplest form of a spreadsheet and any program that lets you manipulate spreadsheet data will come in handy if you want to make some changes.

If you are going to use a CSV file to import your contacts into an email client, you can freely modify and update your contacts using Excel. On the other hand, iPhones support import from this file format, while it’s not possible to import via CSV on those devices. However, it’s trickier to handle these files in bulk. It can contain, for example, the contact’s photo.

VCF – a slightly more elaborate file format which is closer to a business card.It’s mostly used for a makeshift backup and migration ( here’s why I’m not overly optimistic about this kind of PST use). PST – usually contains more mailbox item types like emails, tasks, etc.It’s the most common one, since it’s extremely easy to edit contacts included in it and to import them to any email client. CSV – a simple file with an array of contacts with comma-separated values.

Like I already mentioned in the article about exporting Outlook contacts, there are three most common file formats that you can use to import contacts: Before I dive into the import proper, I would like to share a few words about the file types which can be used for contact import.

Instructions to import contacts in office 365