How to read Exported Excel file?

Question

I have exported entity records by Export to Excel , and saved it in local drive.What to do to make this data in tabular format.when I opened it in notepad,I show, its having data.I have only OpenOffice 3.3 installed in my machine.I don't have MS Office Excel.But in OpenOffice its not showing anything.

FYI, I want to add new/update data, then import it to CRM. My target is to add new data and create a CSV file.

Please, suggest me a way.

Thanks.

Do you want to interact programmatically with the csv file? – Bvrce Apr 10 '13 at 12:22 — Bvrce, Apr 10 '13 at 12:22

score 1 · Accepted Answer · answered Apr 10 '13 at 13:10

1

The files generated by Export to Excel functionality are in fact XML documents.

When you select Static Worksheet with records from this page without select Make this data available for re-importing by including required column headings you will get a file with XLS extension, but the file format is still XML.

When you select other options for export the data you will get a file with XML extension.

In both cases the file isn't compatible with OpenOffice, LibreOffice or other online editors (as far as I know), also if you upload the file to SkyDrive and try to open with Excel Web App will returns an error.

You need to use Microsoft Excel to view or modify these files.

answered Apr 10 '13 at 13:10

Guido Preite

14,905
4
36
65

I tried it with Google Drive, it works. – Bvrce Apr 10 '13 at 13:17
1

I tried also, I uploaded the XLS file but Google Drive throws "Sorry an error occurred", maybe you uploaded a file already opened and saved from Excel. – Guido Preite Apr 10 '13 at 13:21
I actually uploaded an unrelated xlsx file and assumed that it would be the same ;> TIL that the exported file is an xml file with an xls extension (hence the error message: the file format and extension do not match) – Bvrce Apr 10 '13 at 13:27
so far for me Guido is right. LibreOffice,web readers,and google Drive didn't worked. – Tamal Kanti Dey Apr 10 '13 at 13:27
So your unexplored options are: Office 365, full Office, or Office Starter. – Bvrce Apr 10 '13 at 13:43

Bvrce · Answer 2 · 2013-04-10T12:37:23.447

0

The best thing to do would be to buy Microsoft Office 2013 or Microsoft Office 365, but you could:

Upload the xls file to Google Drive, make changes, and download as csv
Install Microsoft Office Starter for free
Install Libre Office 4 for free

The export is an xls file and is meant to be an export to Micosoft Office Excel.

edited Apr 10 '13 at 12:37

answered Apr 10 '13 at 12:26

Bvrce

2,170
2
27
45

How to read Exported Excel file?

2 Answers2