When I export a table, our column on About pages for websites, is getting truncated to 100 characters. Other columns in the same table can export with thousands of characters. Is there a setting I am missing? thanks
The character limit for cells in Clay is 8000 characters per cell. The CSV export mirrors your Clay table exactly, so if you're seeing truncation to 100 characters specifically for the About pages column, this suggests the data in that column may be stored differently or there's a display issue. To troubleshoot this, try creating a dedicated "CSV Export View": 1. Duplicate your current view 2. Hide columns you don't need 3. Focus on including only the raw values you need This ensures your exported CSV contains clean data. If the issue persists after trying this approach, you may need human assistance by clicking "Talk to a person" for further investigation.
The About column is likely set to a short text field limited to 100 characters Change the field type to Long Text or its equivalent If using an export tool or integration, check if it's truncating text. That should solve it.
To change your About column to handle more than 100 characters: Method 1: 1. Right-click the column header 2. Click Edit Column > Select Data Type 3. Choose the appropriate data type 4. Click Save Settings Method 2: 1. Click on the column title 2. Hover over the current data type to see dropdown options 3. Select your new input type Clay supports up to 8000 characters per cell, so changing the data type should resolve the 100-character truncation issue.
I dont see the Select Data type..
There are two methods to change column data types in Clay: Method 1: 1. Right-click the column header 2. Click Edit Column > Select Data Type 3. Choose the appropriate data type 4. Click Save Settings Method 2: 1. Click on the column title 2. Hover over the current data type to see dropdown options 3. Select your new input type If you don't see "Select Data Type" in Method 1, try Method 2 instead. The option should appear when you hover over the current data type displayed near the column title.
ok, good now. I added a Text Response column based on the About column. that exported all characters. thanks!