Home
Events
Groups
Members

01 Watercooler
02 Bugs
02 Starting with Clay
Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
Gtm Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Powered by Tightknit

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

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?

Loading attachments

10 comments

· Sorted by Oldest

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