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.

FAQ  MediaWiki to JSON Converter

Which format should I choose: Array of Objects or Array of Arrays?

Use Array of Objects when you want named fields (keys) for each column, which is ideal for APIs, databases, and most application code. Use Array of Arrays when you just need positional data, for example in numerical processing or when interoperability with CSV-like structures is more important than field names.

Why are some values numbers or booleans instead of strings?

The converter performs basic type detection so that values like 42, 3.14, true, false, and null become proper JSON numbers, booleans, or nulls. This makes the output more useful in code without needing extra parsing.

Can I guarantee that all values are strings?

If you need everything as strings, you can post-process the JSON in your own code to cast values, or edit the output manually. The built-in converter prioritizes typed values for typical development workflows.

Is the generated JSON valid for all JSON parsers?

Yes. The output is standard RFC 8259-compliant JSON and should work with JSON parsers in JavaScript, Python, Java, Go, and most other languages.

What if my header names are duplicated?

If the header row contains duplicate column names, later values will overwrite earlier ones when creating objects. For robust structures, try to ensure that each header name in your MediaWiki table is unique.