Importing location data into a sharepoint location column

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 

I appreciate any advise.

Thank you