Text and tables from Word to Excel

(0) Share

Report

Posted on by AlexPower

Hi everyone,

I have question about my flow in Power Automate Desktop.

I want to read text and tables from a Word document in such a form that they are transferred to excel in separate rows.
Unfortunately the workflow at the moment pastes everything in the first row of the first column. I suspect I should parse it into a table, but I'm not sure if this is the correct path.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AlexPower ,

Please find the solution. I am considering your Word Output as a List. If it is not a list use Split Text to split it will make it into a list.

Code:

Word.LaunchWord.LaunchAndOpen Path: $'''C:\\Users\\Desktop\\Word Document.docx''' Visible: True ReadOnly: False Instance=> WordInstance Word.ReadFromWord.Read Instance: WordInstance WordData=> WordOutput_Data Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Desktop\\Power Automate Desktop\\Practice\\Input.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance SET RowValue TO 1 LOOP FOREACH CurrentItem IN WordOutput_Data Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem Column: $'''A''' Row: RowValue Variables.IncreaseVariable Value: RowValue IncrementValue: 1 END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
pradeepvarma 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Try the below activity to convert that text into a list using the appropriate (return key) as delimiter.
Split text
Then you may use that list to write in your excel either directly by using a loop or create a data table, append to it and then write it / use it anywhere else in the process.

If it works for you, kindly mark it as a solution.

Regards,
Pradeep Varma
Follow on LinkedIn

Was this reply helpful? Yes No