Off-topic: Excel to Wiki Table Converter

I work quite a lot with Wikipedia systems (mostly mediawiki-based) to structure data and make it accessible to other people at my job. Since I happen to love tables as a way to provide overviews and summaries of complex information, I keep creating wiki tables. Editing tables in a wiki is pretty painful, especially when it is time to do things like add columns. Excel is a much superior tool for this purpose, and I have been looking for a tool to let me create tables in Excel and then get a wiki rendering of them for insertion into a wiki. Finally, I have found it! Here, you can find a pretty good Excel VBA macro that lets you select a range of cells and then get a wiki table code corresponding to it on your clipboard, ready to paste into the wiki site. Thanks a million times to the creators of that tool, it is really useful. Note that in Office 2007, you must save documents in .xlsm, macro-enabled, format to be able to save the macro with your file.

One thought on “Off-topic: Excel to Wiki Table Converter”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.