# Can I edit an Excel file without Excel?

**URL:** <https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445>\
**Category:** Factual Questions\
**Created:** [August 5, 2004, 1:53pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445 "2004-08-05T13:53:16Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![cowgirl](https://avatars.discourse-cdn.com/v4/letter/c/8c91f0/32.png) [@cowgirl](https://boards.straightdope.com/u/cowgirl)\
**Post date:** [August 5, 2004, 1:53pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/1 "2004-08-05T13:53:16Z")

</div>

I need to edit an Excel document but I do not have Excel on this computer. When I open the doc it opens in Excel Viewer which does me no good at all.

Is there anything I can download (for free) that would let me?

---

<div class="post-metadata">

**Author:** ![cowgirl](https://avatars.discourse-cdn.com/v4/letter/c/8c91f0/32.png) [@cowgirl](https://boards.straightdope.com/u/cowgirl)\
**Post date:** [August 5, 2004, 1:54pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/2 "2004-08-05T13:54:32Z")

</div>

I only need to insert text. Nothing fancy. But I will need to open it again later in Excel.

---

<div class="post-metadata">

**Author:** ![Dead\_Badger](https://avatars.discourse-cdn.com/v4/letter/d/848f3c/32.png) [@Dead\_Badger](https://boards.straightdope.com/u/Dead_Badger)\
**Post date:** [August 5, 2004, 1:59pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/3 "2004-08-05T13:59:26Z")

</div>

As I have just today discovered, yes: [Openoffice](http://www.openoffice.org/) will work just fine. If you don’t mind a largeish download, it seems to do most of the things that Office does, and for free. It might prompt you to save in its own format, but I believe it can save in .xls as well if you force it.

---

<div class="post-metadata">

**Author:** ![friedo](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@friedo](https://boards.straightdope.com/u/friedo)\
**Post date:** [August 5, 2004, 2:01pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/4 "2004-08-05T14:01:34Z")

</div>

If you are a programmer, there are numerous APIs for dealing with Excel files, such as [Spreadsheet::WriteExcel](http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.03/lib/Spreadsheet/WriteExcel.pm) for Perl. If not, the best thing I could reccomend would be to download [OpenOffice](http://www.openoffice.org/) and have a whack at it.

---

<div class="post-metadata">

**Author:** ![Mort\_Furd](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@Mort\_Furd](https://boards.straightdope.com/u/Mort_Furd)\
**Post date:** [August 5, 2004, 2:01pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/5 "2004-08-05T14:01:37Z")

</div>

[OpenOffice.org](http://OpenOffice.org) is free software that is a complete replacement for MS Office.

OOo reads and writes MS files (Excel, Word, Powerpoint) and includes database functionality - it will connect to any ODBC datasource out there.

Download here:

[http://www.openoffice.org/](http://www.openoffice.org/)

It is rather large (60 MB or larger, depending on current version and OS.) It is worth it, though.

---

<div class="post-metadata">

**Author:** ![larsenmtl](https://avatars.discourse-cdn.com/v4/letter/l/d78d45/32.png) [@larsenmtl](https://boards.straightdope.com/u/larsenmtl)\
**Post date:** [August 5, 2004, 2:02pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/6 "2004-08-05T14:02:36Z")

</div>

Open Office is THE free open source alternative to MS Office. In a word, it rocks. “Calc” is its spreadsheet program. It handles opening excel docs and saving in excel format quite nicely.

Check it out here: [http://www.openoffice.org/](http://www.openoffice.org/)

BTW, I hope you have some high speed internet action, 'cause it’s a little on the large side. Well worth it, though!

LarsenMTL

---

<div class="post-metadata">

**Author:** ![larsenmtl](https://avatars.discourse-cdn.com/v4/letter/l/d78d45/32.png) [@larsenmtl](https://boards.straightdope.com/u/larsenmtl)\
**Post date:** [August 5, 2004, 2:08pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/7 "2004-08-05T14:08:04Z")

</div>

Hmmm, I wonder if OpenOffice is popular here on the SDMBs?

---

<div class="post-metadata">

**Author:** ![cowgirl](https://avatars.discourse-cdn.com/v4/letter/c/8c91f0/32.png) [@cowgirl](https://boards.straightdope.com/u/cowgirl)\
**Post date:** [August 5, 2004, 2:14pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/8 "2004-08-05T14:14:28Z")

</div>

nope, not a programmer … just lost in the world of free downloads …

Thanks for the tip ! I’m halfway through installation … I’ll let you know how it turns out.

I kind of feel like I’m joining a club!

---

<div class="post-metadata">

**Author:** ![cowgirl](https://avatars.discourse-cdn.com/v4/letter/c/8c91f0/32.png) [@cowgirl](https://boards.straightdope.com/u/cowgirl)\
**Post date:** [August 5, 2004, 2:38pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/9 "2004-08-05T14:38:56Z")

</div>

WOW ! Thanks ! You’ve changed my life !

---

<div class="post-metadata">

**Author:** ![Jake4](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@Jake4](https://boards.straightdope.com/u/Jake4)\
**Post date:** [August 5, 2004, 4:26pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/10 "2004-08-05T16:26:01Z")

</div>

Congratulations to the 4 simulposters. 🙂

---

<div class="post-metadata">

**Author:** ![ZipperJJ](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zipperjj/32/211_2.png) [@ZipperJJ](https://boards.straightdope.com/u/ZipperJJ)\
**Post date:** [August 5, 2004, 4:44pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/11 "2004-08-05T16:44:54Z")

</div>

For the record, I just opened a XLS file (single worksheet) using Notepad and it was a big HTML page with just a table, table markup, and text inside the table cells. I mean I was looking at HTML, not a web page.

So if you’re in a pinch and just need to change some text, you could easily open up in notepad, search for the text and change.

Also, if you were to save the XLS file in Excel as a CSV you can open it in notepad and the values would be separated by commas and qualified with “”. Then you can send the file for editing to any machine with a text editor (such as Notepad) to be edited.

But now that you’ve got OpenOffice and your life has changed forever, forget I mentioned this 😉

---

<div class="post-metadata">

**Author:** ![friedo](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@friedo](https://boards.straightdope.com/u/friedo)\
**Post date:** [August 5, 2004, 4:48pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/12 "2004-08-05T16:48:25Z")

</div>

> [@ZipperJJ](#):
>
> For the record, I just opened a XLS file (single worksheet) using Notepad and it was a big HTML page with just a table, table markup, and text inside the table cells. I mean I was looking at HTML, not a web page.

You were looking at XML, actually, which isn’t the same thing. Only relatively recent versions of Excel use XML by default, though.

---

<div class="post-metadata">

**Author:** ![Shoeless](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/shoeless/32/7099_2.png) [@Shoeless](https://boards.straightdope.com/u/Shoeless)\
**Post date:** [August 5, 2004, 5:47pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/13 "2004-08-05T17:47:40Z")

</div>

I was going to suggest Sun Microsystem’s \*\*StarOffice \*\* but it appears they are charging for that now. I used that a few years ago when I was working on a project that ran on OS/2. It was so nice to be able to look at Word and Excel files without having to shut down and reboot to Windows.

---

<div class="post-metadata">

**Author:** ![Mort\_Furd](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@Mort\_Furd](https://boards.straightdope.com/u/Mort_Furd)\
**Post date:** [August 5, 2004, 7:10pm UTC](https://boards.straightdope.com/t/can-i-edit-an-excel-file-without-excel/258445/14 "2004-08-05T19:10:27Z")

</div>

Star Office IS [OpenOffice.org](http://OpenOffice.org). Sun supports the OOo project with money and programmers. OOo is free, and Sun sells a branded version with some extra bells and whistles that is calls Star Office.

OOo started out as Star Office. Sun bought Star Office from the German company that wrote it. Sun then open the source and got the OOo project going.
