How to convert Txt to Xlsx?

[Gualigee]

Hello, 

I have a really large file needing to be converted into an excel file?

Can someone give some hints? The output only needs the following fields. 

Thanks

[apathetichell · Accepted solution]

something like this.

The key with the .zip set up is to bring it in as .csv with /t as the delimiter, an extended field size (I used 24500) and check "treat read errors as warnings"