MediaWiki to JSON Converter

About MediaWiki to JSON Converter

Convert MediaWiki tables to JSON (JavaScript Object Notation) format for use in web development, APIs, databases, and data processing applications. JSON is the most popular data interchange format on the web.

Key Features

• Multiple Formats: Array of Objects or Array of Arrays
• Type Detection: Automatically converts numbers, booleans, and null values
• Header Support: Use first row as object keys
• Pretty Print: Optional formatted output with indentation
• RFC 8259 Compliant: Generates valid JSON according to the standard
• File Upload: Upload .wiki files directly
• Instant Preview: Real-time conversion as you type
• Copy & Download: Easy export options

How to Use

1. Input MediaWiki Table: Paste your MediaWiki table or upload a .wiki file
2. Configure Format: Choose between object or array format
3. Enable Pretty Print: Toggle formatted output if needed
4. Review Output: The JSON updates automatically
5. Copy or Download: Use the Copy button or download as .json file

Output Formats

• Array of Objects: Each row becomes an object with header names as keys (best for databases and APIs)
• Array of Arrays: Simple nested array structure (best for spreadsheets and data processing)
• Pretty Print: Formatted with 2-space indentation for readability
• Compact: Minified output without whitespace for smaller file size

Example Conversion

MediaWiki Input:

{| class="wikitable" border="1"
! Name !! Age !! City !! Department
|-
| John Doe || 28 || New York || Engineering
|-
| Jane Smith || 34 || London || Marketing
|}

JSON Output (Array of Objects):

[
  {
    "Name": "John Doe",
    "Age": 28,
    "City": "New York",
    "Department": "Engineering"
  },
  {
    "Name": "Jane Smith",
    "Age": 34,
    "City": "London",
    "Department": "Marketing"
  }
]

JSON Output (Array of Arrays):

[
  ["Name", "Age", "City", "Department"],
  ["John Doe", 28, "New York", "Engineering"],
  ["Jane Smith", 34, "London", "Marketing"]
]

Common Use Cases

• Web Development: Use table data in JavaScript applications
• REST APIs: Create JSON payloads for API requests
• NoSQL Databases: Import data into MongoDB, CouchDB, or Firebase
• Data Processing: Process table data with Python, Node.js, or other languages
• Configuration Files: Create config files from table data
• Testing: Generate test data and fixtures

Type Detection

The converter automatically detects and converts data types:

• Numbers: "42" → 42, "3.14" → 3.14
• Booleans: "true" → true, "false" → false
• Null: "null" or empty cells → null
• Strings: Everything else remains as strings

MediaWiki Table Support

Supports standard MediaWiki table syntax:

• Table opening with {|
• Header rows with ! delimiter
• Row separators with |-
• Data rows with | delimiter
• Cell separators with ||
• Table closing with |}

JSON Standard

This converter generates JSON compliant with RFC 8259:

• UTF-8 encoding
• Proper string escaping
• Valid number formats
• Standard boolean and null values
• Correct array and object syntax

Tips for Best Results

• Use "Array of Objects" format for database imports and API payloads
• Use "Array of Arrays" format for simple data processing
• Enable pretty print for human-readable output
• Disable pretty print for smaller file sizes
• Ensure header row contains unique column names
• Use consistent data types within each column

Privacy & Security

All conversions happen locally in your browser. Your MediaWiki data is never uploaded to any server, ensuring complete privacy and security.