User:Gloverepp/Using Excel for Wiki

Image:Example of html in Wiki format 2.jpg

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 [http://www.textfixer.com/tools/remove-white-spaces.php 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.