# Data explorer CSV into Excel

**URL:** <https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331>\
**Category:** Open Q&A\
**Tags:** power-bi, export, integrations, data-explorer\
**Created:** [February 27, 2024, 1:19pm UTC](https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331 "2024-02-27T13:19:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elenaperez](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/elenaperez/32/38054_2.png) [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Post date:** [February 27, 2024, 1:19pm UTC](https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331/1 "2024-02-27T13:19:49Z")

</div>

Hi,

When trying to export a graph from the data explorer in CSV format, I only get 3 empty columns (metricId, time and value).

![elenaperez_0-1709039787637.png](https://global.discourse-cdn.com/dynatrace/original/2X/4/4432cdd049c32b9a34f477061461602dc6e9dd58.png)

I don’t want to export the static CSV file because I would like to refresh it from Excel directly. With JSON format, I am having problems getting the graph.  
Is there a way to get the CSV file in Excel and be able to update it from there directly?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [February 27, 2024, 1:34pm UTC](https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331/2 "2024-02-27T13:34:55Z")

</div>

Hi Elena,

Maybe [this](https://community.dynatrace.com/post/210655) can be helpful.

Best regards

---

<div class="post-metadata">

**Author:** ![elenaperez](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/elenaperez/32/38054_2.png) [@elenaperez](https://community.dynatrace.com/u/elenaperez)\
**Post date:** [February 27, 2024, 1:55pm UTC](https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331/3 "2024-02-27T13:55:02Z")

</div>

Hi Anton,

No, I added the Api Token like that and it doesn’t give me any errors. But the result is not the data for the graph.  
Regards.

---

<div class="post-metadata">

**Author:** ![PierreGutierrez](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pierregutierrez/32/5934_2.png) [@PierreGutierrez](https://community.dynatrace.com/u/PierreGutierrez)\
**Post date:** [May 3, 2024, 9:36pm UTC](https://community.dynatrace.com/t/data-explorer-csv-into-excel/44331/4 "2024-05-03T21:36:55Z")

</div>

Hi&nbsp;[@elenaperez](https://community.dynatrace.com/user/58054)&nbsp;  
Yes, it’s possible to export data and refresh directly in Excel.

1.- Define your query of Data Explorer.

 ![PierreGutierrez_0-1714771470511.png](https://global.discourse-cdn.com/dynatrace/original/3X/d/3/d307260765e93ad01d641aaf73ba6c7c0b96ded4.png)

2.- Use the API to execute the metric selector:&nbsp;https://{environmentid}.live.dynatrace.com/api/v2/metrics .(&nbsp;[Metrics API - GET metrics — Dynatrace Docs](https://docs.dynatrace.com/docs/shortlink/api-metrics-v2-get-all))

 ![PierreGutierrez_1-1714771958656.png](https://global.discourse-cdn.com/dynatrace/original/3X/5/a/5a010b8dece169b4f7098b9fd4f7676679a320b6.png)

3.- Connect the API in Excel with PowerQuery

With this way you can execute the Metric Selector in Dynatrace API, connect with excel and refresh data

I hope it’s helful 💪