How do I VLOOKUP between two CSV files without Excel?

Use Ginexys Table Formatter's Node Editor mode. Upload both CSV files as tables, add a VLookup node, select the matching column from each table, and the joined result is generated instantly in your browser. No Excel, no Python, no install required. Open the tool at ginexys.com/tools/table-formatter.

How do I convert an HTML table to Markdown online?

Paste your HTML into Ginexys Table Formatter, select Markdown as the export format, and copy the result. It works for Docusaurus, GitBook, GitHub READMEs, and any Markdown-based documentation platform. The conversion runs entirely in your browser at ginexys.com/tools/table-formatter.

Can I join two CSV files by a common column online?

Yes. Ginexys Table Formatter's Node Editor includes a Join node that merges two CSV tables by a shared column key — equivalent to a SQL JOIN or Excel VLOOKUP. Load both files, connect a Join node, pick the key column, and download the result. No software needed.

How do I validate CSV data in the browser without uploading it?

Use Lab Mode in Ginexys Table Formatter. It validates your CSV for errors (missing fields, type mismatches, duplicate rows), analyzes data patterns, and lets you transform or clean the data — all locally in your browser. Your data never leaves your device.

How do I transpose a CSV or table without Excel?

In Ginexys Table Formatter's Table Editing Mode, load your CSV or paste your table and use the Transpose operation to flip rows and columns instantly. The result can be exported back as CSV, HTML, Markdown, or JSON.

How do I generate SQL INSERT statements from a CSV or spreadsheet?

Load your CSV into Ginexys Table Formatter, then select SQL as the export format. It generates ready-to-run INSERT statements from your table data — useful for seeding Supabase, Prisma, MySQL, or any SQL database directly from a spreadsheet.

Does the Ginexys table formatter work offline?

Yes. All three modes — Table Editing, Node Editor, and Lab Mode — run entirely in your browser. No files are uploaded to any server. You can use the tool with no internet connection after the page has loaded.

How do I filter table rows without Excel or Python?

Use the Node Editor mode in Ginexys Table Formatter. Add a Filter node, set your condition (e.g., column value equals, contains, or is greater than), and the filtered rows are returned as a new table you can export or chain into further transformations.

Free Online Table Editor — Edit, Join, Validate Tables in Browser

Name: Table Formatter
Author: GINEXYS

History

Element Type

Class Name

Style & Color

Spacing (T / R / B / L)

Colspan / Rowspan

Add Operations

Delete Operations

Drag & Drop

Node Editor

Lab Mode

Select a step from the list above to begin.

Result

Run a pipeline to see results

Table Viewer

Equation Editor

Name

Shortcuts ▲

Shortcuts

↑↓←→ Move ⇧↑↓←→ Extend Range
Tab Next Cell ⇧Tab Previous Cell
↵ / F2 Edit Cell type to replace
In editor: ↵ Down ⇧↵ Up Tab Right Esc Cancel ⌥↵ New Line
Ins / ⌃/⌘↵ Add Cell After ⇧Ins / ⇧⌃/⌘↵ Add Cell Before
Del / ⌫ Clear Contents ⇧Del / ⇧⌫ Delete Cell
⌃/⌘ + A Select All Cells
⌃/⌘ + C Copy Selected
⌃/⌘ + V Paste After ⌃/⌘ + ⇧V Paste Before
⌥⇧W Merge Cell ⌥⇧T Text Split ⌥⇧X Apply Split

Cell Selection

Single: Click any cell
Multi: Ctrl/Cmd + click
Range drag: Click and drag
Range shift: Click, then Shift+click
Right-click: Context menu
Double-click: Edit cell
Row / column: Click a ruler number or letter

TAFNE Cloud

Cell Options

Delete

Table & Styles

Tab

Delete