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

Community Guidelines

Powered by Tightknit

Tips for Exporting Large Lists of Companies in Batches | Clay

Tips for Exporting Large Lists of Companies in Batches

·

·

Hi i have a quick question i have a search list that gives an output of 1,20,000 companies there is the limit of exporting 50k at a time how can i export the rest of the 70k

3 comments

· Sorted by Oldest

Loading comments

Clay
APP
·
·
You can export the remaining 70k companies using multiple approaches: Option 1: Multiple CSV exports ** Export in batches of 50k at a time until you've exported all 120k companies Option 2: Use write to table feature ** Use our "write to table" feature to move specific segments of your list to separate tables, then export from each table Option 3: Filter and export * Filter your list view by specific criteria (like company name, industry, etc.) to create smaller segments under 50k, then export each filtered segment You can also push your data directly to destinations like Google Sheets, Airtable, or your CRM to bypass the CSV export limit entirely
Afsha H.
·
·
how can i do this ? Option 1: Multiple CSV exports
Clay
APP
·
·
To export your 120k companies in multiple CSV batches of 50k: 1. First export: Export the first 50k companies as usual 2. Add row limit for remaining data: Add a row limit to split up your remaining 70k companies into manageable segments 3. Second export: Set a row limit to skip the first 50k rows and export the next 50k (rows 50,001-100,000) 4. Third export: Set another row limit to export the final 20k companies (rows 100,001-120,000) This approach lets you systematically export all your data without creating multiple tables.