We don't have an official Excel library. You can get live market data in Excel using the Kite Connect API by integrating it through third-party tools by writing custom code in Python or VBA that connects to Kite's WebSocket API.
Can I use paid Kite Connect live/historical data in a private, non-shared Google Sheet or Apps Script dashboard for my own account only, with no redistribution?
You may use Kite Connect’s live or historical data within a private setup, such as a personal Google Sheet or Apps Script dashboard, provided it is strictly for your own use and not shared or redistributed in any form.
Please note that data obtained via Kite Connect APIs is intended for personal use only and should not be displayed publicly or made accessible on any external platform. Any such usage would be in violation of exchange data vending guidelines.
Please note that data obtained via Kite Connect APIs is intended for personal use only and should not be displayed publicly or made accessible on any external platform. Any such usage would be in violation of exchange data vending guidelines.
https://github.com/marketcalls/OpenAlgo-Excel
Install OpenAlgo + Configure Zerodha API Credentials and + Install Excel Addin
Start using Realtime Streaming Data inside Excel suppots 35+ functions like placeorder, ltp, quotes, depth etc