https://community.splunk.com/t5/Getting-Data-In/Embedded-JSON-column-in-excel-looses-data-when-imported-to/m-p/425193#M74540 <P>I am new to Splunk. I have an excel file that has a column which contains embedded JSON. When I Import the csv, I lose some of the data.</P> <PRE><CODE>{"CreationTime":"2018-05-12C413:09:34", "Id":"Y97H080-09D", "Action":"FileAccessed"} {"CreationTime":"2017-03-12C412:10:24", "Id":"D4562T20-09D", "Action":"FileCreated"} {"CreationTime":"2018-08-12C405:18:01", "Id":"9302T20-09D", "Action":"FileDeleted"} </CODE></PRE> <P>For example, action column in Splunk after importing the csv will have no data.</P> <P>Can anyone please help me out?</P> <P>Thank you.</P> Thu, 23 Aug 2018 21:16:42 GMT sarahrdpt 2018-08-23T21:16:42Z https://community.splunk.com/t5/Getting-Data-In/Embedded-JSON-column-in-excel-looses-data-when-imported-to/m-p/425193#M74540 <P>I am new to Splunk. I have an excel file that has a column which contains embedded JSON. When I Import the csv, I lose some of the data.</P> <PRE><CODE>{"CreationTime":"2018-05-12C413:09:34", "Id":"Y97H080-09D", "Action":"FileAccessed"} {"CreationTime":"2017-03-12C412:10:24", "Id":"D4562T20-09D", "Action":"FileCreated"} {"CreationTime":"2018-08-12C405:18:01", "Id":"9302T20-09D", "Action":"FileDeleted"} </CODE></PRE> <P>For example, action column in Splunk after importing the csv will have no data.</P> <P>Can anyone please help me out?</P> <P>Thank you.</P> Thu, 23 Aug 2018 21:16:42 GMT https://community.splunk.com/t5/Getting-Data-In/Embedded-JSON-column-in-excel-looses-data-when-imported-to/m-p/425193#M74540 sarahrdpt 2018-08-23T21:16:42Z