Extracting Data from JSON Objects in Excel: Best Methods

Ryan R. · 2025-04-22T19:19:30.186449+00:00

I just pulled in a list from sales navigator but all the data is in a json object in 1 cell. What is the best way to extract the data to columns?

To extract data from a JSON object in a single cell after importing from Sales Navigator, follow these steps: 1. Click into a record in the imported column. 2. Select the specific data fields you need (e.g., email, company name, first name, last name). 3. For each field, hover over it and click "Add as column" on the right. 4. Choose "Map to an existing column" if you want to overwrite an existing column, or create a new one. This process will extract the data points into separate columns, allowing for better organization and analysis. You can repeat this for multiple fields to create individual columns for each piece of information you need from the JSON object. If you need to manipulate the data further, you can use our "write to table" feature to send the extracted information to another table in your workbook.

Sources: Import from CRM [Clay 101] - Clay University Table columns | Documentation | Clay University

3 comments