CSV Data Filter & Query - Online Spreadsheet WHERE Clause
Load a CSV file and filter rows using basic expressions (e.g., age > 30). Supports AND/OR conditions. Export filtered result as CSV. All in browser.
UD5 Toolkit
Convert CSV data to MediaWiki markup tables instantly — compatible with Wikipedia, Fandom, and any MediaWiki-based wiki
Preview will appear here
{| and end with |}. Rows are separated by |-, header cells use !, and data cells use |. The wikitable class adds default styling with borders and alternating row colors.
wikitable or wikitable sortable class for a polished look.
"") inside quoted fields. Files with .csv, .tsv, and .txt extensions are accepted. The parser automatically detects and skips completely empty rows.
style="text-align:…" attributes in the generated markup.
|| separators for data and !! for headers — for example: | Cell1 || Cell2 || Cell3. Expanded format places each cell on its own line. Compact is preferred for readability in most wikis; expanded is useful when cells contain lengthy content or when you need to add individual cell attributes.
"Smith, John"), embedded newlines, and escaped double quotes ("" → "). In the generated Wiki markup, pipe characters (|) inside cell content are automatically escaped using <nowiki>|</nowiki> to prevent them from being interpreted as table syntax. Most other special characters pass through safely.
wikitable class is universally recognized across all these platforms.
Load a CSV file and filter rows using basic expressions (e.g., age > 30). Supports AND/OR conditions. Export filtered result as CSV. All in browser.
Paste a SQL CREATE TABLE statement and extract just the column names as a CSV header row. For data migration.
Convert nested JSON translation files into a flat CSV table for translators. Also reverse back. Local only.
Map CSV columns with latitude/longitude to GeoJSON points. Create map‑ready data instantly. All local.
Split a large CSV into smaller files by row count. Preview each chunk. No upload; streamed locally.
Drop an .xlsx file and convert each sheet to CSV. Processed entirely in your browser. No upload needed.
Convert CSV data to a real Excel spreadsheet with multiple sheets and simple formatting. Fully local.
Paste an HTML table snippet and instantly get the data as CSV or JSON. Handy for scraping and data migration. Local.
Write Q&A in a simple format and export as a CSV file compatible with Anki. Perfect for rapid card creation. Local.
Drop a PDF and automatically detect tables. Export them to CSV or copy to clipboard. Works locally using PDF.js.
Paste CSV data and transform it into a well‑structured YAML array of objects. Choose key mapping. Perfect for devOps and data migration.
Choose tabular‑nums, diagonal‑fractions, ordinal and see the effect on a numeric list. Elegant data presentation.
Map CSV columns to event fields and generate a valid .ics file. Import into Google Calendar, Outlook, or Apple Calendar. Local.
Convert a JSON array of strings or numbers into a single‑column CSV. Quick data dump. Local.
Format a list of Q&A pairs and export as a CSV ready for Anki import. Simple line‑based template. Local.
Convert currencies using a built‑in table of approximate fixed rates. Useful for quick estimates without live data. Local.
Paste CSV and get a list of SQL INSERT statements. Define table name and column mapping. All local conversion.
Paste CSV data and pick which columns to keep or drop. Rearrange column order by dragging. Download the new file. All local.
Convert comma‑separated data into a series of SQL INSERT statements. Define the table name and column order. Local.
Paste SQL INSERT statements and extract the data into a clean CSV table. Works with multiple rows. Local parser.
Enter products with different prices and weights/volumes. The tool ranks them by best value per unit. Save money effortlessly.
Enter a list of component props with types and defaults, and get a Markdown table ready for your Readme or Storybook.
Paste CSV and get a beautiful HTML table with sortable headers (optional). Copy the full HTML/CSS snippet. Local.
Paste tab‑separated or CSV data and instantly get a beautifully aligned Markdown table. Essential for documentation.
Paste an HTML `<table>` snippet and instantly get a clean Markdown table. Supports colspan and alignment hints. Local.
Paste a JSON array and view it as a formatted console.table() style output. Copy for terminal apps. Local.
Enter rows of data and create a nicely formatted ASCII table using box‑drawing characters. Great for CLI apps.
Create and format Markdown tables by adjusting rows and columns. Align text, copy the raw Markdown. Perfect for README files.
View and edit CSV data in a familiar table interface. Add/delete rows and columns, sort, and export. Fully local, no cloud sync.
Interactive ASCII table showing decimal, hex, octal, and binary codes for all standard and extended ASCII characters. A classic programmer reference.