you can use this script I wrote for one user There's a way to import photos on Google sheet, in such a way that i have the link to the photo (with. jpg)? - #4 by Grzesiek2010 it just extracts all links in your sheet, but be careful I didn't test it much so I would recommend making a copy of your sheet just in case.
Also, what happened with the date formatting and the start and end date? they are changed and not only formatting is changed
I have no idea I'll investigate it.