Excel to Unordered list?

[MrPunkin]

Hello everyone. I have a dilema. I need to find a way to convert an excel spreadsheet into an unordered list. I dont care if I have to go roundabout through a tab-delimited text file, CVS file, etc etc as long as I can get there. This doesn't need to be dynamic, just a one time deal. What I am looking for is to have each column just become a list item <li> and have one of the second column become a link for the first column, or whatever works easiest.

3 columns, 2 will be list items, one will be the link for one of the columns. Each row though in excel needs to become wrapped in its own ul tag.

[ray326]

Sounds like a Perl job to me. Export as tab separated and process it with Perl. Read each line and split it on \t. Then print

<ul><li>$col1</li><li><a href="$col2">$col3</a></li></ul>

That's just Perlish pseudo code since I no longer remember the array syntax.