Upload Contacts to Sharepoint Online

%3CLINGO-SUB%20id%3D%22lingo-sub-781564%22%20slang%3D%22en-US%22%3EUpload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781564%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20way%20to%20upload%20my%20CSV%20contact%20file%20that%20I%20exported%20from%20Outlook%2C%20to%20SharePoint%20online.%20Any%20solutions%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-781564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781632%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361629%22%20target%3D%22_blank%22%3E%40Jordan_2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20-%20Can%20you%20be%20a%20bit%20more%20precise%20as%20to%20what%20you're%20trying%20to%20do%3F%3C%2FP%3E%0A%3CP%3EDo%20you%20want%20to%20import%20them%20in%20a%20SharePoint%20list%3F%20Do%20you%20want%20them%20to%20be%20contacts%20in%20the%20tenant%3F%20....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781739%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781739%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20a%20SharePoint%20list%20would%20be%20fine.%20I've%20tried%20to%20explore%20with%20the%20SharePoint%20contacts%20app%20but%20had%20no%20success.%20I%20am%20just%20looking%20for%20ways%20to%20store%20contacts%20in%20SharePoint%20that%20came%20from%20Outlook.%20I'm%20not%20opposed%20to%20any%20solution.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34858%22%20target%3D%22_blank%22%3E%40Veronique%20Lengelle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782038%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782038%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361629%22%20target%3D%22_blank%22%3E%40Jordan_2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20top%20of%20my%20head%2C%20you%20could%20use%20%3CSTRONG%3E%3CEM%3EMicrosoft%20Access%3C%2FEM%3E%3C%2FSTRONG%3Eor%20%3CEM%3E%3CSTRONG%3EPowerShell%20PnP%3C%2FSTRONG%3E%3C%2FEM%3Eto%20do%20this%2C%20but%20using%20Access%20is%20probably%20the%20most%20user-friendly%20way%20to%20do%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E1)%3C%2FSTRONG%3EConvert%20your%20CSV%20file%20to%20an%20Access%20database%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20Open%20Access%20%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20New%20(blank)%20database%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20New%20Data%20Source%20(in%20the%20ribbon)%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20Choose%20%3CSTRONG%3E%3CEM%3EFrom%20File%3C%2FEM%3E%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20%3CSTRONG%3E%3CEM%3EText%20File%3C%2FEM%3E%3C%2FSTRONG%3E%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20Browse%20to%20your%20CSV%20file%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B*%20Select%20your%20preferences%20for%20the%20rest...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E2)%3C%2FSTRONG%3EModify%20the%20records%20in%20the%20Access%20database%20(%3CEM%3Ei.e.%3A%20Remove%20columns%20you%20don't%20want%3C%2FEM%3E)%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3E3)%3C%2FSTRONG%3EExport%20to%20SharePoint%20List%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20579px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125107i3CFE7BB2D13F26CB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ExportToSPList.png%22%20title%3D%22ExportToSPList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20columns%20will%20be%20created%2Fadded%20for%20you%20in%20the%20SharePoint%20List%3CBR%20%2F%3E%3CEM%3EPS%3A%20You%20may%20need%20to%20remove%20the%20%22Title%22%20column%20from%20the%20Access%20database%20to%20avoid%20conflicts%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWorks%20fine%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20837px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125108i7214C9F761F38BCB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ContactsInSPO.png%22%20title%3D%22ContactsInSPO.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheers%3C%2FP%3E%0A%3CP%3EV.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782114%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782114%22%20slang%3D%22en-US%22%3EA%20more%20easy%20way...save%20the%20CSV%20file%20as%20Excel%20file%2C%20store%20the%20Excel%20file%20in%20one%20of%20the%20sites%20you%20have%20access%20to%20and%20then%20use%20the%20new%20way%20of%20creating%20lists%20from%20Excel%20to%20create%20a%20list%20based%20on%20your%20Excel%20file%20%3B)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782289%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20just%20full%20of%20possibilities%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783979%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783979%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20new%20way%20of%20creating%20lists%20from%20Excel%3F%20And%20how%20do%20I%20do%20it%3F%20Thank%20you%20for%20all%20your%20help!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784363%22%20slang%3D%22en-US%22%3ERe%3A%20Upload%20Contacts%20to%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784363%22%20slang%3D%22en-US%22%3EHere%20you%20go%3A%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-SharePoint-Blog%2FCreate-SharePoint-lists-from-Excel-or-other-lists%2Fba-p%2F533395%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FMicrosoft-SharePoint-Blog%2FCreate-SharePoint-lists-from-Excel-or-other-lists%2Fba-p%2F533395%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,

 

I am looking for a way to upload my CSV contact file that I exported from Outlook, to SharePoint online. Any solutions? Thanks!

7 Replies
Highlighted

@Jordan_2019 

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? ....

Highlighted

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.

@Veronique Lengelle 

Highlighted

@Jordan_2019 

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

 

ExportToSPList.png

 

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 :smile:

 

ContactsInSPO.png

 

Cheers

V.

Highlighted
A more easy way...save the CSV file as Excel file, store the Excel file in one of the sites you have access to and then use the new way of creating lists from Excel to create a list based on your Excel file ;)
Highlighted

@Juan Carlos González Martín 

We are just full of possibilities :lol:

Highlighted

What is the new way of creating lists from Excel? And how do I do it? Thank you for all your help!

@Juan Carlos González Martín