MediaWiki to CSV Converter

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

Frequently Asked Questions (FAQ)

• Which applications can open the generated CSV files?

  The CSV output is plain text and works with most spreadsheet and data tools, including Microsoft Excel, Google Sheets, LibreOffice Calc, Numbers, and many database import utilities.

• Why do I see all data in a single column when opening in Excel?

  This usually means Excel is expecting a different delimiter than the one you chose. For example, some locales default to semicolons instead of commas. Make sure to select the matching delimiter when importing, or choose the delimiter that your environment expects.

• Can I use custom multi-character delimiters?

  Yes. The tool allows custom delimiters up to 5 characters. However, not all CSV consumers support multi-character delimiters, so verify compatibility with your target application.

• How are embedded newlines and quotes handled in cells?

  Cells that contain delimiters, quotes, or newlines are wrapped in the chosen quote character. Any existing quote characters inside the cell are doubled (e.g., " becomes "") to comply with CSV standards.

• Is any of my MediaWiki or CSV data uploaded to a server?

  No. All conversion logic runs locally in your browser. Your MediaWiki table and the resulting CSV file are not transmitted or stored externally.

Privacy & Security

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