Split excel file in several csv files

(0) Share

Report

Posted on by slvedva

176

Hi,

Maybe someone can help to build the flow. I have excel file on SharePoint with 10 columns, I have ~1000+ rows with data, data regulary refreshed.

I need build flow, when I run manually the flow, I need, that system will take only 2 columns from this excel file and create csv file with only these 2 columns, but also split files 200 rows per file. Example in excel file I have 800 rows with 10 columns, when I run the flow, I want to receive in the same SharePoint folder 4 csv files, where each file contain data from this excel file with 2 mentioned columns.

Additional I need make some date/time remark in original excel file, which lines was exported to csv.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@slvedva Hi,

How far you can go for now by yourself ?

if you got error/stuck, share the info/error/screen shot, so we can start from there .

Is that ok ?

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report

Hi @stampcoin,

I didn't create yet the flow for this process, because not so big expierence.

I need help from start.

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@slvedva Hi,
Share my flow, ( don't copy my code unless you understand it).

Manually trigger

List rows in your Excel table, key point here is enable Pagination, value =2000 for example.

Use Select to pick only the two columns you need.
For example ColumnA=item()?['ColumnA'], ColumnB=item()?['ColumnB']

Initialize loop‐control variables
a. Initialize variable: Name= startIndex, type=Integer, Value=0
b.Initialize variable: Name= fileCount, type=Integer, Value =1

Loop until you’ve processed all rows
Until= variables('startIndex') >= length(body('Select'))
Inside loop:
Compose: input=take( skip(body('Select'), variables('startIndex')),200)
Add: Create CSV table.
Add: Create file, file name = concat('output_', string(variables('fileCount')), '.csv') for example.
Add: Increment startIndex by 200.
Add: Increment fileCount by 1

that's it. below for your reference.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report

Hi @stampcoin

I create the same flow

In main table I have 580 rows, when run the flow, system create 2 csv files and both files contain the same data the first 257 rows from main table :(

My idea, is that in this case I receive output_1 - with rows from 1-200, output_2 - 201-400 and output_3 - 401-580.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@slvedva Hi,

Please check if you missed this option.

As default, it only get 256 records, use 600 for example as your value.

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report

@stampcoin, now I set and system create 3 files, but all files have full list with records, identical files. I want, that content will be splited by 200+200+180

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@slvedva Hi,

Please check each step very carefully, in List rows present in a table, Pagination is the only option you need, don't use filter, top, etc.

you got 3 files, which means Do runs three times, that is correct.

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report

@stampcoin I found the issue, when create CSV file, I wrongly put selection step, not compose output!!! MANY Thanks.

But one small additional question - when we do this main file split to csv files, is it possible in this main table put some date mark in some of the column, that this row is splitted and saved in csv? Because in this main file always data will added more and more and I don't want to split and save the data twice.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Just use the function chunk() within an Apply to each (rows from Excel) :

chunk(<rows_from_Excel>, 200)

Was this reply helpful? Yes No
Verified answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@slvedva Hi,

Great you made it.

For your additional question, that will be different story ( beyond your post question).

And yes, you can add a column in your Excel, use date time or use flag.

One most important thing is make sure you have unique ID for each row.

Then you add the ID in the select action.

In the loop, after each CVS file created successfully, then add Update a row for each record (ID).

Key column and Key value is the key point, then select the flag column, feed it with data time or Yes/No .

Was this reply helpful? Yes No