Text to Columns Google Sheet

I am working on a new process that read from a CSV file and manipulates the text then inserts the data into a Google sheet file.

To manipulate the data I need to use the text to columns activity, but unfortunately, this activity is used with Excel only which is not installed on my machine.

Please I need your help to know if there is any activity do the same action in Google sheet if not, is there another way to do it without this activity.

You can find below what I need to do with text.
image

1 Like

Hey @aalaghbari

Use Generate Data Table activity to convert CSV to Table & Pass the same to Google Sheets.

Hope this helps.

Thanks
#nK

Hi @aalaghbari ,

Have you tried using Read CSV Activity with Delimiter as Semicolon ?

Thanks a lot.

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.