Sunday, February 9, 2014

Html to Excel

Many websites have data in html tables. If someone wanted to copy this data into an excel spreadsheet to make some analysis or plots, it is quite tedious and not straightforward. There is an online application that can help convert any html file or webpage directly to an excel file. This is one of the only web based application I have seen online. The application is quite easy to use. Follow the steps below:

1. Click the link below to visit the application


2. You can either click the upload button and select a html file or enter a website address into the textbox and the application will pickup the content automatically. 


3. Select the output excel format. The application supports saving both xlsx and xls file formats. If you are using Microsoft office version 2007 or later, you would be OK to use either of them (but xlsx should be the best). If you are using an older version, then select the xls format.


4. Click on the convert button and a popup will show the location of the excel file to download.


ODS to XLS

ODS file format (.ods file extension) is the Spreadsheet file format of openoffice and staroffice programs. Openoffice is the opensource free alternative for Microsoft Office. However, excel still remains the most popular office suite. If you ever receive or download an openoffice spreadsheet, it is not straightforward to open it in Microsoft excel and would need a special MS office extension to be installed. 

There are some online applications which can convert any ODS file to their excel counterpart XLS/XLSX formats. One such application and the usage instructions are given below:

1. Go to the application by clicking on the link below

ODS to XLS conversion tool

2. Click on the upload button and select the ODS file on your computer


3. Select the output format you desire, either xls or xlsx. If you have the pre 2007 office versions it is better to use xls though the preferred version if xlsx.



4. Click on the convert button and a popup will be shown with the link to download the excel file.


Convert Word to Excel

Recently, I got a document (Microsoft Word format) from one of my friends which had some interesting data in a table. I intended to plot some graphs and do some analysis on the data and hence wanted to copy the table into excel. I searched for an automatic tool to do the conversion for me and found an interesting tool. The instructions to use the Word to Excel Conversion is explained below.

1. Click on the link below to visit the application


2. Select the upload button; a dialog opens to select the file on your computer. Select the Microsoft word file (both doc and docx supported).


3. Select the output excel file format. The application allows to save the data both in the old xls format and the new xlsx file. In order to preserve as much formatting as possible, select the xlsx format.



4. Click on the convert button; a popup will be shown with a link to download the excel file. Right click and choose save as to download the file to your computer.