Spreadsheet & CSV Tools

Work with tables without opening a spreadsheet program. Turn CSV into Excel workbooks and back, export sheets as JSON, preview large files, combine or split them, remove duplicates and blank rows, and convert column letters to numbers.

CSV to Excel Turn CSV files into proper Excel workbooks without the usual import problems. The… Excel to CSV Export spreadsheets to clean CSV files. Each sheet of a workbook becomes its own… Excel to JSON Turn a spreadsheet into JSON that code can use straight away. Pick a sheet, decide… Excel Formula Generator Get the formula you need without memorising syntax. Choose a task, such as looking… Excel Column Converter Find out which number a column letter stands for, or which letters belong to a… TSV to CSV Change tab-separated data into comma-separated data, or the other way round. Paste… CSV Viewer Look inside a CSV file without a spreadsheet program. Drop the file to see it as a… CSV Merger Stack several CSV files into one. The merger lines up columns by their header… CSV Splitter Break a large CSV file into manageable pieces. Split it into files of a fixed… CSV Cleaner Tidy a messy CSV before it causes an import error. Tick the problems you want… JSON Lines Formatter Tidy up JSON Lines files such as logs, event streams and machine-learning… JSON Lines Validator Check a JSON Lines file before a pipeline or training job chokes on it. Every line… JSON Lines to CSV Turn a JSON Lines file into a spreadsheet-ready CSV. The columns are the union of… CSV to JSON Lines Turn a CSV file into JSON Lines, one object per row with the header row as keys.… TSV to JSON Convert tab-separated data, including what you get when copying cells from Excel… JSON to TSV Turn JSON records into tab-separated values that paste straight into a spreadsheet… CSV to Markdown Table Paste CSV, or copy cells from a spreadsheet, and get a GitHub-flavoured Markdown… Markdown Table to CSV Paste a Markdown document and get its tables as CSV for a spreadsheet or database.… CSV to SQL Turn a CSV file into a SQL script you can run. The header row gives the column… SQL to CSV Get table data out of a SQL dump without restoring it into a database. Paste the… SQL to XML Turn the data in a SQL dump into XML. Every table with INSERT rows becomes an… XML to CSV Turn an XML document into a table. The converter finds the repeating elements that… XML to YAML Turn XML into clean, readable YAML. Elements become keys, elements that repeat… YAML to XML Turn YAML into XML that any parser accepts. Mappings become nested elements, lists…

Also useful for spreadsheet work

Browse other categories