• Home

Can Openoffice Open Excel

 
Computer Programming/Business and Industry/Microsoft Excel/OpenOffice

Interestingly, OpenOffice can open files that have been saved in substantially older versions of Microsoft Office than Office 2016 can. Open Space can even open some corrupted Word files that Office 2016 can’t. For an IT department, it might be worth having a copy installed for that reason alone.

  1. How to Convert OpenOffice to Excel. This wikiHow teaches you how to save an OpenOffice Calc spreadsheet to the Microsoft Excel.xlsx format. Open Microsoft Excel. It's in the All Apps area of the Start menu in Windows.
  2. LibreOffice has more community developed plugins in its package, so OpenOffice may not have xlsx capabilities. Who knows if every weird format will work correctly either. Ubuntu 12.10 has libreoffice 3.6.2, which really should have the support you need.

Save your file as Excel xls format.

Use the File-->Save As.. menu and select the file type inthe save dialog.

For a video How to, see related links.

How do you convert from Excel to open office?

Open Office will happily read Excel files - and save them either in Open Office or Excel formats !

How do you convert Excel into open office?

Usually there is no need to convert, since Open Office can read excel files (except Open Office probably will have problems with macros). If you have Excel 2007, then save the file in Office 2003 compatibility mode.

What other program is similar to Excel in Open Office?

Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice. Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice. Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is LibreOffice. Calc is the equivalent program in Open Office to Excel in Microsoft Office. Another full office suite is… Read More

How do you convert Open Office file to Excel file?

When you come to save your spreadsheet - use 'Save as' instead of save, and select the correct excel version from the drop-down menu.

How do you open an Excel file in Open Office?

Open Office will happily open Excel files. You may have to play around with the formatting etc, but it will certainly import the data from an Excel spreadsheet without any problems.

How do you convert an xls file to xlt?

How do open multiple workbooks in the same instance of Excel?

Once Excel is open, go to the File Menu or the Office button and pick and open the file you want. Repeat for any files you want to open. There is no need to re-open Excel itself. Once Excel is open, go to the File Menu or the Office button and pick and open the file you want. Repeat for any files you want to open. There is no need to re-open Excel itself. Once… Read More

What is an alternative to excel?

How do you convert Microsoft file to open office file?

Open the MS Office file in Open Office, then save in Open Office format.

My current Microsoft does not have Excel can you convert?

No. Excel is a program you need to purchase, either as stand-alone or with MS Office.

Already saved in open office now convert into Excel?

Simply use the 'save as' function - and choose the type of file you want to save it as from the drop-down menu.

How do you convert xlsx to xls?

If you have Excel 2007 or 2010, you can do a Save As to save the file in Excel 2003, which was the last version that used the xls extension. If you do not have those, you can try Open Office or Google Docs or download and install FileFormatConverters.exe from Microsoft Homepage.

How you can open my Excel files?

First you need the version of Excel that the files were created in, or a later version. The open Excel. Go to the File menu or the Office button or press Ctrl - O and select the option to open your file. Once you find it, Excel should be able to open it.

How do you convert windows Excel 7 to windows Excel 97-2003 version?

Open the workbook in Excel 7 and SaveAs the format you want.

How do you convert an Excel document to PDF?

If you are using Office 2003 or 2007 you will need an add-in - 'save as PDF/XPS' from Microsoft official website, then you can save your office files to PDF format directly. Open file Click office button Select 'save as' Choose 'PDF or XPS' Your excel is saved to PDF now With Office 2010, there is a 'save as PDF/XPS' function bulit-in, so you can directly follow above steps to convert your excel to PDF… Read More

Does Open office include Word and Excel?

It does not include Word and Excel, but it has its own word processor and its own spreadsheet.

Can we open windows excel sheets in nexus 6?

You can. Microsoft released the mobile version of their Microsoft Office suite, called Office Mobile. You can also open an Excel spreadsheet using Google's Sheets app.

Does e71 have Microsoft Excel?

No it has QuickOffice. With Quick Office you can open and edit MS Office file formats which includes Excel. Though QuickOffice is not by Microsoft it supports most of the functions of MS Office.

I need an app which can open Excel files edit them and most of all let people put in their signatures?

