JSON To MediaWiki Table

Login

Email
Password

Don't have an account yet?

Go to Sign up

Input Data
Example Sample {{ showCoderInput ? 'Choose File' : 'Enter Data' }}

                                
Valid JSON Invalid JSON — Cannot convert to JSON Array
Output Data
{{ copied ? 'Copied!' : 'Copy to Clipboard' }} Download File
Properties
Convert JSON to MediaWiki online — paste, edit, and download MediaWiki.

Output Mode:
Wikitable Infobox

Convert Restart

JSON to MediaWiki Table — Free Online Wikitable and Infobox Generator

What Is MediaWiki?

MediaWiki is the open-source wiki engine that powers Wikipedia, Fandom (Wikia), Wikimedia Commons, and thousands of corporate and community wikis. It uses a markup language called wikitext for page formatting.

PlatformURLUses MediaWiki
Wikipediawikipedia.orgYes
Fandom (Wikia)fandom.comYes
Wikimedia Commonscommons.wikimedia.orgYes
Wikiquotewikiquote.orgYes
Wiktionarywiktionary.orgYes
Many corporate wikisInternalYes

MediaWiki Table Syntax

MediaWiki uses pipe-based syntax to define tables:

{| class="wikitable"
|-
! Header 1 !! Header 2 !! Header 3
|-
| Cell 1 || Cell 2 || Cell 3
|-
| Cell 4 || Cell 5 || Cell 6
|}

ElementSyntaxDescription
Table start`{`
Table end|}Closes the table
Row separator|-Starts a new row
Header cell! textBold header cell
Header cells in line! H1 !! H2 !! H3Multiple headers on one line
Data cell| textRegular data cell
Data cells in line| C1 || C2 || C3Multiple cells on one line
CSS classclass="wikitable"Standard Wikipedia table styling

What Is a Wikitable?

A wikitable is a standard MediaWiki table using the class="wikitable" CSS class. It produces a bordered, styled table with a gray header row — the default table style on Wikipedia.

{| class="wikitable"
|-
! Country !! Population !! Capital
|-
| Japan || 125,000,000 || Tokyo
|-
| France || 67,000,000 || Paris
|}

Wikitables appear in thousands of Wikipedia articles for data presentation: comparison tables, statistics, specifications, and schedules.

What Is a MediaWiki Infobox?

An infobox is a sidebar summary panel, typically displayed at the top-right of Wikipedia articles. It uses the {{Infobox}} template with label-data pairs.

{{Infobox
| title = My Topic
| label1 = Population
| data1 = 125,000,000
| label2 = Capital
| data2 = Tokyo
| label3 = Language
| data3 = Japanese
}}

Infoboxes present key facts at a glance. Common on Wikipedia for countries, people, companies, films, species, and products.

Wikitable vs. Infobox

FeatureWikitableInfobox
LayoutFull-width tableRight-aligned sidebar
StructureRows and columnsLabel-data pairs
Best forMulti-row data, comparisons, statisticsSingle-entity summaries, key facts
CSS classclass="wikitable"{{Infobox}} template
Wikipedia usageIn-article data tablesTop of article (right side)
InputArray of objects (rows)Single object (key-value pairs)
ColumnsMultiple columnsTwo (label + data)

Why Convert JSON to MediaWiki?

Use CaseDescription
Wikipedia editingAdd data tables to Wikipedia articles
Fandom wikisCreate tables and infoboxes for game, movie, or TV wikis
Corporate wikisInternal knowledge bases using MediaWiki
DocumentationEmbed data tables in wiki-based documentation
Data migrationMove structured data into wiki pages
Comparison tablesGenerate comparison tables for Wikipedia
Academic wikisAdd research data to university MediaWiki installations

Core Features

1. Dual Input Modes

  • File Upload: Drag and drop or select a .json file.

  • Code Editor: Paste or type raw JSON with syntax highlighting and real-time validation.

2. Two Output Modes

Wikitable Mode

Generates a standard {| class="wikitable" ... |} table with headers and data rows.

Input JSON:

[
   {"country": "Japan", "population": 125000000, "capital": "Tokyo"},
   {"country": "France", "population": 67000000, "capital": "Paris"},
   {"country": "Germany", "population": 83000000, "capital": "Berlin"}
]

