Forum Discussion
Upload Contacts to Sharepoint Online
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.
- Jordan_2019Aug 01, 2019Copper Contributor
What is the new way of creating lists from Excel? And how do I do it? Thank you for all your help!
- Jul 31, 2019
We are just full of possibilities