If you are looking for an app that can open and edit excel files, try open office.

Which window is used to display an open workbook file?

Name two spreadsheet programs?

How do you convert an Excel 2003 file to Excel 2007?

Open the file with Excel 2007 and save as an Excel 2007 file. Fallout new vegas dead money letting go. Other than that, you might be able to find a file converter program to do it for you, but I am not sure why.

How do you repair a corrupted excel file?

You can try following methods- Repair with Open and Repair: File > Open > Select corrupt file > Click Open and Repair > Choose either Repair or Extract data. Open with Open Office: You can try to open your Excel file in Open Office. Save in HTML Format: Open your Excel file and save it in HTML file format. By doing this, you may be able to filter out the corrupted elements. Try 3rd party… Read More

What are the various versions of Microsoft Excel?

( There was no version 1) Excel 2.0 for Windows Excel 3.0 Excel 4.0 Excel 5.0 No version 6 Excel for Windows 95 (version 7.0) in Office 95 Excel 97 (version 8.0) in Office 97. Excel 2000 (version 9.0) in Office 2000 Excel 2002 (version 10) in Office XP Office Excel 2003 (version 11) in Office 2003 Office Excel 2007 (version 12) in Office 2007 No version 13 Excel 2010 (version 14) in Office 2010… Read More

Does Microsoft Office Excel 2007 displays a warning whenever you open a workbook?

How do you open xlw files with excel?

How can one convert an Excel spreadsheet to an iif file?

One can convert an Excel spreadsheet to an IIF file using the Microsoft Office 2010 software suite. Also one can convert such files using online services like Spreadsheet Converter and Accountant Pro.

What is the advantage of Open Office to Microsoft Office Excel 2003?

Open Office is free and is constantly updating as it is open-sourced while microsoft office costs money. To get updates, you will have to buy a new version. Also, since there has already been a few newer versions since mircosoft office 2003, open office would be better that office.

Can you open Excel with Microsoft PowerPoint?

You can put a link into a Powerpoint document that will open an Excel file in Excel. You can put a link into a Powerpoint document that will open an Excel file in Excel. You can put a link into a Powerpoint document that will open an Excel file in Excel. You can put a link into a Powerpoint document that will open an Excel file in Excel. You can put a link into a… Read More

What in Excel is the Office button?

Office button will have all option like to save, save as a file , open a file , print etc.

What do Excel convert all formulas from?

