Clay Icon
Join the Community
02 Support

Hi! I cannot upload my CSV file to a new table. The column names appea...

Avatar of Ilze N.Ilze N.
·
·

Hi! When I upload my CSV file, some of the columns are not shown in the table (no filters applied). Those columns with the respective rows include essential information. What can be done about that?

7 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Ilze N., thanks for the report! Happy to check this out for you, could you send/DM me a sample of the CSV?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 Ilze N.
    Ilze N.
    ·
    ·

    Thanks, Arturo O. for checking. It’s those columns that have numerical values that seem to cause the issue. Is there anything we could do about it?

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Thanks for the follow-up, I'll check if the format is the issue and if there's something we can do

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Ilze N., will have to ask the team more about what specifically is causing this issue in regards to those columns' format. I manually copied/pasted the values into this table https://app.clay.com/workspaces/35014/tables/t­_eqgo2CzuAweC/views/gv­_t9aMbU4uc9a2

  • Avatar of Ilze N.
    Ilze N.
    ·
    ·

    Please let me know once you find out!🙏 We will be using this format for some time. And thanks for the table!