Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Extracting Data from JSON Objects in Excel: Best Methods

·

·

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?

Extracting Data from JSON Objects in Excel: Best Methods | Clay

3 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Ryan Riggin
·
·
sweet thank you
Channeled
APP
·
·