Updating Data Connections in Excel reports in bulk

We are in the process of moving our reports to SharePoint online from on prem. We have 50-60 excel reports that all point to our on prem data connections and we will need to update them to point to the same data connections online (same type of data, new URL).

Is there any way to update the report connections for the new host other than manually opening each report and updating the connection source to the new online host data connection?

Hopefully this make sense but feel free to ask for clarification.