Clay Icon

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?

  • Avatar of Avinash H.
    Avinash H.
    Β·
    Β·

    Are you exporting the file as csv?

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Yes

  • Avatar of Avinash H.
    Avinash H.
    Β·
    Β·

    Can you share an image here how the export looks ?

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·
  • Avatar of Avinash H.
    Avinash H.
    Β·
    Β·

    This maybe a question for the support team

  • Avatar of Avinash H.
    Avinash H.
    Β·
    Β·

    Never seen this

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    It should be like this

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·
  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Yeah I might ask them

  • Avatar of kushagra
    kushagra
    Β·
    Β·

    Try opening the downloaded csv from clay in google sheets instead of excel. Use the import from csv option in google sheets - should work.

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Okay thx

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Yes it works

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Thanks so much for your help

  • Avatar of kushagra
    kushagra
    Β·
    Β·

    yeah error was because of opening a csv in excel πŸ™‚

  • Avatar of Alberto A.
    Alberto A.
    Β·
    Β·

    Thank you

  • Avatar of Avinash H.
    Avinash H.
    Β·
    Β·

    That's interesting kushagra - does it always happen on excel?

  • Avatar of kushagra
    kushagra
    Β·
    Β·

    um maybe depends on how you are importing/opening it on excel, not 100% sure if it happens always in all cases

  • Avatar of Bharat D.
    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 πŸ’―

  • Avatar of Nicolas B.
    Nicolas B.
    Β·
    Β·

    Yes that was my experience Bharat D.. It was β€œ,” and β€œ;” from the CSV that caused the formatting issue.