Convert csv Files from a folder to Excel .xlsx

(0) Share

Report

Posted on by Hana123TEI

There are CSV files in a folder which need to be converted to .xlxs.

I have map the process as but it fails to save the file on Particular folder .

any support will be highly appreciated.

Regards,

**bleep**al.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

VJR 7,635 on at

Like (0)

Report

Hi,

1. Can you check the extension in Close Excel and see what happens.
It is currently showing xlxs, whereas it should be xlsx.

2. And Also there is no file name after the \.
It is only showing BCS Alert\.xlxs

Make it BCS Alert\file_name_here.xlsx

Was this reply helpful? Yes No
Hana123TEI 49 on at

Like (0)

Report

Hi,

The Problem is there are more than 2 csv files in the folder , hence I loop , The file name should be same as per the file name of the document ,I tried to do as per you mentioned it run but the file is not saves as xlsx.

Regards,
**bleep**al.

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

So, 1) above, you would be overwriting the first file with the second one, because the Save As filename isn't dynamic. 2) ".xlsx" is already declared in the 'Document format' parameter of the "Close Excel", so we do not want to also put it in the 'Document path' parameter, this will cause it to double up.

Here is what we want Close Excel to look like:
All variables have properties. In this example, %CurrentItem% is a 'File' variable type. I keep this link saved on my desktop for reference:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/datatype-properties

It lists all properties for all variable types, here is a snippet from files:
So, '%CurrentItem.Directory% is the same folder that you got the file from, and %CurrentItem.NameWithoutExtension% is just that. Don't forget the "\" between the two.

If you have any trouble, let me know.

Was this reply helpful? Yes No
Hana123TEI 49 on at

Like (0)

Report

Hello,

above mentioned will work but it is saving the file on the same path, hence I added the path and then the logic as given you but then its not work. Thanks in advance if you help on saving the file on other path in such case.

Regards,

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Do you want them all to go to a single folder, or do you need to decide which folder to go to based off another rule? If they all go to a single folder, you should be able to just write that into the Close Excel. ex. C:\Users\Documents\%CurrentItem.NameWithoutExtension%

If that doesn't work, try trading out all the "\" for "\\"

Depending on where you are at "\" is a special character and it requires 2 to make 1.

Was this reply helpful? Yes No
Hana123TEI 49 on at

Like (0)

Report

Hi Michael,

I have to save all these file in same location .
I did as you mentioned the flow also works but the file is not saved on that location , whereas I tried putting \\
but it not accept
Regards,

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

That should work, assuming D:\ is a valid location. You could save back to the current directory and then try moving it to 😧 with 'move files', but my guess would be something is not mapping to the D:. Most D:s are designated for cd/disc drives. Is your 😧 a network drive by any chance? Several users have reported that when trying to save to a network drive, they have to save to the actual server name (ex. NETWORK\\) instead of the mapped network drive (ex. N:\). Good luck!

Was this reply helpful? Yes No