Unanswered

Convert text file to CSV when a new file saved in file location

(0) Share

Report

Posted on by harignz

Hi there

I'm a new bee and need help to automate .text file convert CSV or Excel file. I want to build a power automate flow when the file is saved in a specific location, parse the data and save as CSV/Excel. Attached is an example of a text file. I converted to .doc as I can't attach .txt file here.

Thanks in advance.

Convert.docx

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @harignz

do you want to convert same as of the format file to csv format ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
harignz 2 on at

Like (0)

Report
Copy link

Link copied!

I want to remove unnecessary data such as (lines, space) and split by columns from Row 5

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @harignz

For that , first you have to create a cloud flow.

1) Select the cloud flow type while creating new flow

I am selecting instant cloud flow for demo purposes.

and the cloud flow should have components like this

First the flow should get content from a text file and then use that file content to create a csv file using Create file action.

Hope this helps!

Was this reply helpful? Yes No
PeterFromDenver 27 on at

Like (0)

Report
Copy link

Link copied!

@harignz sis your original txt file using 1 line per item or do they wrap to the following line like your word document example. Also how big does your text file get?

Was this reply helpful? Yes No
philip_westover 2 on at

Like (0)

Report
Copy link

Link copied!

@PeterFromDenver I have the same issue @harignz so I can answer your questions.

The text file is 1 line per item. And in terms of size, there's ~ 250-500 lines per file.

A couple of the key elements that need to be done are:
--- Convert file from .txt to .csv
--- The first row does not contain the headers. As in @harignz's file, the headers are a few rows down... his headers are: St, Supp, Paper, Width, etc.
--- The headers (and all other text) are not tab delimited.. there's just spacing in-between (some times 1 space, some times 5 spaces, etc.)
--- Some rows need to be ignored. For example, there's a few page title rows at the top.. and also rows with dashed lines (------------), and also some 'total' rows (e.g. rows that contain 'Width Totals', 'Avg_days_in_stock', etc.)

So what we'd be looking for in the final .csv would be something like the below. The first line has the headers and next row is the data.
St Supp Paper Width Order etc.
41 PMTES 100M 1900 230204 etc.

Thanks. --- Philip

Was this reply helpful? Yes No