Unanswered

Convert xlsx. or xls files to csv files in a Sharepoint Document Library

(1) Share

Report

Posted on by KayBains

Would anybody have a template or know how one would convert xlsx. or xls files to csv files in a Sharepoint Document Library.

When a xlsx or xls file is uploaded into a Shareppint Document Library - it is converted to a csv file

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (5)

Report

Hello @KayBains ,
there's an action 'Create CSV table' in Power Automate that will convert any array into a csv format.
You should 'List rows present in a table' (the original Excel file must have the data inside a table) to get all the rows from the Excel file, 'Convert CSV table' to convert the output from the 'List rows...' into a csv format, and then create a file from the data provided by the conversion.

Was this reply helpful? Yes No
Heliant 16 on at

Like (7)

Report

what if you do not have table in xlsx. how you going to proceed? And also what if the file is in sharepoint?

Was this reply helpful? Yes No
RobFischer 119 on at

Like (6)

Report

This only works with .xlsx files. There is no way to work with a .xls file in microsoft power platforms and they offer no way to convert with flow. This needs to be addressed!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi all,

I tried this and it converted the xlsx to csv, however about 200 of the records in the original xlsx were missing in the csv output. My Excel data are formatted as a table. Any help would be appreciated!

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @tabrams ,

try to go to the 'advanced options' in the 'List rows in a table' action and put some number in the 'Top Count' field, e.g. 1000. I think the action will return only 100 rows by default.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks so much! I will give this a try in a few minutes. Per the action, the default is "all" but maybe that's not accurate.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi

For me converting excel to csv works if i create table in excel but while conversion it add 2 new columns
@OData.etag
ItemInternalId

How should i remove them before writing the output file to my azure storage.

Regards
Shilpi

Was this reply helpful? Yes No
ImAPilot 4 on at

Like (0)

Report

I believe Microsoft will eventually stop supporting .xls format, as Excel began using the .xlsx format with Excel 2007. It doesn't make sense to invest development dollars in legacy formats, so I wouldn't look for a native Microsoft .xls connector any time soon. That being said, there are many legacy systems still putting out the .xls format, and most of those do NOT support using Excel Tables as many OOB connectors require.

There are several commercial providers that have single step actions to convert; I have been using one of them for a couple years now to convert .xls to .csv with very good results. Some providers include Plumsail, Encodian, and Cloudmersive. Most of these you can find by just scrolling through the list of available actions when building your flow.

Was this reply helpful? Yes No
gr962x 2 on at

Like (0)

Report

Hello,
It works, however it is only copying 256 lines in the created .csv file. Any idea why and how to resolve it?

Was this reply helpful? Yes No
RTbmart 20 on at

Like (0)

Report

Hi @gr962x,

I just encountered this same issue and found a solution from OptimalBI:

Late response, but hope this helps!

Was this reply helpful? Yes No