User:Gloverepp/Using Excel for Wiki

Please put your suggestions or comments on the Discussion page. thanks, enjoy GloverEpp ( talk ) 13:58, 22 April 2010 (UTC)

Here's how I use Excel to create wiki pages. The bottom line is that I use html instead of the wiki technique of using |- to separate each line. This way, I can sort within Excel and not have to worry about all those |- empty lines.

Steps.
 * 1) Build whatever you want in Excel. BUT, use    instead of |- in the first column and  or   instead of || to separate the fields.  I think the example will help show this.
 * 2) Copy your Excel cells into your clipboard.
 * 3) Paste them into the input box here to remove extra whitespace. Click the Replace Whitespaces button.
 * 4) Copy results into Notepad from the above step for further cleansing, if need be. In my case, I had tons of empty , so I removed them in Notepad.
 * 5) Copy the results from Notepad into a wiki page. This all sounds like such a cluge, but it works really well.

Looks like this as copied out of Excel
There are tons of white space that you can see if you edit this. I chose to remove it instead of passing it on to wiki. Also, in Excel, each line is begun with the html  which is not obvious when you look at this presentation.