Text to column equivalent function

(0) Share

Report

Posted on by spsn

Hi There,

In building flow to automate conversion of csv to excel, I encounter problems in emulating text to column function.

I'm using power automate desktop and my csv files are downloaded as *.xls. In manual world, I can convert the csv files by open the files and save them as *.xlsx, And alternatively, if i copy paste the content to excel, I only need to select the first column and select 'text to column' and set 'tabs' as delimited.

But in power automate, I find that I can extract the info from the csv file in text form and write them to excel file. But my issue is once I write them to excel file, the split text function doesn't work. I tried to use parse, but it doesn't work either (or I using it wrongly). Or I should use other function instead?

Appreciate the help here. Thanks.

Sigrid

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

Hi,

It looks like the order of your activities are wrong. Can you try:
1. Read from csv
2. Split Text
3. Write to Excel

FYOI: You only have to read the CSV one time before and outside the loop, then you can loop the outcome of this value.

Also, you dont need the launch Excel function to write to an Excel File.

Right now you are making a new Excel document for each loop. Is this what you want?

Was this reply helpful? Yes No
spsn 33 on at

Like (0)

Report

I tried the flow you suggested but it still end up only 1 column in excel and it's not split :(.

yes it has to be new excel document for each loop because each file is for 1 country.
eg. I have 5 csv files that i have to convert to 5 excel files.

Was this reply helpful? Yes No