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?
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
View solution in original post
@danielbb I see you upvoted, and that's great. But could you also click the "accept" button?
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.
