Extract data from json format and paste to column using python
Given that the data snippet you provided is not a valid json structure I assume that the data is a list with dictionaries in it. Using this assumption, you can extract the values to a nested list using a list comprehension:
data = [
    {
    &quot;id&quot;:&quot;list&quot;,
    &quot;item&quot;:[
        {
            &quot;value&quot;:&quot;Hergestellt in Italien aus 100% reinem Platin-Flüssigsilikon&quot;
        },
        {
            &quot;value&quot;:&quot;Geruchs- und geschmacksneutral&quot;
        },
        {
            &quot;value&quot;:&quot;Kältebeständig bis -60°C&quot;
        },
        {
            &quot;value&quot;:&quot;Inklusive Rezeptbuch und 50 Eisstielen&quot;
        },
        {
            &quot;value&quot;:&quot;spülmaschinengeeignet&quot;
        }
    ],
    &quot;decorators&quot;:[]
    }
]

print([[i[&quot;value&quot;] for i in x[&quot;item&quot;]] for x in data])

# [['Hergestellt in Italien aus 100% reinem Platin-Flüssigsilikon',
#  'Geruchs- und geschmacksneutral',
#  'Kältebeständig bis -60°C',
#  'Inklusive Rezeptbuch und 50 Eisstielen',
#  'spülmaschinengeeignet']]