How to Add Dividend Yield to an Excel Stock Data Table
Question details
The user wants to add dividend yield to a live Excel stock-information table by using the Stocks data type or a supported market-data source.

- Product
- Microsoft Excel Stocks data type
- Device & OS
- not provided
- Scenario
- The user maintains a stock-information table and needs dividend yield as a usable field or column.
- Observed behavior
- Dividend yield is not currently available in the table and must be inserted from a linked stock data field or imported from an external financial data source.
Make sure your Microsoft 365 subscription is active, Excel is updated, and your workbook contains a clean column of company names or ticker symbols. Confirm that your region and data provider support the Stocks data type and the Dividend yield field before you start.
Insert Dividend Yield Using the Excel Stocks Data Type
Use this method when your Excel version includes the Stocks linked data type and the Dividend yield field is available from your data provider.
The Stocks data type is available in Microsoft 365 Excel versions that support linked data types. When Excel recognizes the stock entries, it connects to a market data provider and can insert the Dividend yield field directly into the table.
Open the workbook and select the cells that contain company names or ticker symbols, such as MSFT or Microsoft. Make sure the cells are in a clean column without extra text.
Go to the Data tab and click Stocks. Excel converts the selected cells into linked stock entities and shows a stock icon.
Click the Add Column or Insert Data icon next to the selected data, then choose Dividend yield from the field list. If the field is not listed, click the stock icon in a cell and look under the available fields.
Select the inserted Dividend yield column, go to the Home tab, open Number Format, and choose Percentage.
Right-click a stock cell and choose Data Type > Refresh, or go to Data > Refresh All to update values from the data provider.
Import Dividend Yield from a Web or API Source with Power Query
Use this alternative when the Stocks data type is not available in your Excel version or the Dividend yield field is not exposed by your provider.
Use WPS Office as a Free Alternative for Excel Stock Data Workbooks
The Stocks linked data type and Dividend yield field are part of Microsoft 365 Excel and are not included in WPS Office. WPS Office is a free, lightweight alternative that opens .xlsx stock workbooks, preserves formatting, and provides a familiar spreadsheet interface for editing, analyzing, and importing financial data from CSV or other sources.
- 1. Download WPS Office: Visit the official WPS Office download page and install WPS Spreadsheets on your Windows, macOS, Linux, Android, or iOS device.
- 2. Open your Excel stock workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx stock data workbook. Existing static values and formatting remain available.
- 3. Maintain dividend yield data manually or via CSV import: For live or periodic dividend yield, export the data from your financial source as CSV, then use Data > Import to bring it into WPS Spreadsheets.

Frequently Asked Questions
Why is the Dividend yield field missing in my Excel Stocks data type?
The field depends on your Microsoft 365 version, region, data provider, and licensing. Update Excel and check File > Account for the latest version, or use a supported external financial data source.
Can WPS Office insert live stock data with dividend yield?
WPS Office does not include the Microsoft Stocks linked data type. You can open and edit the stock workbook in WPS Spreadsheets, and import periodic dividend yield data from CSV or another source.
How do I refresh stock data in Excel?
Go to Data > Refresh All, or right-click a stock cell and choose Data Type > Refresh. Refresh behavior depends on the Microsoft 365 data provider and your connection.
How should I format dividend yield as a percentage?
Select the dividend yield column, go to Home > Number Format, and choose Percentage. You can also use the shortcut Ctrl+1 and apply the Percentage category.
Can I use Power Query to import dividend yield if the Stocks field is unavailable?
Yes. Go to Data > Get Data > From Web or From Other Sources, connect to a reliable financial data source or API, keep the dividend yield column in Power Query Editor, and load it to your table.




