Importing CSV Data with Semicolons into a Single Column: How to Fix It | Clay

Importing CSV Data with Semicolons into a Single Column: How to Fix It

hello, I am trying to import data where one field has semi-colons. when I try importing, both as a new table and adding to an existing table, the data with the semicolons gets split up across multiple columns. I assume this is due to the CSV format of the import. can anyone help here ? I would like the data with the semicolons to be imported into one column only

8 comments

Channeled
APP
·
·
To import data with semicolons into Clay without splitting fields, you can use the CSV import feature and adjust the column mapping during the import process. Here's how: 1. Navigate to your Clay workspace and click "Actions" > "Import" > "Import Companies From a CSV". 2. Upload your CSV file by clicking "Browse Files" or dragging and dropping it into the upload area. 3. During the column mapping step, you can define how the columns in your CSV should align with the columns in the Clay table. This is where you can ensure that fields containing semicolons are imported into a single column. 4. Map the column containing semicolons to a single field in Clay, ensuring it's not split across multiple columns. 5. Complete the import process by clicking "Add to table" or "Complete import", depending on whether you're adding to an existing table or creating a new one. By carefully mapping your columns during the import process, you can maintain the integrity of fields containing semicolons and import them into a single column in Clay.
Sources: Import CSV [Clay 101] - Clay University How to import your CSV into Clay | Documentation | Clay University Import a File
Channeled
APP
·
·
Was that helpful?
Daniel A.
·
·
tried this already!!
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Daniel A.
·
·
https://app.clay.com/workspaces/348137/tables/t_TDtc3qiQd3hp/views/gv_phAPPznewMYF
Daniel A.
·
·
sorry you can disregard and close, I figured out a solution in Google Sheets
Stefano
·
·
Hi Daniel, I am glad you were able to solve this issue. Let us know if there is anything else we can help you with! :)
Channeled
APP
·
·
Hi Daniel A.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: