To import Stock Prices into Google Sheets, use the File menu and select import. Then, upload your CSV file. Here’s a video I made that shows the whole process.
Table of Contents
Where to Find Historical Stock Prices
While there are many places you can go to find up-to-date stock prices, I prefer to pull all of the data into a CSV file. That makes the rest of the import and data analysis much easier.
To find a CSV with historical stock prices, I use MarketWatch.
For today, let’s focus on RDDT. It’s still a new stock, as they just launched their IPO, and it might be fun to see what happens.
Here’s the page I used for this example.
Note that you can choose start and end dates for this table, too. We’re limited when it comes to RDDT because the IPO was more recent than the start date. That’s why this table only shows dates back to March 21st.
Other Places to Find Historical Stock Data
There are other places to find historical stock prices, but not all of them allow you to export the data to CSV. If you want to follow along with this example using another source, here are a few other places where I found RDDT’s IPO stock data.
- NASDAQ (Has an export option)
- Yahoo Finance (No export option)
- New York Stock Exchange (No export option)
If I didn’t use MarketWatch, I’d use NASDAQ. Both offer the ability to export your data into a CSV file. That’s what I use to upload historical stock prices.
Importing Stock Data into Google Sheets
Now that you’ve got your CSV file with historical stock prices, you can easily import them into Google Sheets.
To do this, click the FILE menu and then click “import”.
You’ll be prompted with a window where you can drag your CSV file into Google Sheets.
Here’s where to find it. Remember to click the upload tab so you get the option.
Not a fan of drag-and-drop? You can also use the “browse” button to manually select your file.
The next thing you’ll need to do is complete the data import. Here’s what you’ll see:
You don’t need to change the import location or separator type. And leave the box checked, so Google Sheets can automatically convert text to dates.
If you want to replace your current sheet with the newly imported data, you can do that too. Just change the “import location” dropdown.
That’s optional though.
So click “Import Data” and you’ll see everything pop up in your spreadsheet.
Formatting Stock Data in Google Sheets
If you imported the CSV file with all of your historical stock data, you should see something like this.
It already looks pretty good, right? But we can make it look even better.
My video shows how to add a stock chart, built around the data you pulled in. You can also start using formulas, adding columns, and otherwise evaluating the data.
Evaluating Stock Data in Google Sheets
The best part about pulling historical stock data into your own spreadsheet is the ability to quickly evaluate it.
Formulas in Google Sheets help you quickly find the average open price, the median close price, or volume trends. They can also help you build much more complex dashboards.
For example, you might want to use my guide on comparing columns. You could also highlight data to specifically highlight prices above the median. I made a whole article about conditional formatting, which should help you get started.
Conclusion
I hope you found this helpful. I wanted to show how quickly you could pull in data from the stock market. And this is just one way to do that. Remember that you can perform much more complicated evaluations with this data.
Consider using Python if you want to scrape data with even more depth across a wider variety of sites.
