How to Split Output for Business Lists by Zip Code in Excel

Shashank C. · 2025-10-21 22:51:26.991882+00

hey does anyone know how to bypass this? am trying to get a list of all businesses in a certain zip code inside a cell, how do i split output

How to Split Output for Business Lists by Zip Code in Excel | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
You're hitting Clay's 200kb cell size limit. Here are solutions:
Split the data:
Use API parameters like limit and offset to break requests into smaller chunks
Segment your search by geography, industry, or size and run multiple searches
Move data to separate rows:
In Cell details, hover right of the list and select "Turn items into rows" to move each business into its own row in another table [1]
Use "write to table":
Extract the data and send it to another table using our write to table feature [2]
The most effective approach is splitting your zip code search into smaller geographic areas or using row limits to stay under the 200kb threshold.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help managing the data size limit or using the write to table feature, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?
Shashank C.
·
·
can you explain offset as a concept?
Clay Support
APP
·
·
Offset is a pagination parameter that tells an API where to start returning results from a dataset. Think of it like skipping to a specific page in a book - if you have 1000 businesses and set offset=200, the API starts returning results from business #201 onward.
Here's how to use offset with limit to split large datasets:
First request: offset=0, limit=100 (gets businesses 1-100)
Second request: offset=100, limit=100 (gets businesses 101-200)
Third request: offset=200, limit=100 (gets businesses 201-300)
This approach keeps each API response under Clay's 200kb cell limit while systematically retrieving your complete business list in manageable chunks.
What specific API are you using to retrieve the business data, and do you know approximately how many businesses you're expecting to get back?
Clay Support
APP
·
·
If you need more help understanding how to use offset or managing your data retrieval, I’m happy to assist. Would you like to share more about the API or dataset you’re working with so I can provide better support?
Shashank C.
·
·
amazing that worked
Shashank C.
·
·
legendary
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask.
🤝1
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask. I'm here to help.

Clay Support
APP
·
·
You're hitting Clay's 200kb cell size limit. Here are solutions:
Split the data:
Use API parameters like limit and offset to break requests into smaller chunks
Segment your search by geography, industry, or size and run multiple searches
Move data to separate rows:
In Cell details, hover right of the list and select "Turn items into rows" to move each business into its own row in another table [1]
Use "write to table":
Extract the data and send it to another table using our write to table feature [2]
The most effective approach is splitting your zip code search into smaller geographic areas or using row limits to stay under the 200kb threshold.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help managing the data size limit or using the write to table feature, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?
Shashank C.
·
·
can you explain offset as a concept?
Clay Support
APP
·
·
Offset is a pagination parameter that tells an API where to start returning results from a dataset. Think of it like skipping to a specific page in a book - if you have 1000 businesses and set offset=200, the API starts returning results from business #201 onward.
Here's how to use offset with limit to split large datasets:
First request: offset=0, limit=100 (gets businesses 1-100)
Second request: offset=100, limit=100 (gets businesses 101-200)
Third request: offset=200, limit=100 (gets businesses 201-300)
This approach keeps each API response under Clay's 200kb cell limit while systematically retrieving your complete business list in manageable chunks.
What specific API are you using to retrieve the business data, and do you know approximately how many businesses you're expecting to get back?
Clay Support
APP
·
·
If you need more help understanding how to use offset or managing your data retrieval, I’m happy to assist. Would you like to share more about the API or dataset you’re working with so I can provide better support?
Shashank C.
·
·
amazing that worked
Shashank C.
·
·
legendary
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask.
🤝1
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask. I'm here to help.