I have a solution. It's not pretty, but it works.

1 - From Excel, export the table as .CSV (comma-separated values) 2 - Open the file in Word (or another word processor), then do the following: - Find and replace all commas (,) with the pipe (|) character - Find and replace all (^p) with the following string (^p|-^p|), where ^p is CR-LF (carriage return-line feed, i.e. new line) 3 - copy and paste this into MediaWiki, add the first and last line of the table format, and you're done

For example, starting with this csv file: field 1, field 2, field 3 field 4, field 5, field 6

After applying the word processor magic, it becomes:

|field 1| field 2| field 3 | |field 4| field 5| field 6 Copy and paste into the table format in mediawiki:

{| border="1" cellpadding="5" cellspacing="0" |field 1| field 2| field 3 | |field 4| field 5| field 6 |}

Evelyn Yoder http://www.linkedin.com/in/evelynyoder

On Fri, Oct 23, 2009 at 11:03 AM, Jan Steinman Jan@bytesmiths.com wrote:

...

From: "Sandy Rozhon" srozhon@oh.rr.com

I used this site with great success....very easy. All you do is copy all the cells you want and paste them into their form, then it regurgitates the code for your wiki.

http://excel2wiki.net/

Lovely! It properly converts Apple Numbers stuff, as well.

I guess the incorrect handling of delimited separators is not so important as long as you only do copy/paste from Excel or Numbers, which defaults to tab delimiters.

But be aware that this extension probably will not work properly with arbitrary exported CSV data.

:::: MacOS X -- when you need today what Bill Gates has promised you tomorrow. :::: :::: Jan Steinman http://www.VeggieVanGogh.com ::::

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l