Hey team, when I load a CSV into Clay manually, for some reasons, value in same cells separated by "," were broken into different columns during the upload, is there a way to keep them in the same cells?
To prevent values in the same cell from being split into different columns when uploading a CSV to Clay, try these steps: 1. Remove commas from your data cells, replacing them with another separator like semicolons. 2. Ensure your CSV is UTF-8 encoded and uses comma-separated values for best results. 3. If issues persist, upload your data to a public Google Sheet, then download it as a CSV and try importing again. To manually upload: 1. Go to the Source panel in your workspace. 2. Click "Actions" and select "Import" for existing tables, or "+ Create new" for new tables. 3. Choose "Import from CSV" and upload your modified file. 4. Follow the prompts to complete the import. If you still encounter problems, please share your CSV file so we can investigate further.
1. Remove commas from your data cells, replacing them with another separator like semicolons. did that, switched all with semicolons and it still breaks
To prevent values separated by semicolons from splitting into different columns when uploading a CSV to Clay, try these steps: 1. Remove semicolons from your CSV data if they're not intended as separators. 2. Use UTF-8 encoded CSV files with comma-separated values for the most reliable results. 3. If issues persist, upload your data to a public Google Sheet, then download it as a CSV and attempt the upload again. 4. During import, carefully match CSV columns to Clay table fields to ensure correct data alignment. If you're still experiencing problems, we'd be happy to take a closer look. You can request human assistance by clicking on "Talk to a person" for further support.
but if both "," and ";" wont work, how should I separate values inside of same cells without spliting them into independent columns during upload
To keep values in the same cell without splitting them into separate columns during a CSV upload to Clay, you can use a different delimiter within the cell. Here are some tips: 1. Use a character that doesn't appear in your data, such as a pipe (|) or semicolon (;) to separate values within cells. 2. Enclose the entire cell content in double quotes to prevent Clay from interpreting the separators as column breaks. 3. When importing, make sure to select the correct column separator (usually a comma) in Clay's import settings. If you encounter issues, try uploading your data to a Google Sheet, then download it as a CSV and attempt the upload again. This can help resolve hidden formatting problems. If you need further assistance, please request human help by clicking on "Talk to a person."
.png){kind=logo}