Output:

{| class="wikitable"
|-
! country !! population !! capital
|-
| Japan || 125000000 || Tokyo
|-
| France || 67000000 || Paris
|-
| Germany || 83000000 || Berlin
|}

Infobox Mode

Generates an {{Infobox}} template with label-data pairs from a single JSON object.

Input JSON (single object or first object in array):

{
   "name": "Mount Fuji",
   "elevation": "3,776 m",
   "location": "Japan",
   "type": "Stratovolcano",
   "last_eruption": "1707"
}

Output:

{{Infobox
| title = Mount Fuji
| label1 = name
| data1 = Mount Fuji
| label2 = elevation
| data2 = 3,776 m
| label3 = location
| data3 = Japan
| label4 = type
| data4 = Stratovolcano
| label5 = last_eruption
| data5 = 1707
}}

3. Privacy

All processing runs entirely in your browser. No data is uploaded to any server.

How to Use This JSON to MediaWiki Table Converter

Step 1: Provide Your JSON Data

Choose one of two input methods:

  • Upload a file: Click "Choose File" and select a .json file, or drag it into the upload area.

  • Paste data: Click "Enter Data" to switch to the code editor. Paste your JSON. A "Valid JSON" badge confirms correct formatting.

Step 2: Choose Output Mode

In the Properties panel:

  • Wikitable: For multi-row data tables (arrays of objects)

  • Infobox: For single-entity summaries (label-data pairs)

Step 3: Convert

Click Convert. The MediaWiki markup appears in the "Output Data" panel.

Step 4: Copy and Paste into MediaWiki

  • Click Copy to Clipboard.

  • Open a MediaWiki page (Wikipedia, Fandom, or any MediaWiki site).

  • Click Edit (or Edit source on Wikipedia).

  • Paste the markup into the editor.

  • Click Publish changes.

Complete Example

Example — Wikitable: Country Comparison

Input JSON:

[
   {"country": "United States", "gdp_trillion": 25.5, "population_million": 331, "continent": "North America"},
   {"country": "China", "gdp_trillion": 18.3, "population_million": 1412, "continent": "Asia"},
   {"country": "Japan", "gdp_trillion": 4.2, "population_million": 125, "continent": "Asia"},
   {"country": "Germany", "gdp_trillion": 4.1, "population_million": 83, "continent": "Europe"},
   {"country": "United Kingdom", "gdp_trillion": 3.1, "population_million": 67, "continent": "Europe"}
]

Configuration: Output Mode = Wikitable

Output:

{| class="wikitable"
|-
! country !! gdp_trillion !! population_million !! continent
|-
| United States || 25.5 || 331 || North America
|-
| China || 18.3 || 1412 || Asia
|-
| Japan || 4.2 || 125 || Asia
|-
| Germany || 4.1 || 83 || Europe
|-
| United Kingdom || 3.1 || 67 || Europe
|}

Complete Example — Infobox: Company Profile

Input JSON:

{
   "name": "Example Corp",
   "type": "Public",
   "founded": "1998",
   "headquarters": "San Francisco, CA",
   "founder": "Jane Smith",
   "employees": "50,000",
   "revenue": "$12.3 billion",
   "website": "example.com"
}

Configuration: Output Mode = Infobox

Output:

{{Infobox
| title = Example Corp
| label1 = name
| data1 = Example Corp
| label2 = type
| data2 = Public
| label3 = founded
| data3 = 1998
| label4 = headquarters
| data4 = San Francisco, CA
| label5 = founder
| data5 = Jane Smith
| label6 = employees
| data6 = 50,000
| label7 = revenue
| data7 = $12.3 billion
| label8 = website
| data8 = example.com
}}

Example — Wikitable: Programming Language Comparison

Input JSON:

[
   {"language": "Python", "year": 1991, "typing": "Dynamic", "paradigm": "Multi-paradigm"},
   {"language": "Rust", "year": 2010, "typing": "Static", "paradigm": "Multi-paradigm"},
   {"language": "Go", "year": 2009, "typing": "Static", "paradigm": "Concurrent"},
   {"language": "TypeScript", "year": 2012, "typing": "Static", "paradigm": "Multi-paradigm"}
]

Output:

