# Kibana Export to CSV Date Period Problem **URL:** \ **Category:** Kibana\ **Created:** [July 2, 2020, 12:28am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557 "2020-07-02T00:28:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![aglush](https://avatars.discourse-cdn.com/v4/letter/a/e8c25b/32.png) [@aglush](https://discuss.elastic.co/u/aglush)\ **Post date:** [July 2, 2020, 12:28am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/1 "2020-07-02T00:28:14Z")
I have noticed the following anomaly (defect?) in **Kibana's** export Query Results to CSV behavior: Export to CSV does not correspond to selection criteria and returned results by the query. For example search for the last 15 min records brings the information on the screen, however an attempt to export the results to CSV ends up with export being totally for the different period. As a regular Kibana user I would expect export results to CSV would be simply exporting the same results returned by saved Kibana query as users see on the screen running that query. Has this been confirmed to be an anomaly, defect or export to CSV required additional "tuning" users do not see straight away? ---
**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\ **Post date:** [July 14, 2020, 7:18am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/2 "2020-07-14T07:18:22Z")
Hi and welcome to our community Could you provide an expample what is displayed on screen via screenshot and what's part of your exported CSV? Many thx & best, Matthias ---
**Author:** ![aglush](https://avatars.discourse-cdn.com/v4/letter/a/e8c25b/32.png) [@aglush](https://discuss.elastic.co/u/aglush)\ **Post date:** [July 14, 2020, 7:57am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/3 "2020-07-14T07:57:24Z")
Hi Matthias, Unfortunately I cann not provide the results due to data being sensitive, however I have found the answer to my question and want to share it with others on this forum: Kibana displays TimeStamp being local time but Export to CSV exports UTS time instead of displayed local one. That is quite misleading it should be the same either in Kibana output on screen and in CSV extract as it is hard to compare constantly keeping in mind time zone difference. In my solution I am applying SQL Server function that converts time to what I need and takes into accout DayLight savings etc, but I am SQL Developer, others may be not, so thay have to deal with this anomaly ---
**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\ **Post date:** [July 14, 2020, 8:04am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/4 "2020-07-14T08:04:16Z")
Thx for sharing, this is a known issue and should be resolved in the future: > > > Kibana version: 7.5.2 > Elasticsearch version: 7.5.2 > Server OS version: ESS > Browser version: Chrome 79.0.3945.130 > Browser OS version: MacOS 10.14.6 > Original install method (e.g. download page, yum,... ---
**Author:** ![aglush](https://avatars.discourse-cdn.com/v4/letter/a/e8c25b/32.png) [@aglush](https://discuss.elastic.co/u/aglush)\ **Post date:** [July 14, 2020, 10:51am UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/5 "2020-07-14T10:51:12Z")
I have another question to ELK community - is there any way to automate extracts from Kibana to CSV files on regular basis? The reason is pretty trivial. I need regular (say daily) extracts from Kibana to CSV so I can pick them up by my scheduled ETL tool and push data into SQL database (SQL Server) ---
**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\ **Post date:** [July 14, 2020, 1:14pm UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/6 "2020-07-14T13:14:58Z")
You can do this with automatic report generation in the way it is described here: [https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html) Best, Matthias ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 11, 2020, 1:15pm UTC](https://discuss.elastic.co/t/kibana-export-to-csv-date-period-problem/239557/7 "2020-08-11T13:15:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.