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

Creating Batches of 5K from 30K Raw Data in Clay | Clay

Creating Batches of 5K from 30K Raw Data in Clay

·Nov 17, 2025 02:43 PM·

Hey, I'm new to clay and working on 30K raw data. Any idea how I can create six batches of 5K each in clay? OR do I have to do it manually and import six batches seperately in clay?

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
You'll need to manually split your 30K dataset into six separate CSV files of 5K rows each before importing to Clay.
Clay has a 50,000-row table limit, so your full 30K dataset could fit in one table, but if you prefer smaller batches, you can:
1.
Split your CSV externally into 5K row files
2.
Import each batch using Actions → Import From CSV
3.
Choose to Create new table for each batch [1]
Alternatively, import all 30K rows into one table and use Clay's "write to table" feature to organize data into smaller tables later. [2]
Clay Support
APP
·
·
Did that explanation help with your batching question?
Clay Support
APP
·
·
If you need any more help with splitting or importing your data batches, please let me know. Would you like to share more about what you're trying to achieve with your data in Clay?
Hassan M.
·
·
I get it, thank you!
Clay Support
APP
·
·
You're welcome! If you have any more questions or need further assistance with your data in Clay, feel free to ask.