# API or similar to get data from Elastic into Excel

**URL:** <https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697>\
**Category:** Elasticsearch\
**Created:** [March 28, 2023, 9:48am UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697 "2023-03-28T09:48:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![HenrikTide](https://avatars.discourse-cdn.com/v4/letter/h/8baadc/32.png) [@HenrikTide](https://discuss.elastic.co/u/HenrikTide)\
**Post date:** [March 28, 2023, 9:48am UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/1 "2023-03-28T09:48:43Z")

</div>

Is there an API or similar tool available to achieve the goal of getting live data from Elastic into Excel and updating it automatically?

/Henrik

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [March 28, 2023, 11:18am UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/2 "2023-03-28T11:18:07Z")

</div>

Hi @HenrikTide,

Welcome to the community! To confirm, are you just wanting to extract data from Elasticsearch into Excel. By updating automatically do you just mean updates on the data appear automatically in Excel? Or are you expecting updates made in Excel to be applied on the document in Elasticsearch?

---

<div class="post-metadata">

**Author:** ![HenrikTide](https://avatars.discourse-cdn.com/v4/letter/h/8baadc/32.png) [@HenrikTide](https://discuss.elastic.co/u/HenrikTide)\
**Post date:** [March 28, 2023, 11:27am UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/3 "2023-03-28T11:27:30Z")

</div>

Hej Carly

Thank you for your response.  
I want a connection from Elastic to Excel where my data can be fetched, so that I don't have to manually extract my data every time and insert it into Excel. For example, using an API connection that can use Excel's Power Query to transform the data.

/Henrik

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [March 28, 2023, 12:14pm UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/4 "2023-03-28T12:14:23Z")

</div>

Got it. Have you had a look at the [Elasticsearch ODBC driver for Excel](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-client-apps-excel.html) to see if that does what you need?

---

<div class="post-metadata">

**Author:** ![HenrikTide](https://avatars.discourse-cdn.com/v4/letter/h/8baadc/32.png) [@HenrikTide](https://discuss.elastic.co/u/HenrikTide)\
**Post date:** [March 28, 2023, 12:29pm UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/5 "2023-03-28T12:29:52Z")

</div>

Thank you for the help, I will try it.

---

<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:** [April 25, 2023, 12:30pm UTC](https://discuss.elastic.co/t/api-or-similar-to-get-data-from-elastic-into-excel/328697/6 "2023-04-25T12:30:08Z")

</div>

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