Importing location data into a sharepoint location column

%3CLINGO-SUB%20id%3D%22lingo-sub-2911361%22%20slang%3D%22en-US%22%3EImporting%20location%20data%20into%20a%20sharepoint%20location%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2911361%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20import%20%3CSTRONG%3Elocation%3C%2FSTRONG%3E%20data%20from%20excel%20into%20a%20SharePoint%20modern%20list%20which%20includes%20a%20%3CSTRONG%3Elocation%3C%2FSTRONG%3E%20type%20column.%3C%2FP%3E%3CP%3EI'm%20able%20to%20copy%20from%20excel%20into%20a%20list%20with%20no%20issues.%20The%20problem%20seems%20to%20be%20the%20%22%3CSTRONG%3Elocation%3C%2FSTRONG%3E%22%20type%20column.%20I%20understand%20that%20it%20does%20a%20validation%20to%20allow%20the%20user%20to%20select%20the%20correct%20address.%20But%20is%20there%20any%20possibility%20I%20could%20mass%20import%20location%20data%20into%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20all%20I%20could%20think%20of%20and%20nothing%20works%20so%20far%3A%3C%2FP%3E%3CP%3E-using%20edit%20in%20grid%20view%3C%2FP%3E%3CP%3E-Power%20automate%3C%2FP%3E%3CP%3E-Creating%20a%20text%20field%20and%20copy%20from%20it%20to%20the%20location%20field%3C%2FP%3E%3CP%3E-Separated%20all%20location%20columns%20in%20the%20excel%20file%3A%20address%2C%20city%2C%20state%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OlgaMelo_0-1635809269371.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322672i1F167245E1271636%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22OlgaMelo_0-1635809269371.png%22%20alt%3D%22OlgaMelo_0-1635809269371.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OlgaMelo_1-1635809280517.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F322673iC58601B7D7F653F5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22OlgaMelo_1-1635809280517.png%22%20alt%3D%22OlgaMelo_1-1635809280517.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20any%20advise.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2911361%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi all,

I'm trying to import location data from excel into a SharePoint modern list which includes a location type column. I've tried different things but so far it is not working.

I'm able to copy from excel into a list with no issues. The problem seems to be the "location" type column. I understand that it does a validation to allow the user to select the correct address. But is there any possibility I could mass import location data into it?

 

 

I've tried all I could think of:

-using edit in grid view

-Power automate

-Creating a text field and copy from it to the location field

-Separated all location columns in the excel file: address, city, state 

 

OlgaMelo_0-1635809269371.pngOlgaMelo_1-1635809280517.png

 

 

I appreciate any advise.

Thank you

 

 

 

 

0 Replies