How to convert txt file to excel

Help Studio
, ,
1

Good day please assist i am trying to convert txt file to excel using version 2020 i used this solution

The image shows a workflow sequence in an automation tool, featuring steps like reading a text file, generating a data table, assigning a variable, writing a range to an output, and opening an Excel scope, with additional configuration options displayed on the right. (Captioned by AI)
The image shows a workflow sequence in an automation tool, featuring steps like reading a text file, generating a data table, assigning a variable, writing a range to an output, and opening an Excel scope, with additional configuration options displayed on the right. (Captioned by AI)1035×669 36 KB

the text file looks like this
A table displaying policy information such as policy number, product brand, division, and personal details, with some fields redacted for privacy. (Captioned by AI)

the results

The image shows a spreadsheet with various columns related to insurance policies, including policy numbers, agents, underwriters, product descriptions, and names, with some data partially obscured. (Captioned by AI)
The image shows a spreadsheet with various columns related to insurance policies, including policy numbers, agents, underwriters, product descriptions, and names, with some data partially obscured. (Captioned by AI)1879×185 22.5 KB

2

Hi @pabaleloh

Pls check this link for same,

OR

If you found helpful, Mark as a solution tick .
Happy Automation

3

@pabaleloh

Turn csv parsing to true and check

Cheers

4

I tried all this solutions but i am not wining…i am still receiving the same output

5

The image is a screenshot of an Excel spreadsheet displaying a single row of data with multiple columns related to policy information, including policy numbers, product details, division, payment channel, and personal names, with some data obscured for privacy. (Captioned by AI)
The image is a screenshot of an Excel spreadsheet displaying a single row of data with multiple columns related to policy information, including policy numbers, product details, division, payment channel, and personal names, with some data obscured for privacy. (Captioned by AI)1905×177 20.5 KB

The headers are on the top and in column A…

6

Hi @pabaleloh

Can you pass a sample input txt file