Logo

MediaWiki to CSV Converter

Transform MediaWiki tables into CSV files with flexible formatting options

MediaWiki Input

Delimiter Presets

CSV Output

About MediaWiki to CSV Converter

Convert MediaWiki tables to CSV (Comma-Separated Values) format with full control over delimiters, quotes, and formatting options. Perfect for importing Wikipedia data into spreadsheets and databases.

Key Features

  • Custom Delimiters: Comma, semicolon, tab, pipe, or any custom character
  • Quote Control: Customize quote character and escaping behavior
  • Line Endings: Choose between LF (Unix/Mac) or CRLF (Windows)
  • Header Options: Include or exclude header row
  • Proper Escaping: Automatically quotes fields containing delimiters or newlines
  • RFC 4180 Compliant: Follows CSV standard specifications
  • File Download: Save as .csv file for Excel, Google Sheets, etc.

How to Use

  1. Input MediaWiki Table: Paste your MediaWiki table or upload a .wiki file
  2. Choose Delimiter: Select from presets or enter custom delimiter
  3. Configure Options: Set quote character, line endings, and header inclusion
  4. Review Output: The CSV updates automatically
  5. Download or Copy: Save as .csv file or copy to clipboard

Delimiter Options

  • Comma (,): Standard CSV format (most common)
  • Semicolon (;): European CSV format
  • Tab (\t): TSV (Tab-Separated Values) format
  • Pipe (|): Alternative delimiter for data with commas
  • Custom: Any character or sequence up to 5 characters

Example Conversion

MediaWiki Input:

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

CSV Output (Comma delimiter):

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

CSV Output (Tab delimiter):

Name	Age	City	Department
John Doe	28	New York	Engineering
Jane Smith	34	London	Marketing

Common Use Cases

  • Excel Import: Convert Wikipedia tables for Microsoft Excel
  • Google Sheets: Import wiki data into Google Sheets
  • Database Import: Prepare data for SQL database imports
  • Data Analysis: Convert wiki tables for R, Python, or MATLAB
  • Wiki Data Export: Extract structured data from MediaWiki sites

CSV Standards

This converter follows RFC 4180 CSV standards:

  • Fields containing delimiters, quotes, or newlines are quoted
  • Quotes within fields are escaped by doubling them
  • Each record is on a separate line
  • Optional header row as first line
  • Consistent number of fields per record

Special Character Handling

  • Delimiters in Data: Automatically quoted
  • Quotes in Data: Escaped by doubling (e.g., " becomes "")
  • Newlines in Data: Preserved within quoted fields
  • Wiki Markup: Stripped from cell content

Privacy & Security

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