# problem reading xls file [closed]

I have a problem with my xls files . when I open them all the words and character are not readable . I mean they should be in persian or utf8 incoding but there is just lots of signs and characters that make no sense . I converted my file with zamzar online file converting to ods file type , then I was available to read the file and everything was fine . but for each file I can't convert it to ods . please help me out .

this is my file : https://www.dropbox.com/s/nbi8nii1iweu4ey/FileName.xls

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-29 15:52:45.760894

Sort by » oldest newest most voted

The problem is that your files (or at least the sample provided) are not true XLS files (and this confuses LibreOffice). They are HMTL files with a wrong extension.

The easiest way to solve this is to 1) rename the files to .html; 2) Open with LO (it will open in Writer); 3) select the whole table (Table, Select, Table); 4) Change font to Tahoma (at least in my PC some characters were still showing as empty squares if I didn't change the font) 5) Copy and Paste in a New ODS spreadsheet.

Hope this helps ;)

more

Disregard my comment below, it is the same as that suggested by @Pedro.

( 2013-04-08 13:25:56 +0200 )edit

Your file is a HTML table and not an XLS file. These types of files are often generated by retail software and given an XLS extension in order to allow automatic file association with office software. I am not sure how your file was generated, but like so many of these types of files, it contains very poorly formatted HTML e.g., there is no !DOCTYPE declaration to tell the interpreter the data is UTF-8 encoded, and no basic structural elements such as <html>, <head>, or <body>.

The easiest way to get your data is:

1. Change the file extension from XLS to HTML;
2. Open the HTML file with Writer;
3. Select the entire table;
4. Edit > Copy;
6. Edit > Paste.
more