The .XLR format is the primary file extension for spreadsheets created using Microsoft Works.
Microsoft Works is an office suite available from the Microsoft Corporation. It is considered by most to be a smaller, less expensive version of the Microsoft Office suite; it includes the Microsoft Works word processor, the Works spreadsheet, and the Works database.
.XLR files are spreadsheets or charts created within 'Works', XLR files are fully importable into Microsoft Excel, Excel spreadsheets however are not fully compatible with Works and certain cell properties or data characteristics may be lost when importing Excel worksheets into Works.
If you need to open a .XLR spreadsheet but don't have Works or Excel installed on your computer try downloading the free Excel viewer (see links).
Apart from the XLR format Microsoft Works can also save worksheets into any of the following formats:
* .BKS - Works backup files. * .WKS - Works for windows 3.0 - Works 2000 spreadsheets. * .CSV - Comma seperated variable databases. * .TXT - ASCII unformatted tab-delimited text files. * .XLS - Excel worksheets. * .WK1 - Lotus 1-2-3 files.
Please rate how useful you found the information on this page:
(7 votes)
Comments (17)
showing
1-17
Ann
2008-07-29 08:32:40
#1
I do have excel, with windows xp, but I am unable to open an incoming docs with the .xlr extension, what do I need to do?
Prior
2008-07-29 19:16:27
#2
Hi Ann,
Have you tried manually renaming the file and changing the extension from .XLR to .XLS. ?
i.e. right-click file - rename - then manually change the extension as above.
I've not had the opportunity to try this, but have read that it works most of the time.
Steve
2008-09-25 11:33:22
#3
I manually renamed the file to .XLS as suggested above and it worked for me.
Thanks for the tip.
Johm
2008-10-20 17:56:36
#4
I have files created with Microsoft works spreadsheet some are xlr but will not open with ms works spreadsheet?
stteng
2009-02-23 09:36:01
#5
I have the same problem! I even renamed my XLR file to XLS to open it in Excel 2003!
Dale
2009-04-08 09:26:45
#6
I created a spreadsheet with Works 7.0 but now when I attempt to open it I get a message it's a XLR & can't be opened. Also in the works task launcher the spreadsheet icon is missing so I can't access my spreadsheets. Any solutions?
Krishan
2009-04-18 05:10:39
#7
Can I open Microsoft Works Spreadsheet even if I do not have MS Works on my PC?
Bill
2009-05-05 13:15:15
#8
Just right click on the file and choose 'open with' and pick excel.
Julie
2009-06-03 15:33:53
#9
I need to save an Excel file as type .xlr (MS Works spreadsheet) but I don't have the .xlr option in the drop-down "file types" option. How can I do this?
Craig
2009-07-06 03:09:13
#10
I used OpenOffice to open an .xlr file as it wouldn't open with Excel.
Bridgette
2009-10-01 15:12:14
#11
I had no problems saving my file and renaming from XLR to XLS. This was a 2006 Works version doc, and I opened it in a Windows Vista Excel. Thanks for the tip.
Shirley
2009-10-28 14:54:49
#12
I have a spreadsheet in my docutments & can't open it I have always opened it with microsoft works. It is an .xlr file I installed works & office & still can't open it. Can anyone help me?
adam
2009-11-30 21:34:55
#13
I received an xls spreadsheet through email and tried to save as xls but when I go to send it it will only send in .xlr, which the people I'm sending it to can't open, is there any way I can make it send in xls?
Emmanuel Alba
2010-01-10 19:33:21
#14
You just right click on the .xlr file icon and choose 'OPEN WITH' and select 'Microsoft Excel' - it will work then.
kymie
2010-03-30 04:40:05
#15
I have typed a document up in works, but need to send it to people who only have word and they cant open it! How can I change it?
Herb
2010-12-13 12:17:06
#16
Was unable to change name of XLR files and they would not open under notepad. Running VISTA Home Premium.
.
steve
2011-05-25 20:31:27
#17
Saved it as xlr and then changed it to xls. Worked with no problems.
Thanks for the tip.
