Excel Logo on a gray background

If you need stock market data for your spreadsheet, you can save time and get up-to-date information with the built-in Stocks data type in Microsoft Excel. Here’s how to populate your sheet with details like ticker symbols, market caps, previous close, and more.

Add Stock Data to Your Excel Sheet

To use the Stocks data type in Microsoft Excel, you only need an internet connection and a bit of your own data to start.

Open your spreadsheet and type a piece of information, like a company name or stock symbol. With the cell still selected, open the “Data” tab, and then click “Stocks” in the “Data Types” section of the ribbon.

Click Data then Stocks in Data Types

After a few seconds (depending on your internet connection), you might see the “Data Selector” sidebar open on the right. This happens when your item can’t be found or more than one stock with that name is available.

Click “Select” under any of the available options in the sidebar.

Stocks Data Selector

If you click away from the cell that contains your initial data, just select it again, and then click the small Insert Data icon that appears next to it. A long, scrollable list containing all the stock market details you could possibly need will appear.

Click Insert Data to View a List

Choose the information you want to include and it will pop into the cell at the right. You can continue adding details for the stock in this same way. Any additional details you choose will populate in the subsequent cells to the right.

You can also add column headers to identify the data you include. At any time, though, you can just click the cell containing an item to see what it is in the Formula Bar.

Stocks Data Detail in Formula Bar

View the Data Type Card

The scrollable list of details for a stock is helpful, but you can also view this same data in a card format. Just right-click the cell containing the company or stock you first typed, and then select “Show Data Type Card” from the menu that appears.

Click Show Data Type Card

You can then see those same details in an easy-to-read snapshot. You can also drag the bottom-right corner to enlarge the card if necessary. To add move information from the card to your sheet, just hover your cursor over that piece of data, and then click the Extract to Grid icon.

Click Extract to Grid to Add Data

Refresh the Stocks Data

Like the Geography data type in Microsoft Excel, the Stocks data type retrieves information from an online source. This means you can update it without opening a web browser.

To do so, just right-click the cell that contains the company name or stock symbol, and then select Data Type > Refresh from the menu that appears.

Click Data Type then Refresh

Don’t See the Stocks Feature?

If you don’t see the Stocks data type in Microsoft Excel, make sure your system meets the following requirements:

  • You’re using Excel for Microsoft 365: Microsoft might add this feature to additional versions in the future, but for now, you’ll have to use this one.
  • You’ve updated to the latest version of Office: Microsoft is rolling out this feature gradually, so you might have to wait a bit. Just keep checking for new versions of Office.
  • English is set as the editing language in Office: Excel’s data types are only available if you’ve done this. You can learn how to change it in Microsoft Word here, and this will also change it in Excel.

RELATED: How to Change the Language in Microsoft Word

Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.