CVS export

dao · January 21, 2020, 10:33am

Hello,

I have to export a saved search from a dashboard. The CSV is correct but the format of the @timestamp is not OK for my customer because excel does not accept 2020-01-21T07:52:51.000Z which is the format I get

I tried to change the format in the GeneralSettings / Date format without effect

thanks

Elvis_Saravia · January 21, 2020, 11:02am

Hi dao, thanks for taking the time to post here.

What version of Kibana are you using?

dao · January 21, 2020, 1:10pm

Thé latest 7.5.1

Olivier Dao Hodac
FlightWatching

Elvis_Saravia · January 23, 2020, 2:46pm

Hi dao,

I tested it and indeed it is not applying the format from the Advanced Settings. I noticed that it does apply the formatting if I export the results to CSV from the Discover application. This is potentially a bug, I will try to report it.

dao · January 28, 2020, 9:10am

Dear Elvis,

did you reported it? Is it an issue?

best

Elvis_Saravia · January 28, 2020, 10:20am

Hi dao,

I think it is. Do you mind posting the issue using the link below?

dao · January 28, 2020, 2:42pm

done : https://github.com/elastic/kibana/issues/56153

system · February 25, 2020, 2:42pm

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

Topic		Replies	Views
CVS export from saved search kibana gives a array as timestamp Kibana	2	702	June 25, 2020
Date format set in advanced settings not replicated in CSV export from Discover Kibana	3	648	May 6, 2022
Kibana report export CSV file wrong date format Kibana	3	1279	December 26, 2019
Kibana-7.8.1-1. Csv separator doesn't work in the Discovery -> Share -> CSV Reports Kibana	2	1067	October 20, 2020
Kibana Export to CSV Date Period Problem Kibana	6	1469	August 11, 2020

CVS export

Related topics