Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to convert txt file into Excel

Divya1808
6 - Meteoroid

I have a text file which looks like as below :

Capture.PNG

 

I want to convert 100 such files into excel looking like below:

 

Capture.PNG

 How to do so?

3 REPLIES 3
Raj
16 - Nebula

@Divya1808 
add a sample text file.

Raj
16 - Nebula

@Divya1808 
find the sample to convert text to excel 
you can use this in batch macro to convert your all files.

hope this helps
mark done if solved.

Divya1808
6 - Meteoroid

@Raj Here's the sample file 

The WF shared doesn't seems to give the desired output

Labels
Top Solution Authors