Spreadsheet & CSV Tools

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… JSON Data Cleaner Tidy up JSON from APIs, exports or forms in one step. The cleaner trims spaces in… JSON Data Deduplicator Find and remove duplicate items in a JSON array. Compare whole objects (key order… CSV Data Deduplicator Remove duplicate rows from a CSV file in seconds. Compare all columns or only the… CSV Data Profiler Understand a dataset before you use it. The profiler reads CSV or JSON and, for… Data Validation Generator Turn sample data into validation rules. The generator infers each field’s type… Null Value Analyzer See exactly where data is missing. The analyzer counts empty cells and… Column Statistics Generator Get descriptive statistics for every numeric column at once. The generator… Dataset Summary Generator Document a dataset in minutes. The generator analyses CSV or JSON and writes a…