How can we split a JSON cell into several columns

How can we split a JSON cell into several columns | Clay

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
To split JSON data into multiple columns:
1.
Click on the cell containing the JSON data to open the Cell details panel
2.
Hover over the specific field you want to extract
3.
Click "Add as column" to create a new column with that data [1]
Alternatively, use the Formulas enrichment:
1.
Select "Add Column" → "Formulas"
2.
Describe what you want to extract (e.g., "extract email from JSON")
3.
Clay will generate a formula to pull specific values into separate columns
For complex JSON structures, use dot notation to target nested values like Results.child.grandchild.
If you're experiencing JSON formatting issues, could you copy and paste the JSON into the chat so I can help troubleshoot further?
Pierre L.
·
·
I’ve this [{“company”:“Education Nationale”,“company_domain”:“education.gouv.fr”,“company_id”:null,“end_date”:null,“is_current”:true,“locality”:“Lycée “,”org_id”:8059,“start_date”:“1995-09-01",“title”:“Professeur de Mathématiques”,“url”:“https://www.linkedin.com/school/ministere-education-nationale”}] And I want to split each field in a column
Clay Support
APP
·
·
To split each JSON field into separate columns:
1.
Click on the cell containing your JSON data to open the Cell details panel
2.
Hover over each field you want (company, company_domain, title, etc.)
3.
Click "Add as column" for each field to create individual columns [1]
Alternatively, use the Formulas enrichment:
Select "Add Column" → "Formulas"
Describe the extraction (e.g., "extract company from JSON")
Clay generates a formula to pull each value into separate columns
For nested values, use dot notation like Results.child.grandchild.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with splitting your JSON data into columns, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?

Clay Support
APP
·
·
To split JSON data into multiple columns:
1.
Click on the cell containing the JSON data to open the Cell details panel
2.
Hover over the specific field you want to extract
3.
Click "Add as column" to create a new column with that data [1]
Alternatively, use the Formulas enrichment:
1.
Select "Add Column" → "Formulas"
2.
Describe what you want to extract (e.g., "extract email from JSON")
3.
Clay will generate a formula to pull specific values into separate columns
For complex JSON structures, use dot notation to target nested values like Results.child.grandchild.
If you're experiencing JSON formatting issues, could you copy and paste the JSON into the chat so I can help troubleshoot further?
Pierre L.
·
·
I’ve this [{“company”:“Education Nationale”,“company_domain”:“education.gouv.fr”,“company_id”:null,“end_date”:null,“is_current”:true,“locality”:“Lycée “,”org_id”:8059,“start_date”:“1995-09-01",“title”:“Professeur de Mathématiques”,“url”:“https://www.linkedin.com/school/ministere-education-nationale”}] And I want to split each field in a column
Clay Support
APP
·
·
To split each JSON field into separate columns:
1.
Click on the cell containing your JSON data to open the Cell details panel
2.
Hover over each field you want (company, company_domain, title, etc.)
3.
Click "Add as column" for each field to create individual columns [1]
Alternatively, use the Formulas enrichment:
Select "Add Column" → "Formulas"
Describe the extraction (e.g., "extract company from JSON")
Clay generates a formula to pull each value into separate columns
For nested values, use dot notation like Results.child.grandchild.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with splitting your JSON data into columns, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?