# Convert excel to tab

**URL:** <https://community.unix.com/t/convert-excel-to-tab/366827>\
**Category:** Shell Programming and Scripting\
**Created:** [May 31, 2017, 4:40am UTC](https://community.unix.com/t/convert-excel-to-tab/366827 "2017-05-31T04:40:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nans](https://community.unix.com/letter_avatar/nans/32/6_449c533f586939b6e5f246632a46421f.png) [@nans](https://community.unix.com/u/nans)\
**Post date:** [May 31, 2017, 4:40am UTC](https://community.unix.com/t/convert-excel-to-tab/366827/1 "2017-05-31T04:40:46Z")

</div>

Hello,  
I have an excel sheet (.xlsx), with 11 worksheets. I need to run my bash scripts on the 1st worksheet and write the output to the 2nd worksheet.  
I am currently manually converting the worksheet into a tab delimited to run the script and then pasting it back to excel.  
Is there a way to do this in bash as there are several excel sheets to work on ?

Thank you.

---

<div class="post-metadata">

**Author:** ![joeyg](https://community.unix.com/user_avatar/community.unix.com/joeyg/32/780_2.png) [@joeyg](https://community.unix.com/u/joeyg)\
**Post date:** [May 31, 2017, 9:27am UTC](https://community.unix.com/t/convert-excel-to-tab/366827/2 "2017-05-31T09:27:20Z")

</div>

Several posts, including:

> **[How to convert excel file to csv file or text file?](https://www.unix.com/shell-programming-and-scripting/218921-how-convert-excel-file-csv-file-text-file.html)**
>
> Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Anothe | The UNIX and Linux Forums

---

<div class="post-metadata">

**Author:** ![nans](https://community.unix.com/letter_avatar/nans/32/6_449c533f586939b6e5f246632a46421f.png) [@nans](https://community.unix.com/u/nans)\
**Post date:** [May 31, 2017, 9:53am UTC](https://community.unix.com/t/convert-excel-to-tab/366827/3 "2017-05-31T09:53:38Z")

</div>

Hello, I have gone through most of the questions on the forums but none of them have quite helped me to what I want. For example, I tried xls2csv but I end up with an error

```nohighlight
xls2csv -b Unannotated S12.xlsx > test.csv
S12.xlsx is not OLE file or Error

```

as well as gnumeric

```nohighlight
ssconvert -S S12.xlsx test.csv

(ssconvert:28398): GLib-GObject-WARNING **: invalid (NULL) pointer instance

```
