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

·

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?

✅1

10 comments

Aleksi H.
·
·
https://app.clay.com/workspaces/169853/tables/t_gEjXV10ixHs5/views/gv_1zBtQ9MY8jKs
Clay Team
APP
·
·
Hey Aleksi, thanks for reaching out, we appreciate your patience! I'll take a look at the table
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)
Aleksi H.
·
·
I am running it with excel
Aleksi H.
·
·
I guess this is some setting in excel I have then, which I need to edit maybe?
Matthew Q.
·
·
Hmm can you try importing it to a google sheet?
Matthew Q.
·
·
And with Excel
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
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
Aleksi H.
·
·
Okay I think I now understand the problem so will figure it out