topic Re: How can we safely export raw data to excel? in Knowledge Management

How can we safely export raw data to excel?

danielbb — Tue, 05 Nov 2019 15:30:48 GMT

When we export data to excel, some of rows break due to the raw data. So, I guess there are commas in the raw data. Is there a clean way to ensure that the raw data doesn’t break the excel csv format?

Re: How can we safely export raw data to excel?

adonio — Tue, 05 Nov 2019 15:37:04 GMT

output to CSV and convert to Excel ...
or use teh Splunk Excel Export app https://splunkbase.splunk.com/app/760/
many answers here:
https://answers.splunk.com/answers/417166/how-to-export-a-report-in-splunk-and-open-it-in-ex.html
https://answers.splunk.com/answers/710943/exporting-data-from-splunk-into-excel.html
https://answers.splunk.com/answers/43442/how-to-export-logs-to-excel-or-text-file.html

hope it helps

Re: How can we safely export raw data to excel?

adonio — Tue, 05 Nov 2019 15:58:07 GMT

@danielbb I see you upvoted, and that's great. But could you also click the "accept" button?

Re: How can we safely export raw data to excel?

danielbb — Tue, 05 Nov 2019 16:43:58 GMT

About -

-- output to CSV and convert to Excel ...

I exported with format of CSV and saved it using notepad. I got the same issue when opening with Excel.