How to convert txt file into excel file?

Question

Hello all!

I am trying to convert a TXT file into Excel file. The problem is, this file contains some data that are in different lines and sometimes we can have 100 lines, sometimes 50 lines.... and so goes on.

If there is a way to convert all information of this TXT file into the excel that would make an outstanding  change in my line of work, by removing copy and paste.

Thanks in advance!

alteryx.txt

saveeshkumar · Answer

Hi @Joker_Hazard ,

Could you please check the below link.
Similar requirement achieved with python tool and Xlsxwriter package. 
Re: create a report - Page 2 - Alteryx Community

Joker_Hazard · Answer

Hello atcodedog05, good to see you again!

I gave a brief explanation for Qiu about the desired output, kindly check that out, I think it would answer your question.

Thanks in advance for the help, have a great sunday!!

Cheers

Joker_Hazard · Answer

Hello Qiu. Thank you very much for the attention.

Your solution does attend my requirement, however I would to have a few modifications, I don't know if alteryx can do that, but sill....

The output on the the excel should respect the blank spaces that the notepad has. I am pretty sure that the input tool is not able to "respect" those spaces, so it would require some data treatment afterwards, am I correct?

Is it possible? Thank you very much