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
-Creating a text field and copy from it to the location field
-Separated all location columns in the excel file: address, city, state
I appreciate any advise.