Data Feed raw data column auto convert in Excel

[DineshRkumar]

Hi Team,,, Yesterday I received raw data from Data feed in zip format. After extracting it, when I opened the file seeing "event_list" column is getting converted into "##########". not able to understand the content behind it. Please suggest here how to extract data from "############"

[Jennifer_Dungan · Accepted solution]

I believe this is just an Excel visual display, not an actual conversion of the content....

See https://superuser.com/questions/65556/excel-displays-for-long-text-whats-wrong

Can you open your raw data feed into a text editor? Notepad, Notepad++, TextEdit, etc

You should see the data as it actually is... 

[DineshRkumar]

However, we can't play much in other editor than Excel.. any better way.. please suggest..

[Jennifer_Dungan]

Oh I get that, Excel is the tool for manipulating data, but you may have to try changing the data formatting to Text or General (to get it back), or as @Ankit_Chaudhary suggested, try and prevent Excel from converting the formatting to start with.

[Ankit_Chaudhary]

During initial load excel ask to convert field type simply select don't convert any you might prevent this.