Documentation

1. Importing Your Data

TableFlux supports uploading files or pasting raw data directly from your clipboard. The app automatically detects the format (CSV, TSV, JSON, JSONL, XML, YAML) and parses it instantly in your browser.

• JSON Data: Ensure it is an array of objects. Nested objects will be flattened.
• CSV/TSV Data: The parser will attempt to auto-detect the delimiter and headers.
• Smart Columns: TableFlux automatically detects if a column contains Numbers, Dates, or Text to enable mathematically accurate sorting.

2. Editing & Transforming

Once imported, your data is loaded into the high-performance grid. You can double-click any cell or column header to edit it.

The Transform Panel

On the left side of the editor, click to open the Transform panel. This is where you can clean your dataset:

• Find & Replace: Search for text globally or in specific columns. Supports Regex matching.
• Smart Extract: Extract Emails, URLs, or Phone numbers from text into a brand new column instantly using native Regex.
• Merge Columns: Combine multiple columns (e.g., First Name and Last Name) using a custom separator.
• Remove Duplicates: Instantly scan and delete duplicate rows from your dataset.

Note: Every transformation triggers a confirmation modal to protect you from accidentally destroying data.

3. Exporting & Converting

Open the "Output" panel on the right side of the editor to convert your table in real-time. Choose your desired output format from the dropdown menu.

• CSV & Excel: Standard spreadsheet downloads.
• SQL: Generates a CREATE TABLE and INSERT INTO statement.
• Markdown & HTML: Generates formatted tables for docs and websites.
• JSON: Exports a strict JSON array.