# Exporting to excel

**URL:** <https://community.unix.com/t/exporting-to-excel/237904>\
**Category:** Shell Programming and Scripting\
**Created:** [April 16, 2009, 3:03pm UTC](https://community.unix.com/t/exporting-to-excel/237904 "2009-04-16T15:03:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![goutam\_igate](https://community.unix.com/letter_avatar/goutam_igate/32/5_5575768a8748004e209b776fc1b2916d.png) [@goutam\_igate](https://community.unix.com/u/goutam_igate)\
**Post date:** [April 16, 2009, 3:03pm UTC](https://community.unix.com/t/exporting-to-excel/237904/1 "2009-04-16T15:03:46Z")

</div>

Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...☹

---

<div class="post-metadata">

**Author:** ![JerryHone](https://community.unix.com/letter_avatar/jerryhone/32/5_5575768a8748004e209b776fc1b2916d.png) [@JerryHone](https://community.unix.com/u/JerryHone)\
**Post date:** [April 16, 2009, 3:06pm UTC](https://community.unix.com/t/exporting-to-excel/237904/2 "2009-04-16T15:06:08Z")

</div>

Write the output with each field separated by a comma and save the output as a .csv file. Excel should recognise it.

---

<div class="post-metadata">

**Author:** ![goutam\_igate](https://community.unix.com/letter_avatar/goutam_igate/32/5_5575768a8748004e209b776fc1b2916d.png) [@goutam\_igate](https://community.unix.com/u/goutam_igate)\
**Post date:** [April 16, 2009, 3:11pm UTC](https://community.unix.com/t/exporting-to-excel/237904/3 "2009-04-16T15:11:47Z")

</div>

The awk is outputting the file with ; as delimiter. so do i hv to change the delimiter to , manually? also the data shud go into different rows of the excel bt nt into differnt columns.... suggest on this

---

<div class="post-metadata">

**Author:** ![JerryHone](https://community.unix.com/letter_avatar/jerryhone/32/5_5575768a8748004e209b776fc1b2916d.png) [@JerryHone](https://community.unix.com/u/JerryHone)\
**Post date:** [April 16, 2009, 6:37pm UTC](https://community.unix.com/t/exporting-to-excel/237904/4 "2009-04-16T18:37:10Z")

</div>

You don't have to - you can tell Excel to split its columns based on any character you like. And as far as swapping rows and columns, that's probably easier to do in Excel as well...once you've got it all in separate columns, copy the whole lot and then "paste special" and select transpose.

---

<div class="post-metadata">

**Author:** ![goutam\_igate](https://community.unix.com/letter_avatar/goutam_igate/32/5_5575768a8748004e209b776fc1b2916d.png) [@goutam\_igate](https://community.unix.com/u/goutam_igate)\
**Post date:** [April 16, 2009, 9:28pm UTC](https://community.unix.com/t/exporting-to-excel/237904/5 "2009-04-16T21:28:20Z")

</div>

:)dat really works... great and tnx a ton...