[Jiaz]

@mgpai: I've replied to your mail

[mgpai]

Originally Posted by Jiaz

@mgpai: I've replied to your mail

As already explained in my reply. At least the version of excel I am using modifies the format of JSON string and hence fails on import.

[StefanM]

Originally Posted by mgpai

As already explained in my reply. At least the version of excel I am using modifies the format of JSON string and hence fails on import.

@mgpai:
Indeed, Excel can be a pain in the ass with it's automatic format modifications. But you can avoid/circumvent those 'unwanted' Excel features.

BTW I am using Excel 2019, but I have different versions on different machines running.

If you can give me one or two examples (original and modified JSON string, modified by Excel that is) I can check if you can keep Excel from making these modifications.

[Jiaz]

Originally Posted by StefanM

If you can give me one or two examples (original and modified JSON string, modified by Excel that is) I can check if you can keep Excel from making these modifications.

see
mega.nz/file/nUN0DDqD#hxLqY3crccUFtyTbI_Ode7QL-bolZJ6yqx5imElgbhA

"[{\"type\":\"CONTENT\",\"enabled\":true},{\"type\":\"CUSTOM\",\"enabled\":true},{\"type\":\"REFERRER\",\"enabled\":true},{\"type\":\"ORIGIN\",\"enabled\":true},{\"type\":\"CONTAINER\",\"enabled\":true}]"

must remain unchanged. MAX the first/last quotes may be removed but the rest must stay the same/untouched

[StefanM]

Originally Posted by Jiaz

"[{\"type\":\"CONTENT\",\"enabled\":true},{\"type\":\"CUSTOM\",\"enabled\":true},{\"type\":\"REFERRER\",\"enabled\":true},{\"type\":\"ORIGIN\",\"enabled\":true},{\"type\":\"CONTAINER\",\"enabled\":true}]"

must remain unchanged. MAX the first/last quotes may be removed but the rest must stay the same/untouched

Will try to check it tomorrow...

[StefanM]

Originally Posted by StefanM

Will try to check it tomorrow...

First result: Several quotes are missing.
Will try to figure out how to avoid this 'corruption':

[{\type\":\"CONTENT\",\"enabled\":true},{\"type\":\"CUSTOM\",\"enabled\":true},{\"type\":\"REFERRER\",\"enabled\":true},{\"type\":\"ORIGIN\",\"enabled\":true},{\"type\":\"CONTAINER\",\"enabled\":true}]"

Is the above the same corruption that you get?

[StefanM]

Originally Posted by Jiaz

see
mega.nz/file/nUN0DDqD#hxLqY3crccUFtyTbI_Ode7QL-bolZJ6yqx5imElgbhA

"[{\"type\":\"CONTENT\",\"enabled\":true},{\"type\":\"CUSTOM\",\"enabled\":true},{\"type\":\"REFERRER\",\"enabled\":true},{\"type\":\"ORIGIN\",\"enabled\":true},{\"type\":\"CONTAINER\",\"enabled\":true}]"

must remain unchanged.

Got it!
The reason is the typical automatic (formula...) detection in Excel.

Proceed as follows, and no quotation mark will be removed. Nothing will be changed.

1. Set the format of all columns of the Excel Sheet you want to use to text (CTRL A, then: Format Cells... as text).
2. Make sure that in 'Convert Text to Columns Wizard' 'Text qualifier' is set as {none}

That's it! (Separator for 'Text to Columns' is set to TAB by default.)
Now you can can copy any tsv data to that sheet.
E.g. by opening the TSV file in Window Notepad, copying the contents to your clipboard and pasting it in the Excel sheet.