SharePoint Online

We have a spreadsheet with more than 10 columns, one column is using Hyperlinks with a friendly name, the hyperlink is a connection to a local Share Drive. SharePoint Web Access is retired in SharePoint Online and still supported in SharePoint On-premise. Web App Access has this ability to paste in bulk including the hyperlink. I need this ability to copy multiple rows from the spreadsheet and paste it to a custom list in SharePoint online. Doing this, the hyperlink column is creating a challenge for me, when pasting the rows all the columns are matching with the existing view except hyperlink. for each row I have to go and manually update the hyperlink.