Power Platform Community Forum Thread Details

Hii,

i want to convert txt file to xlsx. how to convert please guide me.

Regards,

Supriya

Categories:

You will need to be more specific about what data you have in your .txt file and what you want it as in the Excel file.

But with the limited information you provided, the general idea is as follows.

You can use the Read text from file action to get the text from your .txt file. You can then, if you need to, use Split text to split the text file contents into a list of rows. You could then use a For each loop on those rows to handle each of them individually.

Now, before you do that, you would also need to use Launch Excel to launch an instance of Excel. You could launch it with a blank document. Then you could use Write to Excel worksheet to write the values you extracted from your text file into the Excel file. And then you can use Save Excel to save it as a file where ever you want it, and Close Excel to close the document.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.