Knowledge Management

How can we safely export raw data to excel?

danielbb
Motivator

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?

Tags (3)
0 Karma
1 Solution

adonio
Ultra Champion

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

0 Karma

danielbb
Motivator

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.

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...