How to export Yahoo Finance data to CSV or Excel

What You Need Before You Start

📊 Want to easily export Yahoo Finance data?
📥 Download Yahoo Finance Data to CSV/Excel Exporter and save your data in just a few clicks.
⚡ Simple, fast, and perfect for analysis, research, and spreadsheets.
👉 Get the extension now: https://chromewebstore.google.com/detail/yahoo-finance-data-to-csv/kdgipecbgpelldpagmedpjcehpcgjcjf

Exporting data from Yahoo Finance is a straightforward process, but you need to be aware of a few limitations before you begin. Yahoo Finance does not provide a direct, one-click “Export to CSV” button on its main stock or portfolio pages for historical data in all contexts. The method you use depends on whether you want current portfolio holdings, historical price data for a single ticker, or bulk data.

Generally, you need:

A web browser (Chrome, Firefox, Safari, Edge) on a desktop or laptop computer. Mobile browsers may work but the layout and export options are more limited.
A Yahoo account if you want to export your personal portfolio watchlist or holdings.
Basic familiarity with downloading files and opening them in a spreadsheet application like Excel, Google Sheets, or LibreOffice Calc.

How to Export Historical Price Data to CSV

This is the most common use case: you want daily, weekly, or monthly price history for a stock, ETF, or index such as AAPL, SPY, or ^GSPC.

Navigate to the stock page. Go to finance.yahoo.com and search for the ticker symbol in the search bar at the top of the page. Click on the correct result to open its summary page.
Go to the Historical Data tab. On the stock’s summary page, you will see a row of tabs below the main chart and company name. Click the tab labeled Historical Data.
Set your time period. You will see a date range selector. Click the Time Period dropdown to choose a preset (e.g., 1 Month, 3 Months, 1 Year, 5 Years, Max) or click the date fields to set a custom start and end date.
Choose the frequency. Below the date selector, click the Frequency dropdown. Your options typically include Daily, Weekly, and Monthly. Select the one that matches your analysis needs.
Click Apply. This reloads the table with the data matching your criteria.
Click the Download button. Directly above the table of data, on the right side, you will see a button labeled Download Data. It is usually represented by an icon of a downward arrow or the word “Download” next to a small CSV file icon. Click this button.
Open or save the file. Your browser will download a CSV file automatically. The filename is typically the ticker symbol followed by the date range (e.g., AAPL.csv).
Open in Excel. Locate the downloaded file in your Downloads folder or the location your browser saves files. Double-click the file. It should open directly in your default spreadsheet program. If the data appears in one column instead of separate columns, you may need to use Excel’s Text to Columns feature or re-import the file using the Data > From Text/CSV option, ensuring the delimiter is set to comma.

How to Export a Yahoo Finance Portfolio to Excel

Yahoo Finance allows you to create and track portfolios (lists of stocks you own or are watching). You can export the current value and holdings data.

Sign in to your Yahoo account. Ensure you are logged in to the Yahoo account where you have created your portfolios. Click the Sign In button in the top-right corner of finance.yahoo.com.
Open your portfolios. Click on Portfolios (or the user icon and then “Portfolios”) in the top navigation bar.
Select the portfolio you want to export. You may have multiple portfolios. Click on the name of the one you wish to download.
Locate the download option. On the portfolio summary page, look for an export or download button. The exact placement can vary slightly, but it is usually near the top of the table that lists your holdings, often represented by a gear icon or a “More” dropdown menu. Click the More button or the gear icon.
Click Download. From the resulting menu, select Download or Export to CSV. The file will download as a CSV file containing the current holdings data including ticker, quantity, purchase price, current price, and total value.
Open in Excel. As with the historical data, you can double-click the downloaded CSV file to open it in Excel, or use the From Text/CSV import feature for better control over column formatting.

Alternative Methods for Bulk or Automated Downloads

If you need data for many tickers at once or want to automate the process, the web interface becomes inefficient. In those cases, you have a couple of practical alternatives.

Using the Yahoo Finance API (via Python or other tools)

Yahoo Finance historically had an official API, but it has been deprecated and access is now limited and unofficial. Libraries like yfinance (for Python) provide a reliable way to download historical data programmatically. This method is best for users comfortable with basic scripting. You install the library and can download data for multiple tickers, specifying date ranges and frequency, then save the output directly as a CSV file. This avoids manual clicking and is ideal for large datasets or recurring analysis.

Copy and Paste from the Web Table

For a single, small data set where you do not want to download a file, you can manually select the historical data table on the Historical Data page, copy it (Ctrl+C or Cmd+C), and paste it into Excel. Excel typically recognizes the tabular data and pastes it into separate columns correctly. This is useful for a quick snapshot but is not practical for large amounts of data.

Common Problems and How to Handle Them

You may encounter a few issues during the export process. Here is how to address them.

Date formatting issues in Excel. Yahoo Finance CSV files use dates in a specific format (e.g., YYYY-MM-DD). Excel may interpret these as text or show them incorrectly depending on your regional settings. To fix this, after opening the CSV, select the date column, go to the Home tab, click the Number Format dropdown, and choose More Number Formats. Select Date and pick the format that matches your region (e.g., MM/DD/YYYY or DD/MM/YYYY).

Data appearing in one column. This usually means the CSV file was not parsed correctly when you double-clicked it. The best solution is to use Excel’s import feature. Go to the Data tab, click From Text/CSV, select your file, and ensure the delimiter is set to Comma. Excel will preview the correctly split columns before you load the data.

Download button not appearing or not working. Occasionally, a browser extension (especially ad blockers) may interfere with the Yahoo Finance page functionality. Try disabling ad-blocking extensions for finance.yahoo.com or using a private/incognito browser window. If the button still does not work, refreshing the page or trying a different browser usually resolves the issue.

Missing data fields in portfolio export. The downloadable portfolio CSV includes a standard set of fields (ticker, quantity, cost basis, current price, etc.). If you need fields that are not included (such as dividend yield or P/E ratio from the stock summary), you will need to combine the portfolio CSV export with a separate historical data download for the tickers in question.

Frequently Asked Questions

Why does my CSV file show only one column of data when I open it?

This happens when your spreadsheet program does not automatically parse the commas as column delimiters. The solution is to use the “From Text/CSV” import feature in Excel (or equivalent in Google Sheets) and manually specify the comma as the delimiter.

Can I export data for multiple tickers at once from the web interface?

No. The Yahoo Finance web interface only allows you to download historical data for one ticker at a time. To download data for many tickers, you must repeat the process for each one or use a scripting approach with a library like yfinance in Python.

Does the portfolio export include transaction history (buys and sells)?

No. The downloadable portfolio CSV file only provides a snapshot of your current holdings and their current values. It does not include a log of past transactions, trade confirmations, or dividend payments. You would need to maintain that history separately.

Author
Recent Posts

Rino Tota

Writer and Explorer at GloboSoft

Technology enthusiast with extensive experience in the digital world. With a degree in engineering and years of experience in the tech industry, I'm dedicated to exploring the constantly evolving digital world and translating technological advances into a language accessible to everyone.