{| class="wikitable"
|-
! language !! year !! typing !! paradigm
|-
| Python || 1991 || Dynamic || Multi-paradigm
|-
| Rust || 2010 || Static || Multi-paradigm
|-
| Go || 2009 || Static || Concurrent
|-
| TypeScript || 2012 || Static || Multi-paradigm
|}

MediaWiki Markup Tips

TipDetails
Use class="wikitable"Standard Wikipedia table styling
Use !! for inline headers! H1 !! H2 !! H3 on one line
Use || for inline data| C1 || C2 || C3 on one line
Sortable tablesAdd class="wikitable sortable" for click-to-sort
Collapsible tablesAdd class="wikitable collapsible"
Merge cellsUse |colspan="2"| or |rowspan="2"|
Cell attributesAdd after |: | align="right"| 42
Preview before savingAlways preview MediaWiki edits before publishing

Frequently Asked Questions (FAQ)

  • Does the tool upload my data?

    No. All conversion happens locally in your browser using JavaScript. Your data never leaves your device.

  • What is MediaWiki?

    MediaWiki is the wiki engine that powers Wikipedia, Fandom, and thousands of other wikis. It uses a markup language called wikitext for formatting pages, tables, and templates.

  • What is the difference between Wikitable and Infobox?

    A Wikitable is a full-width data table with rows and columns (like a spreadsheet). An Infobox is a right-aligned sidebar panel with label-data pairs summarizing a single topic. Use Wikitable for multi-row data; use Infobox for entity summaries.

  • Can I use the output on Wikipedia?

    Yes. The generated markup uses standard MediaWiki syntax. Click "Edit source" on any Wikipedia article and paste the markup. Preview before publishing.

  • What input format works best for Wikitable?

    A JSON array of objects: [{"key": "value"}, ...]. Each object becomes a row, and keys become column headers.

  • What input format works best for Infobox?

    A single JSON object: {"key": "value", ...}. Each key-value pair becomes a label-data row in the infobox.

  • Can I make the table sortable?

    Yes. Manually change class="wikitable" to class="wikitable sortable" in the output. This adds click-to-sort column headers.

  • Does the tool work with Fandom wikis?

    Yes. Fandom (formerly Wikia) uses MediaWiki. The output is compatible with Fandom wiki pages.

  • Is there a file size limit?

    The tool processes data entirely in your browser. Files up to 10 MB typically convert without issues on modern hardware.

  • Can I use this on mobile?

    Yes. The tool is responsive and works on smartphones and tablets.

Featured Tools

Featured tools that you might find useful.

Popular Tools

List of popular tools that users love and frequently use.

New Tools

The latest tools added to our collection, designed for you.

Topics

The tools grouped by topics to quickly find what you need.
Free online Excel to JSON converter. Transform XLSX, XLS, XLSM files into JSON arrays, objects, or keyed formats instantly in your browser — no upload, 100% private.

Excel To JSON

Free online Excel to JSON converter. Transform XLSX, XLS, XLSM files into JSON arrays, objects, or keyed formats instantly in your browser — no upload, 100% private.
Free Excel to CSV converter. Convert XLSX, XLS, XLSM to CSV instantly in your browser. No upload, 100% private. Edit, transpose, deduplicate before exporting.

Excel To CSV

Free Excel to CSV converter. Convert XLSX, XLS, XLSM to CSV instantly in your browser. No upload, 100% private. Edit, transpose, deduplicate before exporting.
Free online Excel to SQL converter. Generate CREATE TABLE and INSERT statements from spreadsheets for MySQL, PostgreSQL, SQLite, and SQL Server. Supports batch insert, primary keys, and type inference.

Excel To SQL

Free online Excel to SQL converter. Generate CREATE TABLE and INSERT statements from spreadsheets for MySQL, PostgreSQL, SQLite, and SQL Server. Supports batch insert, primary keys, and type inference.
Free online Excel to ASCII table converter with 10 border styles (MySQL, Unicode, reStructuredText, and more). Add code comment wrappers in 8 languages. Supports text alignment. Client-side processing.

Excel To ASCII Table

Free online Excel to ASCII table converter with 10 border styles (MySQL, Unicode, reStructuredText, and more). Add code comment wrappers in 8 languages. Supports text alignment. Client-side processing.