Assistance Needed with CSV Import Issues in Clay Table

Valentin Ivanov · 2024-11-28 11:11:56.442274+00

Hello team, I am importing a CSV into a clay table and although the file is perfectly formatted when I import it, the data is scattered all over, and it isn't even in the first cell so I can separate it with formulas, may I kindly ask you for assistance :slightly_smiling_face:

Assistance Needed with CSV Import Issues in Clay Table | Clay

8 comments

· Sorted by Oldest

Channeled
APP
·
·
To ensure your CSV data imports correctly, you'll need to map your columns properly during the import process. After uploading your CSV file, Clay automatically pulls in all the columns, but you'll need to: 1. Match your CSV columns to the correct Clay table fields 2. Modify column names to match Clay's format if needed 3. Delete any unnecessary columns 4. Rearrange the order of your data as desiredWhen importing, make sure to: ** Navigate to the Source panel ** Upload your file via "Browse Files" or drag-and-drop * Carefully assign columns from your CSV to the corresponding Clay table fieldsThis mapping step is crucial for ensuring your data aligns properly with your Clay table structure. Sources: Import CSV [Clay 101] - Clay University How to import your CSV into Clay - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Valentin Ivanov
·
·
Thank you, this is my CSV file which is arranged as needed and on the second picture you can see that Clay doesn't read it correctly
Valentin Ivanov
·
·
Valentin Ivanov
·
·
Daniel Kupka (Clay)
·
·
Hi Valentin! Thanks for reaching out! The issue you're facing is that the CSV file you’re working with is using semicolons (;) to separate columns, instead of commas (,), which is the standard format for CSV files. To resolve this, you'll need to re-export the file using an application that correctly saves CSV files with commas as separators. A quick fix would to upload the file onto Google Sheets and exporting at as a CSV. Let me know if the trick does it for you! If there's anything else I can assist you with, please let me know! 😊 Have a great Thursday, Daniel
Channeled
APP
·
·
Hi Valentin Ivanov! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Valentin Ivanov!

Channeled
APP
·
·
To ensure your CSV data imports correctly, you'll need to map your columns properly during the import process. After uploading your CSV file, Clay automatically pulls in all the columns, but you'll need to: 1. Match your CSV columns to the correct Clay table fields 2. Modify column names to match Clay's format if needed 3. Delete any unnecessary columns 4. Rearrange the order of your data as desiredWhen importing, make sure to: ** Navigate to the Source panel ** Upload your file via "Browse Files" or drag-and-drop * Carefully assign columns from your CSV to the corresponding Clay table fieldsThis mapping step is crucial for ensuring your data aligns properly with your Clay table structure. Sources: Import CSV [Clay 101] - Clay University How to import your CSV into Clay - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Valentin Ivanov
·
·
Thank you, this is my CSV file which is arranged as needed and on the second picture you can see that Clay doesn't read it correctly
Valentin Ivanov
·
·
Valentin Ivanov
·
·
Daniel Kupka (Clay)
·
·
Hi Valentin! Thanks for reaching out! The issue you're facing is that the CSV file you’re working with is using semicolons (;) to separate columns, instead of commas (,), which is the standard format for CSV files. To resolve this, you'll need to re-export the file using an application that correctly saves CSV files with commas as separators. A quick fix would to upload the file onto Google Sheets and exporting at as a CSV. Let me know if the trick does it for you! If there's anything else I can assist you with, please let me know! 😊 Have a great Thursday, Daniel
Channeled
APP
·
·
Hi Valentin Ivanov! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Valentin Ivanov!