Excel Formulas and Tools Hub
Find duplicates, blank rows, fixed columns, and other spreadsheet tasks — all in your browser, no upload, no Excel required.
If you spend any time in spreadsheets — Excel, Numbers, Google Sheets, LibreOffice Calc — you know the same handful of tasks recur again and again: find duplicates, remove blank rows, convert to JSON for an API, or paste a CSV from a colleague into a spreadsheet without mangling the encoding.
This hub collects ToolConvoy’s tools for spreadsheet tasks. All of them run in your browser, accept CSV or pasted text, and never upload your data.
Tasks covered
- Find duplicates — paste or upload a CSV, get a duplicate column added in one click
- Delete blank rows — same input, but rows that are entirely empty are removed
- Transpose — flip rows and columns (use when the data is sideways from how it needs to be)
- Convert CSV ↔ JSON / YAML / TOML / XML — round-trip between formats without losing data
- SQL Formatter — for when your data lives in a database and you need to query it
The hub also covers two important how-to questions:
- Find Duplicates in Excel Without Formula — when you don’t remember the conditional formatting rule
- Highlight Duplicates in Excel Three Ways — the conditional formatting recipes
Why this hub exists
Most “Excel formula for X” answers require you to remember the syntax. For the dozen most common operations, you shouldn’t have to. The tools in this hub give you a one-click answer for each, with the option to copy the result and paste back into Excel.
For tasks that genuinely need a formula — complex conditional aggregates, multi-sheet references, dynamic arrays — your spreadsheet is still the right tool. This hub is for the rest.
Excel Find Duplicates — Highlight or Remove in Browser
Paste CSV (or Excel data as TSV), pick a key column, get an 'is_duplicate' column or a deduplicated CSV. Browser-only, no upload.
CSV to JSON — Convert CSV Spreadsheets to JSON in Your Browser
Convert CSV spreadsheet data to JSON. Handles delimiters, quoted fields, BOM, and type inference — all in your browser, no upload.
CSV to YAML — Convert CSV Data to YAML
Convert CSV data to YAML with list-of-maps, list-of-lists, or single-map output. Runs entirely in your browser. No uploads, no accounts, no limits.
JSON to CSV — Convert JSON Arrays to CSV Spreadsheets
Convert JSON arrays of objects to CSV format. Handles nested flattening, semicolon delimiters, BOM prefixing — in your browser, no upload.
CSV Transpose — Swap Rows and Columns in CSV Data
Transpose CSV data — swap rows with columns. Live preview, runs entirely in your browser. No uploads, no accounts, no limits.
SQL Formatter — Format and Beautify SQL Queries
Format and beautify SQL queries with customisable indentation, keyword casing, and dialect support — in your browser, no upload.
CSV to HTML — Convert CSV Data to HTML Table Markup
Convert CSV data to formatted HTML table markup. Optional thead, tbody, and CSS classes, runs entirely in your browser. No uploads, no limits.
CSV to Markdown — Convert CSV Data to Markdown Tables
Convert CSV data to Markdown table syntax for READMEs, docs, and blog posts. Pipe-aligned output, runs entirely in your browser. No uploads, no limits.
CSV to vCard — Convert CSV Contacts to vCard Format
Convert CSV contact lists to vCard (.vcf) files for import into iOS, Android, macOS, and Outlook. Runs entirely in your browser. No uploads, no limits.
Your files never leave your device. Every conversion happens in your browser. No uploads, no servers, no file size limits.