Converting text file to excel in unix

Active 5 years, 10 months ago. Viewed 7k times. I have 4 text files in my unix system want to put data into a xls file and send it via mail. Improve this question. Suvendu Suvendu 11 1 1 silver badge 1 1 bronze badge. You don't mention what you want done with the other two files. CSV is easy,. Add a comment. Active Oldest Votes. Improve this answer. JJoao JJoao Archemar, good questions, tsv is find for me, but the PO was asking for a xls I will add anote about it — JJoao.

Converting txt file to Excel file. Registered User. Join Date: Oct Hi All, I have a text file with below content. Code :. Last edited by Franklin52; at AM.. Reason: Please use code tags for data and code samples.

Join Date: Jul Join Date: Sep Try this Join Date: Jun Copy txt file into excel vbscript. Hi everybody, I am working on Windows 10 and using cygwin.

Application" objExcel. Worksheets "Sheet1". Range "A1:CR89". Clear Set Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries.

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. Active 5 years, 11 months ago. Viewed 8k times. My ETL outputs 6 txt file and I need to covert those txt files into xls file.

Improve this question. Arun Nadaraj. Arun Nadaraj Arun Nadaraj 1 1 gold badge 3 3 silver badges 13 13 bronze badges. Are there blank lines like you show too? And why don't you just import the CSV file into Excel as is? I need to automate this process.

I've voted to close this question because it appears to be a request for a recommendation for a tool or solution, rather than a request for assistance with your own code.

This makes your question off-topic for StackOverflow. If that assessment was incorrect, and you do indeed want help writing your own code, then please add your work so far to your question and I'll retract my close vote. Add a comment. Active Oldest Votes.

First, convert the txt files to csv files make a sed or tr command to change tab for comma.