Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

How to Separate Data into Rows on Clay from Ocean.io List | Clay

How to Separate Data into Rows on Clay from Ocean.io List

·Jun 18, 2025 09:24 AM·

Hi All, new and I have been breaking my head for the past few hours. I have created a list of using ocean.io for companies which are similar to the ones we already know. Yet, clay keep on giving me the data into one cell. How can I expand the information retrieved so that it has a row per company?

Loading attachments

3 comments

· Sorted by Oldest

Channeled
APP
·
·
To expand company information into separate rows, you have two options: 1. Use "Send row for each item in a list" - This feature turns each item in a list into its own row in another table, which is perfect for flattening lists of companies. 2. From Cell details - Click on the cell containing your list of companies, then hover to the right of the list and select "Turn items into rows" from the menu. This will move each company into its own row in another table. Both methods help you transform condensed data into a more expanded format with one company per row.
Sources: Send table data | Documentation | Clay University Manage cell data | Documentation | Clay University Manage cell data | Documentation | Clay University
Marco M.
·
·
https://app.clay.com/workspaces/646215/workbooks/wb_0sy1m9aShnvHHSaMjov/tables/t_0sy1nprK8Fo3aQCb2p6/views/gv_0sy1npsBoRPydDNmurE
Bo (.
·
·
Hey — when all the company data ends up in a single cell, you’ll want to use Send Table Data to break it out into individual rows. Here’s the guide to help you set it up: 📘 Send Table Data Guide 🎥 Video walkthrough
Let me know if you need help applying it to your table.