Exporting files from unix to Excel sheet

How can we export a file in unix with certain number of columns to an excel sheet.

It's very useful in time saving......

have a common delimiter,
create the file

and export it to excel sheet
and the defragmenting end, specify the delimiter
values would be split based on delimiters and available in each column

is that what you have asked far ? :slight_smile:

Assuming the orginal file contents
$ cat /tmp/file.txt
NAME ID YEAR
abc 25 1995
ced 34 1977
ttt 43 1983

Create a csv file,which i assume can be opened up in XL,

awk '{print $1","$2","$3}' < /tmp/file.txt > /tmp/file.csv

cat /tmp/file.csv
NAME,ID,YEAR
abc,25,1995
ced,34,1977
ttt,43,1983

Open the file.csv in Excel. Please let me know if this helps

1 Like

thanx......yaar........it was of grt888!!!! help.....