Table Only Returning 50 Results Despite 32,999 Available

Kumi P. · 2025-10-22T08:58:05.416Z

A table is only returning 50 results despite - it previewing to pull in Previewing 50 of 32,999 results . 32,999 will be imported. I tried to create new table and try again - but have had the same issue

Table Only Returning 50 Results Despite 32,999 Available | Clay

14 comments

· Sorted by Oldest

Clay Support
APP
·
·
You're experiencing the 50-row limit for trial and free accounts. Trial and free accounts are limited to 50 rows per table, which explains why you're only seeing 50 results despite the preview showing 32,999. [1]
This limit helps new users explore Clay more broadly by trying different data sources and workflows before committing credits to large actions. [2] Once you upgrade to a paid plan, the limit increases to 50,000 rows per table.
Clay Support
APP
·
·
Did that answer your question?
Kumi P.
·
·
no, am on a paid account
Clay Support
APP
·
·
Thank you for letting me know. I’m routing you to our human team now so they can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Munnawar H.
·
·
Hi Kumi,
Thank you for reaching out to the support team. Can you send me a link to the table that you're working on? Are you trying to pull in these results to a new table or an existing table? I look forward to your response!
Kumi P.
·
·
https://app.clay.com/workspaces/439337/workbooks/wb_0t4iyz1xFsvEk7DjXT5/tables/t_0t4iyziS639FkFWVD7P/views/gv_0t4iyzi3XyTKc2HFGJ6 It's a new table
Munnawar H.
·
·
Thanks for providing the link, but that table doesn't show a find people search. Is it this one that you're referring to? https://app.clay.com/workspaces/439337/workbooks/wb_0t4iyz1xFsvEk7DjXT5/tables/t_0t4izarWEdWhTcSEeSr/views/gv_0t4izasbZXnz3qcztxx Are you able to recreate the search here to see if you get the same error? I'm currently investigating on my side.
Kumi P.
·
·
yeh, that's the workbook - the people search is the 2nd tab. Only displaying 50 results. I don't know if you will have access I have saved the search as Top 50 - CWIME - as it has 50,421 i edited to remove the UK and DE so it was under 50k rows
Munnawar H.
·
·
Hi Kumi,
I've rebuilt the table and reduced the number of filters in both the “Include Jobs” and “Exclude Jobs” fields. The error you were seeing was caused by having too many filters in place. I recommend significantly reducing them to prevent this issue from happening.
Kumi P.
·
·
ok, gotcha. makes sense
Munnawar H.
·
·
Please let me know if you still experience any issues with this after you make the changes.
Kumi P.
·
·
cool, will work with colleague tomorrow - who's more dialled in with the ICP. Thanks for your help! Great job hosting the Clay Cup. The london event was fun and my intro to Clay!
Munnawar H.
·
·
Hey! Thank you so much for that feedback it really means a lot! Clay Cup was so fun, and we're hoping to make it even bigger next year. 🙂
1

Clay Support
APP
·
·
You're experiencing the 50-row limit for trial and free accounts. Trial and free accounts are limited to 50 rows per table, which explains why you're only seeing 50 results despite the preview showing 32,999. [1]
This limit helps new users explore Clay more broadly by trying different data sources and workflows before committing credits to large actions. [2] Once you upgrade to a paid plan, the limit increases to 50,000 rows per table.
Clay Support
APP
·
·
Did that answer your question?
Kumi P.
·
·
no, am on a paid account
Clay Support
APP
·
·
Thank you for letting me know. I’m routing you to our human team now so they can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Munnawar H.
·
·
Hi Kumi,
Thank you for reaching out to the support team. Can you send me a link to the table that you're working on? Are you trying to pull in these results to a new table or an existing table? I look forward to your response!
Kumi P.
·
·
https://app.clay.com/workspaces/439337/workbooks/wb_0t4iyz1xFsvEk7DjXT5/tables/t_0t4iyziS639FkFWVD7P/views/gv_0t4iyzi3XyTKc2HFGJ6 It's a new table
Munnawar H.
·
·
Thanks for providing the link, but that table doesn't show a find people search. Is it this one that you're referring to? https://app.clay.com/workspaces/439337/workbooks/wb_0t4iyz1xFsvEk7DjXT5/tables/t_0t4izarWEdWhTcSEeSr/views/gv_0t4izasbZXnz3qcztxx Are you able to recreate the search here to see if you get the same error? I'm currently investigating on my side.
Kumi P.
·
·
yeh, that's the workbook - the people search is the 2nd tab. Only displaying 50 results. I don't know if you will have access I have saved the search as Top 50 - CWIME - as it has 50,421 i edited to remove the UK and DE so it was under 50k rows
Munnawar H.
·
·
Hi Kumi,
I've rebuilt the table and reduced the number of filters in both the “Include Jobs” and “Exclude Jobs” fields. The error you were seeing was caused by having too many filters in place. I recommend significantly reducing them to prevent this issue from happening.
Kumi P.
·
·
ok, gotcha. makes sense
Munnawar H.
·
·
Please let me know if you still experience any issues with this after you make the changes.
Kumi P.
·
·
cool, will work with colleague tomorrow - who's more dialled in with the ICP. Thanks for your help! Great job hosting the Clay Cup. The london event was fun and my intro to Clay!
Munnawar H.
·
·
Hey! Thank you so much for that feedback it really means a lot! Clay Cup was so fun, and we're hoping to make it even bigger next year. 🙂
1