Excel does not convert formulas from anything. Formulas are displayed as you enter them in cells. [[What do excel convert all formulas from#ixzz15yaIeMD4 ]]

What are some free programs you can use to modify excel documents?

Is Microsoft Excel compatible on Unix?

While Microsoft Office is not available on Unix-like systems, you can use other offices suites to open the Excel file format. Consider trying LibreOffice or OpenOffice.org; both are excellent open-source office suites that support most Microsoft Office file formats.

How do you convert Microsoft Excel 2007 file to 2000?

open file in excel 2007 then press ribbon and go to Save as, you will see Excel 1997-2003 Workbook option, click on it and save file.

Can you convert an Excel 2003 spreadsheet to 2010 to add more rows?

If you have 2010, then you can open it and save it as a 2010 workbook. It won't open with Excel 2003 after that though so you cannot have the benefit of the extra rows in Excel 2003. That is one of the reasons for using 2007 or 2010.

How Can you Open A corrupt Ms Office 7 Excel File?

You could try to open it with LibreOffice (or another OpenOffice clone) That had worked for me with corrupt files from previous versions of Microsoft Office).

Is Excel a part of Microsoft office?

What program would you use to make a spreadsheet?

A couple of options are Microsoft Excel or Open Office Calc (open-source free software).

Disadvantage of open office?

The native format (.ods) cannot be read by (older?) versions of MS Excel.

How you convert open office file into ms office?

Open document in Open Office then go to File -> Save As, in Save As window that will open look for Save as type: , press arrow on right side and choose from list version of Word document.

What are some spreadsheet applications other than Microsoft Excel?

Try Star Office or Open Office, both of which are free. See the links below.

How do download Excel?

You can only download trial versions of Excel, not full versions. If you want a free spreadsheet program, then try Open Office. See the website below.

Is openoffice 3 application called base is most similar to the Microsoft Excel program?

Nope - Open Office base is a database program, MS Excel is a spreadsheet.

If one is sent an attachment in Excel and you don't have that program is there another way to open it?

You should be able to open an Excel document in Word. I've done that before with no problems at all. Presuming you don't have Word (since you don't have Excel, and they usually come bundled together in Microsoft Office), you can open Excel files in Apple's Numbers (part of iWork '08), or in NeoOffice or OpenOffice.org.

Can open office open excel documents

What is better Microsoft Excel or Open Office?

It depends on your point of view - they are both equally good programs. They both do the same thing (ie create spreadsheets. The main difference is Excel is a single program, where Open Office is a 'suite' of programs comprising spreadsheet, database, word-processor etc.

How do you open files without Microsoft office?

Download Microsoft Office Starter. It's free. It's not the fastest program & you need Internet access each time you open( word, excel..) but it works.

How do you open a Microsoft Word document in OpenOffice?

Open office will read the file without any problems. You can either save any changes as a Word document or convert it to Open Office writer.

Can't open xls files?

If you can't open .xls files you don't have Microsoft Excel, so you need to either buy it or download the free Open Office from openoffice.org

Are Open Office and Excel completely compatible?

Not completely, but very close to. So the majority of files will work between them.

What does Excel convert all formulas from?

Excel does not convert formulas from anything. Formulas are displayed as you enter them in cells.

What is the best way to open ods files in Excel 2003?

Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?

The file I want to open shouldn't contain anything fancy, so I probably don't need a solution that understands every detail of the format.

svick
svicksvick
6741 gold badge6 silver badges26 bronze badges

4 Answers

Using OpenOffice is probably the easiest option IMO because there's no file format conversion necessary and OpenOffice is freely available.

There is a BSD licensed Microsoft Office 2003 plugin that is available, OpenXML/ODF Translator Add-in for Office. I don't have Microsoft Office so I'm unable to try it.

studiohack
11.3k18 gold badges80 silver badges114 bronze badges
SnealSneal

Can Openoffice Open Excel

Can Openoffice Open Excel

Would it be best if I just used LibreOffice (or OpenOffice)?

Yes, it would probably work best if you just used Libre/OpenOffice. As much as OpenOffice does a good job of viewing Microsoft files, it doesn't do a perfect job. Sometimes there will be little differences (more noticeable with word documents), so it's always best to use Office for Microsoft files and OpenOffice for the open formats. But once you do that, you can save it as an xls and then it should open in Excel 2003 just fine.

studiohack
11.3k18 gold badges80 silver badges114 bronze badges
AaronAaron
7221 gold badge7 silver badges12 bronze badges

To add to the previous comments:

The converter for opening .ods files in Microsoft Excel 2003 is very clumsy to use. You need the Compatibility Pack and then you need the Converter on top of that. I don't know how well it converts formulas, especially for the most-recent versions of OpenOffice.org and LibreOffice. I definitely don't recommend this path for Office 2003 if you need to return an .ods.

Another solution is to use either of OpenOffice.org or LibreOffice.org to open them. Both have Save As .. Microsoft Excel 97/2000/XP (.xls) that is usable in moving the spreadsheet to Microsoft Excel if that is where you need it. If you just want to view and use the spreadsheet, you should use one of those applications. LibreOffice has more-recent releases while Apache OpenOffice won't produce a successor to OpenOffice.org 3.3 until farther into 2012. It's your choice.

orcmidorcmid

If your files do not hold sensitive data you can upload the ods file to Google Drive. Afterwards open the file as spreadsheet, then use the top menu to download the file as XLS or XLSX. Google does the conversion for you.

Disclaimer: I could not open some files in Excel 2003 after conversion. If you run into the same problem, open the spreadsheet in Google Drive, mark all cells, copy, paste them into a newly created spreadsheet. Downlaod the new spreadsheet, then it works.

Kai NoackKai Noack
1,0402 gold badges17 silver badges32 bronze badges

protected by slhckSep 19 '13 at 6:40

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged microsoft-excelopenofficemicrosoft-excel-2003libreoffice or ask your own question.