How to Export JSON from a Database Table or Column

Daniel J. · 2025-07-30 13:29:14.036083+00

i’d like to export json from a table / column i’ve created but don’t seem to have that option. Can you help?

Join the Community

How to Export JSON from a Database Table or Column | Clay

8 comments

Sayli G.
·
·
A couple of ways to do that: You can send this data to a different table by Send Table Data (Actions > Send Table Data) If you have a common column in both tables and you wish to map based on that, you can perform a lookup in the destination table and that will automatically pull in all these fields in that column in the destination table for you to extract out again!
👍1
Daniel J.
·
·
what if want to extract the JSON so i can analyze it elsewhere?
Sayli G.
·
·
Hello Daniel! Thanks for reaching out! You can simply click into the cell. The different fields should show up. You can hover over the field you want to extract and an Add to Column option should show up. You can click on that and that should do the trick. When you click into the cell it might look something like this:
(80 kB)
Clay
APP
·
·
You can extract JSON data into a column using our "Extract Values from Data" integration. To set it up: 1. Add a new column to your table 2. Search for "Extract Values from Data" integration 3. In the "Data" field, reference the column containing your JSON 4. Specify what you want to extract in the "Extraction Type" field 5. The integration will output the extracted values into your new column Alternatively, you can use AI formulas by adding a column and choosing "Ask question about items with AI" to extract specific information from existing data.
Source: Extract Values from Data with Clay
Daniel J.
·
·
how can i extract a JSON into a column?
Clay
APP
·
·
Clay doesn't have a direct "Export JSON" option. We only support CSV export. To export your table: 1. Click Actions > Export > Download CSV The CSV export mirrors your Clay table exactly with all column data included. If you need JSON format, you can convert the CSV using external tools after export.
Sources: Export and Download a File Download as a CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University
Hunain F.
·
·
Hey - Daniel J. I can help just try this. Select rows (or use filters if needed) Click three dots (⋯) top-right of table Choose “Export JSON” If JSON not showing: Export as CSV Convert to JSON using convertcsv.com
Clay
APP
·
·
Clay doesn't support JSON export directly. You can only export data as CSV format. To export your table: 1. Navigate to the Actions menu 2. Click Export > Download CSV The CSV export mirrors your Clay table exactly, so all your column data will be included in the downloaded file. You can then convert the CSV to JSON using external tools if needed.
Sources: Download as a CSV [Clay 101] - Clay University Export and Download a File

Loading comments

Sayli G.
·
·
A couple of ways to do that: You can send this data to a different table by Send Table Data (Actions > Send Table Data) If you have a common column in both tables and you wish to map based on that, you can perform a lookup in the destination table and that will automatically pull in all these fields in that column in the destination table for you to extract out again!
👍1
Daniel J.
·
·
what if want to extract the JSON so i can analyze it elsewhere?
Sayli G.
·
·
Hello Daniel! Thanks for reaching out! You can simply click into the cell. The different fields should show up. You can hover over the field you want to extract and an Add to Column option should show up. You can click on that and that should do the trick. When you click into the cell it might look something like this:
(80 kB)
Clay
APP
·
·
You can extract JSON data into a column using our "Extract Values from Data" integration. To set it up: 1. Add a new column to your table 2. Search for "Extract Values from Data" integration 3. In the "Data" field, reference the column containing your JSON 4. Specify what you want to extract in the "Extraction Type" field 5. The integration will output the extracted values into your new column Alternatively, you can use AI formulas by adding a column and choosing "Ask question about items with AI" to extract specific information from existing data.
Source: Extract Values from Data with Clay
Daniel J.
·
·
how can i extract a JSON into a column?
Clay
APP
·
·
Clay doesn't have a direct "Export JSON" option. We only support CSV export. To export your table: 1. Click Actions > Export > Download CSV The CSV export mirrors your Clay table exactly with all column data included. If you need JSON format, you can convert the CSV using external tools after export.
Sources: Export and Download a File Download as a CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University
Hunain F.
·
·
Hey - Daniel J. I can help just try this. Select rows (or use filters if needed) Click three dots (⋯) top-right of table Choose “Export JSON” If JSON not showing: Export as CSV Convert to JSON using convertcsv.com
Clay
APP
·
·
Clay doesn't support JSON export directly. You can only export data as CSV format. To export your table: 1. Navigate to the Actions menu 2. Click Export > Download CSV The CSV export mirrors your Clay table exactly, so all your column data will be included in the downloaded file. You can then convert the CSV to JSON using external tools if needed.
Sources: Download as a CSV [Clay 101] - Clay University Export and Download a File