User:Buaidh/Wikitables
Appearance
Easy maintenance of large wikitables
[edit]The following is a brief description of an easy method of updating a wikitable using a word processor, such as Microsoft Word™, and a spreadsheet application, such as Microsoft Excel™.
- Edit the Wikimedia section containing the wikitable. Copy and paste the wikitable as Unicode text into a word document.
- Replace all paragraph marks ^p with tab marks ^t.
- Replace all occurrences of ^t|- with ^p|-.
- Copy and paste all text into a spreadsheet as unformatted Unicode text.
- If your wikitable is a simple table (without rowspan= or colspan=), you should have a simple spreadsheet with every cell containing the code for the corresponding cell of the wikitable. More elaborate wikitables will require manual manipulation.
- Edit data in the spreadsheet.
- Copy and paste spreadsheet cells into a word document as unformatted Unicode text.
- Remove tabs by replacing all tab marks^t with nothing.
- Replace wikitable with the text from the word document.