Clay Icon
Join the Community
02 Support

CSV Import Issue: Only Header Imported, Not the List of 101 People

Avatar of ctct
·
·

Hi - when I go to import a CSV list of people that I want to enrich it just pulls the header and not the list in. What am I missing? The csv has 101 rows and would assume I should be able to import them all.

7 comments

  • Avatar of ct
    ct
    ·
    ·

    I've tried importing it multiple times and the table comes up empty

  • Avatar of ct
    ct
    ·
    ·

    This wasn't the case with other tables I have made

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey, thanks for reaching out! Happy to check it out for you, could you DM me a sample of the CSV.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    For reference: Here are the steps when it fails to import data but still creates a blank table with your column headers: 1. inside the new table that was generated 2. click "add data" 3. import csv 4. check if any of the columns don't auto-select ­** if they don't then they're likely the issue ­** if all are selected, then all are good 5. finish import

  • Avatar of ct
    ct
    ·
    ·

    That seemed to work. Why does it do this though?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    This may be due to some format or unsupported character that the column(s) with issues have and thus it can't import those. Similar situations were reported to the team so we can work on making this clearer and easier to troubleshoot :)