IEX Cloud now offers a plug-in for Excel called "IEX Cloud Stock Data." This product is currently in early beta.

The IEX Cloud Stock Data application makes it easy to connect real-time and historical financial data into Excel, including U.S. stock prices, financials, and more. Get started by downloading the application on Microsoft AppSource. Learn more in our help center here.


Excel provides the Webservice function to import data into a cell. We support this in endpoints like quote, stats, financials, cash-flow, balance-sheet, income, and dividends.


This will pull just the latest price for Apple

IEX Cloud provides an example Excel file that can be used to see how the Webservice function works. Download it here - the Excel webservice function only works on Excel for Windows.

Please note, the highlighted column for latestUpdate is a formula that converts the Unix timestamp into an excel date/time. To get this to work you’ll have to put your token in column B1. And don’t forget that you need to refresh the workbook to update (CTRL + ALT + F9)

Google Sheets

Google Sheets provides IMPORT functions to populate cells with data.

This will pull just the latest price for Apple

Next earnings report date for Apple

CSV Files

You can also return most endpoints as CSV by passing a query parameter of format=csv.

Did this answer your question?