Tuesday, August 26, 2008

Importing Dropdown list from HTML to Excel

As part of one task in a CMS development, may this blog serve as my personal notepad for future referencing :D

1. Needed to import the list of countries found in the country dropdown list in this online database.

2. Problem: How to import the list items (also viewable in View Source and can be tediously weeded out in any text editor) into tabular data,for example in MS Excel?

3. While on the targeted webpage with the needed content, save page as type txt, Encoded as Unicode (UTF-8).

4. Open MS Excel, File > Open > go to saved text unicoded file, then follow the wizard and series of steps in how to display the data in Excel, this time in tabular format.

-End-

This blog has been archived and is not maintained any longer. For similar useful posts, please visit www.jeromeesperanza.com

Search

Google