Sign up for Office 365
Learn more about Office 365
Who can help me with importing contact persons from Excel 2007 (dutch version) into 365. When I save the file with the following headers;
First Name;Middle Name;Last Name;Title;Company Name;Work Phone;Work Phone2;Home Phone;Work Fax;Mobile Phone;Email Address 1;Email Address 2;Address1;Address2;City;State/Prov;Zip/Postal Code;Country;Notes;Web Address
What do I wrong, is it the order of the colums, the header names or the ; as a seperator
Importing it into a normal local Outlook 2007 is also not possible.
This is Justin with Microsoft Office 365 SharePoint Support. Thanks for posting your question.
If the file will not import to either 365 or your Outlook, there must be an issue with the CSV file itself. There are also some restrictions to importing contacts, as listed in the article below. For example, it will illustrate that no more than 1,000 contacts can be import in a single operation and the size of the file cannot exceed 1 MB. Also, have you tried to create a new SharePoint contacts list, connect that list with Outlook and then drag and drop the contacts from the Outlook contacts list to the SharePoint contacts list?
Microsoft Office 365 SharePoint Support
1 out of 1 people found this post helpful.