# Urgent help: How to feed live data from Kibana or from Grafana into Excel?

**URL:** <https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228>\
**Category:** Kibana\
**Created:** [August 2, 2021, 1:33pm UTC](https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228 "2021-08-02T13:33:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![BIIntern1](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@BIIntern1](https://discuss.elastic.co/u/BIIntern1)\
**Post date:** [August 2, 2021, 1:33pm UTC](https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228/1 "2021-08-02T13:33:36Z")

</div>

Hi all,  
I have been trying to create Grafana dashboard for visualization and I have been using Excel for data analysis. I figured out it would be best for me to use “What-if-analysis” in Excel to answer my project question but for that I need to show analysis on live data or else it would not make much sense for me to present analysis of the outdated data. I am not sure if its possible but I really want to embed live data into excel sheet to get the most recent data points the way we get in Grafana.

I have access to the two datasets I have been working on through Kibana as well as through Grafana. I could get some data in csv format from Kibana but I want to live stream that data from Kibana into Excel.

I would really appreciate any guidance on this as soon as possible.

-Thanks

---

<div class="post-metadata">

**Author:** ![ghudgins](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ghudgins/32/138532_2.png) [@ghudgins](https://discuss.elastic.co/u/ghudgins)\
**Post date:** [August 2, 2021, 1:55pm UTC](https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228/2 "2021-08-02T13:55:10Z")

</div>

Could try to connect to the underlying data directly in Elasticsearch using the ODBC driver [Microsoft Excel | Elasticsearch Guide [7.13] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-client-apps-excel.html)

---

<div class="post-metadata">

**Author:** ![BIIntern1](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@BIIntern1](https://discuss.elastic.co/u/BIIntern1)\
**Post date:** [August 2, 2021, 4:13pm UTC](https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228/3 "2021-08-02T16:13:36Z")

</div>

Hello @ghudgins ,  
Thanks for the suggestion!  
I opened the link to install the ODBC driver but it seems the instructions were only for the Windows environment and I work on Mac. I googled for the instructions on how to install the ODBC driver on mac but I could not find anything.

I would really appreciate if you could guide me further on this.

-Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 30, 2021, 4:14pm UTC](https://discuss.elastic.co/t/urgent-help-how-to-feed-live-data-from-kibana-or-from-grafana-into-excel/280228/4 "2021-08-30T16:14:36Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.