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

·

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

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 😉
Ilze N.
·
·
https://app.clay.com/workspaces/35014/tables/t_1AluQO5XWzI4/views/gv_5PVVrhWvp0ZH
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
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?
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
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
Ilze N.
·
·
Please let me know once you find out!🙏 We will be using this format for some time. And thanks for the table!