Import CSV file data to SharePoint Contact List

%3CLINGO-SUB%20id%3D%22lingo-sub-907912%22%20slang%3D%22en-US%22%3EImport%20CSV%20file%20data%20to%20SharePoint%20Contact%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907912%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20would%20like%20to%20Import%20CSV%20file%20data%20to%20our%20SharePoint%20Contact%20List.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20don't%20like%20to%20use%20the%20Import%20Spreadsheet%2C%20we%20need%20to%20import%20only%20the%20existing%20SharePoint%20Contact%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20we%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-907912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907960%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20CSV%20file%20data%20to%20SharePoint%20Contact%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383629%22%20target%3D%22_blank%22%3E%40Jeyganesh%3C%2FA%3E%26nbsp%3Btry%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FAdd-SPOListItemsFromCSV-76077b14%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FAdd-SPOListItemsFromCSV-76077b14%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-907961%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20CSV%20file%20data%20to%20SharePoint%20Contact%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-907961%22%20slang%3D%22en-US%22%3EAlternatively%2C%20see%20here%20-%20%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2F3-ways-import-excel-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepointmaven.com%2F3-ways-import-excel-sharepoint%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909416%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20CSV%20file%20data%20to%20SharePoint%20Contact%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909416%22%20slang%3D%22en-US%22%3EFlow%20is%20also%20an%20option.%20You%20can%20read%20a%20csv%20saved%20to%20OneDrive%20or%20Sharepoint%20location%20which%20you%20can%20loop%20through%20the%20rows%20and%20create%20list%20items%20for%20each%20using%20the%20data%20from%20the%20csv.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Contributor

We would like to Import CSV file data to our SharePoint Contact List. 

 

We don't like to use the Import Spreadsheet, we need to import only the existing SharePoint Contact list.

 

How can we do this?

3 Replies
Flow is also an option. You can read a csv saved to OneDrive or Sharepoint location which you can loop through the rows and create list items for each using the data from the csv.