Fixing Misaligned Rows in Clay Spreadsheet CSV Downloads

·

Hi guys I'm trying to download some Clay spreasheet as CSV but when I do the process and download the file I get all the cells/rows messed up and not ordered like on Clay. Does anyone know why and how can I have my rows and cells in the correct place?

19 comments

Avinash H.
·
·
Are you exporting the file as csv?
Alberto A.
·
·
Yes
Avinash H.
·
·
Can you share an image here how the export looks ?
Alberto A.
·
·
Avinash H.
·
·
This maybe a question for the support team
Avinash H.
·
·
Never seen this
Alberto A.
·
·
It should be like this
Alberto A.
·
·
Alberto A.
·
·
Yeah I might ask them
kushagra t.
·
·
Try opening the downloaded csv from clay in google sheets instead of excel. Use the import from csv option in google sheets - should work.
Alberto A.
·
·
Okay thx
Alberto A.
·
·
Yes it works
Alberto A.
·
·
Thanks so much for your help
kushagra t.
·
·
yeah error was because of opening a csv in excel 🙂
Alberto A.
·
·
Thank you
🙌1
Avinash H.
·
·
That's interesting kushagra t. - does it always happen on excel?
kushagra t.
·
·
um maybe depends on how you are importing/opening it on excel, not 100% sure if it happens always in all cases
Bharat D.
·
·
I had a similar issues. I think the root cause is the special characters in CSV which excel recognizes as a separate line. Great work around kushagra t. 💯
🙏1
Nicolas B.
·
·
Yes that was my experience Bharat D.. It was “,” and “;” from the CSV that caused the formatting issue.
👍1