There's an easy way to import historical stock prices into Google Sheets. For example, I evaluated the Reddit IPO. It uses the stock ticker RDDT. I'll show you where to find the data as a CSV file ...

Google Sheets Import XML You may have seen someone turn an XML document into spreadsheet format, thereby making it easier to work with the data.