Jul 31 2019 07:47 AM
Hello,
I am looking for a way to upload my CSV contact file that I exported from Outlook, to SharePoint online. Any solutions? Thanks!
Jul 31 2019 08:08 AM
Hi - Can you be a bit more precise as to what you're trying to do?
Do you want to import them in a SharePoint list? Do you want them to be contacts in the tenant? ....
Jul 31 2019 08:48 AM
I think a SharePoint list would be fine. I've tried to explore with the SharePoint contacts app but had no success. I am just looking for ways to store contacts in SharePoint that came from Outlook. I'm not opposed to any solution.
Jul 31 2019 10:19 AM
On the top of my head, you could use Microsoft Access or PowerShell PnP to do this, but using Access is probably the most user-friendly way to do it.
1) Convert your CSV file to an Access database
* Open Access
* New (blank) database
* New Data Source (in the ribbon)
* Choose From File >> Text File
* Browse to your CSV file
* Select your preferences for the rest...
2) Modify the records in the Access database (i.e.: Remove columns you don't want)
3) Export to SharePoint List
The columns will be created/added for you in the SharePoint List
PS: You may need to remove the "Title" column from the Access database to avoid conflicts
Works fine
Cheers
V.
Jul 31 2019 11:13 AM
Jul 31 2019 01:01 PM
We are just full of possibilities
Aug 01 2019 08:00 AM
What is the new way of creating lists from Excel? And how do I do it? Thank you for all your help!
Aug 01 2019 10:31 AM