Hi there, at the moment I am trying to upload a CSV into an existing table. It picks up only the first column of information and does not import the rest of the information. Can you please help? This is my table and I have attached the sheet. https://app.clay.com/workspaces/606856/workbooks/wb_0sxdfx87jgfhPnzaydD/tables/t_0sxdgjp2PtDTBg3TNxw/views/gv_0sxdgjpYhUJT2yC3DMy
The issue is likely related to column mapping or CSV formatting. When importing to an existing table, you need to map out the columns to define how your CSV columns align with the Clay table columns. Steps to fix this: 1. Click Actions → Import → Import from CSV 2. Upload your file 3. Select Add to existing table 4. Map columns from your CSV to the correct Clay table fields Common CSV issues: ** Remove commas, colons, and semicolons from your CSV data ** Ensure your file uses UTF-8 encoding with comma-separated values * Try uploading to Google Sheets first, then download as CSV and re-upload If the issue persists after checking column mapping and CSV formatting, request human assistance by clicking "Talk to a person."
Hey - Tayla W. Open CSV in Google Sheets or Excel Check if all columns are properly separated then Re-download as Clean CSV From Google Sheets: File Download Comma-separated values (.csv) This ensures proper formatting In Clay Click "Upload CSV to Table" Choose correct table Map columns manually during upload Still stuck? Open CSV in a text editor Ensure it uses commas (,) not semicolons (;) as delimiters
Your troubleshooting steps are correct. The key is proper column mapping during import: CSV Formatting: ** Use UTF-8 encoding with comma-separated values ** Remove commas, colons, and semicolons from your CSV data ** Ensure short file names Import Process: 1. Click Actions → Import → Import from CSV 2. Select "Add to existing table" 3. *Map out the columns to define how your CSV columns align with Clay table columns If issues persist, upload to Google Sheets first, then re-download as CSV and try again.
Since the standard troubleshooting didn't work, let's check these specific requirements: File Limits: ** Maximum 72 columns and 50,000 rows ** Short file name required Data Cleaning: ** Remove all commas, colons, and semicolons from your CSV data (not just separators) ** Ensure UTF-8 encoding Column Mapping: During import, you must map out the columns to define how your CSV columns align with the Clay table columns If your file still won't upload after checking these requirements, request human assistance by clicking "Talk to a person."
Talk to a person
Hey Tayla! Happy to take a look at this - can you share the link to your table so I can dive in?
Hi Hari K., thank you so much. Here is my table - https://app.clay.com/workspaces/606856/workbooks/wb_0sxdfx87jgfhPnzaydD/tables/t_0sxdgjp2PtDTBg3TNxw/views/gv_0sxdgjpYhUJT2yC3DMy
Hey Tayla! I think what might be helpful here is to double-check that the CSV has column headers that match those within Clay. This will help the import via CSV to parse the data correctly.
Hope this helps!