Clay Icon
Join the Community
02 Support

Troubleshooting Imports and Exports: How to Clean Up Data and Optimize Usage

Avatar of Aleksi H.Aleksi H.
·
·

Hi! I am having trouble with imports and exports... The Import problem isnt too big, but export problem is really limiting the usage. Practically the trouble is that it will split data from individual rows like this. Is there a way to automatically clean up the data so that it would show on one row?

10 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Aleksi, thanks for reaching out, we appreciate your patience! I'll take a look at the table

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    What tool are you using to view the file you exported? I ran a test on my end and checked with google sheet and excel, the file seems to open up properly

    ffca4fa7-1081-49d0-99ba-ef454b89718d.png(40 kB)
  • Avatar of Aleksi H.
    Aleksi H.
    ·
    ·

    I am running it with excel

  • Avatar of Aleksi H.
    Aleksi H.
    ·
    ·

    I guess this is some setting in excel I have then, which I need to edit maybe?

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    Hmm can you try importing it to a google sheet?

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    And with Excel

  • Avatar of Matthew Q.
    Matthew Q.
    ·
    ·

    I’d make sure that when importing the CSV, you have a comma set as the delimiter. I’ve seen people sometimes have something like a semi-colon selected

  • Avatar of Aleksi H.
    Aleksi H.
    ·
    ·

    the wierd thing is that it does it straight as I open it, but ill try to figure this out tomorrow... Also what would help if you could just =clean() all cells for me and then get me the file version which has been cleaned, I think that should sort the problem atleast has on similar problems

  • Avatar of Aleksi H.
    Aleksi H.
    ·
    ·

    Okay I think I now understand the problem so will figure it out