Clay Icon

Issue with Importing CSV: Data Missing After Table Transfer

ยท
ยท

I want to copy one table to another one. So, I exported the table and then imported it into the table that I wanted. But after importing the CSV, all the data are missing, only the Titles are visible. Can anyone help out with this?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    When you import a CSV into Clay, you need to properly map the columns from your CSV to the corresponding fields in your Clay table. If you're only seeing titles but no data, this likely means the column mapping needs to be set up correctly.Here's how to properly import your CSV with data:1. Open your table and go to Actions > Import 2. Upload your CSV file 3. In the mapping step, make sure to assign the columns from your CSV to the correct Clay table fields 4. Choose whether you want to add to the current table or create/replace a table 5. Select "Save and run rows in this CSV" to ensure the data is processedIf you're trying to duplicate an entire table with its data, you can alternatively use the Write to Table integration to transfer your data between tables. This allows you to map your existing data fields to the corresponding columns in your new table. Source: How to import your CSV into Clay | Clay University

  • Avatar of Azizul K.
    Azizul K.
    ยท
    ยท

    hey, I did exactly the same thing, and I made sure to 4. put add to the current table but still there was no data.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To resolve this issue, make sure you've completed these critical steps during the CSV import process:1. After uploading your CSV file, you need to properly map your CSV columns to the Clay table fields. This step is essential - if the columns aren't correctly mapped, no data will appear. 2. During the mapping step, assign each column from your CSV to the corresponding fields in your Clay table. 3. After mapping, select "Save and run rows in this CSV" to ensure the data is processed.Alternatively, if you're trying to copy data between tables, you can use the Write to Table integration instead. This allows you to map your existing data fields to the corresponding columns in your new table. Source: How to import your CSV into Clay | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.