Need to convert text file into Excel sheet

Shell Programming and Scripting
1

:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further..
Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like
file1 file2

00: 140       00: 235
01: 160       01:415
02: 248       02:871
..                 ....
23: 471       23: 734

i need to convert this text files data into excel sheet as hour in column1 file1 data in column2 file data in column3 as below:
o/p Excel sheet:

hour  file1   file2
00     140   235
01     160   415
02     248   871
...      ....       ....
23     471   734

Plz suggest to get the solution for the above mentioned prob asap..

2

Try this awk solution:

awk -F"[: ]*" '
  BEGIN{OFS=","; print "hour",ARGV[1], ARGV[2]}
  FNR==NR{A[$1]=$2;next}
  {print $1,A[$1]+0,$2} ' file1 file2 > sheet.csv