How can we safely export raw data to excel?

[danielbb]

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?

[adonio · Accepted solution]

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

[adonio]

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

[danielbb]

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.