What MediaWiki is
MediaWiki table markup opens with {| and a class, marks headers with an exclamation mark and rows with |-.
Wikipedia editors and anyone running a MediaWiki install.
What Plain Text is
Plain text here means columns lined up with spaces, the way a command line tool prints a table.
Terminal output, log files, fixed-width exports from older systems.
What changes when you convert MediaWiki to Plain Text
Both cell styles are read: one cell per line, and several on a line separated by exclamation marks or double pipes, which is the form most Wikipedia tables use. Cell attributes before a single pipe are dropped, since style="text-align:right" is presentation rather than data. Wiki links come through as their display text, so [[France|the French Republic]] arrives as the French Republic, and reference markers are removed.
Columns are padded to the widest value. Width is counted in display columns rather than characters, so a table containing Chinese, Japanese or Korean text still lines up: those glyphs occupy two columns in a monospace font.
What carries over from MediaWiki to Plain Text
MediaWiki records 4 things about a table that plain text has no way to hold.
MediaWiki can hold a value that is itself a list or an object. plain text has only flat cells, so nested values are flattened into one cell rather than being spread across columns.
A line break inside a cell ends the row in plain text, so line breaks are replaced rather than carried through.
plain text has no separate idea of a header, so the column names become an ordinary first row and nothing in the file marks them as different from the data.
Anything visual in the MediaWiki - weight, alignment, colour, column widths - has no counterpart in plain text and is dropped. The values are what survives.
The identifier 007 comes out of the Plain Text as 007. Reading it as a number would have made it 7, and an id that changes value is worse than one that stays text.
The role "Analyst, data" survives with its comma, in one cell rather than split across two. That is the first thing to check in any converted table, and the usual place a Plain Text file goes wrong.
The quotes around Jonah "Jo" Pryce are left as a plain quote character in the Plain Text.