Get a stock quote

To insert a stock price into Excel, you first create a linked record. Then you can use another column to extract the stock price from the linked record itself.

Note: This feature is being made available to customers on a gradual basis over several days or weeks. It will first be available to Office Insider participants, and later to Office 365 subscribers. If you are an Office 365 subscriber, make sure you have the latest version of Office.

1. Type data, create a table

Cells with stock ticker symbols

Type some ticker symbols, company names, or fund names into some cells. Then select those cells and create an Excel table by clicking Insert > Table. If your data has column headers, select the My table has headers checkbox.

2. Select cells

Cells with stock ticker symbols selected

Now select the cells that contain ticker symbols, company names, or fund names.

3. Click Data > Stocks

Data tab, Stocks and Geography buttons

On the Data tab, click Stocks.

4. Linked records appear

Cells converted into linked records showing stock icons

If Excel finds a match between the text in the cells, and our online sources, it will convert the text to linked records. You'll know they're linked records if they have this icon: Linked record icon for Stock .

4. Click the Add Column button

Cursor clicking Add Column and selecting Price from field list

Click the Add Column button Add Column button , and then click Price.

5. Price appears

Stock prices appear in new column

Excel will extract a value from the linked record's Price field. Click the Add Column button again Add Column button to add other helpful fields like Last Trade Time, Previous Close, Exchange and so on.

Important: Stock information is delayed, provided "as-is", and is not for trading purposes or advice. See About our data sources for more information.


  • To see all of the fields available for a company or fund, click the stock icon ( Linked record icon for Stock ) or select the cell and press Ctrl+Shift+F2.

  • You can also write formulas that reference linked records.

  • If you see Question mark icon instead of an icon, then Excel's having a hard time matching your text with a record in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find a matching record. Or, click Question mark icon and the Record Selector pane will appear. Search for a record using a keyword or two, and then click Select.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.