Spreadsheets

Spreadsheet and data tools

Every data tool on OpenTools. JSON, CSV, Excel and tabular clean-up, run in your browser so the spreadsheet is never uploaded anywhere.

All 42 of them are listed below. Each one runs inside this tab, so nothing you open or type is uploaded — see the proof.

• Address-column cleanerCollapse whitespace and normalize comma spacing in an address column.
• Column statisticsCalculate numeric count, minimum, maximum, mean, median, and population deviation.
• CSV cleanerTrim headers and cells, then remove completely blank records.
• CSV column renamerRename headers with old=new pairs while preventing duplicates.
• CSV column selectorKeep and order a comma-separated selection of columns.
• CSV deduplicatorRemove later duplicate rows using selected key columns or the full row.
• CSV diffCompare two datasets by a key and report added, removed, and changed rows.
• CSV editorEdit in the input panel, then validate and normalize quoted CSV output.
• CSV filterKeep rows whose selected column matches a simple bounded condition.
• CSV group byGroup by one column and calculate row count or numeric sum.
• CSV joinInner- or left-join two CSV datasets using named key columns.
• CSV mergerStack two CSV datasets into one in your browser: rows from the second are appended below the first, and the headers have to match exactly and in the same order.
• CSV pivot tableCreate a sum or count pivot from row, column, and value fields.
• CSV schema infererInfer conservative boolean, integer, number, ISO-date, or text column types.
• CSV sorterStable-sort rows by a named column as text or numbers.
• CSV splitterSplit rows into separately labelled CSV parts with repeated headers.
• CSV to JSONConvert strict header-based CSV to an array of JSON objects.
• CSV to SQLGenerate escaped SQL INSERT statements with quoted identifiers and text values.
• CSV to TSVConvert CSV to tab-separated values while rejecting tabs/newlines inside cells.
• CSV transposerSwap rows and columns in a bounded rectangular CSV table.
• CSV type converterNormalize one column to trimmed text, number, boolean, or ISO date.
• CSV viewerParse strict header-based CSV and show a tab-separated table preview.
• Data sampling toolSelect a bounded random sample without replacement.
• Date-column normalizerNormalize one column from ISO, DD/MM/YYYY, or MM/DD/YYYY to YYYY-MM-DD.
• Excel converterTurn an .xlsx into a CSV, or a CSV into a real Excel file, in this tab.
• Excel Workbook Audit & Formula InspectorForensic Excel spreadsheet audit. Detect hardcoded constants, broken formula runs, error cells, circular references, hidden sheets, and Benford statistical anomalies.
• JSON formatterValidate, format, minify, or sort JSON without sending it away.
• JSON to CSVConvert a bounded array of JSON objects to quoted CSV.
• Markdown table to CSVConvert a simple pipe-delimited Markdown table to quoted CSV.
• Missing-value analyzerCount blank, NA, N/A, null, and undefined markers per column.
• Outlier detectorFlag the values in a numeric CSV column that fall outside the 1.5×IQR fences. At least four numeric rows are needed, and both quartiles are reported too.
• Phone-column normalizerNormalize one phone column to +country-and-national-digits form.
• Pivot-table plannerValidate field choices and produce a concise pivot configuration plan.
• Random row selectorDraw one row at random from a pasted CSV and get back its row number together with every column value, for picking a winner or spot-checking a dataset.
• Spreadsheet blank-row removerRemove physical CSV lines that contain only separators and whitespace.
• Spreadsheet cell inspectorLook up one cell by data row number and column name to see its value, whether it is blank, how many characters it holds and how many UTF-8 bytes it takes.
• Spreadsheet data profilerProfile row count, uniqueness, missingness, and inferred type per column.
• Spreadsheet duplicate finderReport duplicate values and row numbers in a chosen column.
• Spreadsheet formula viewerList CSV cells beginning with =; formulas are never evaluated.
• Table to MarkdownConvert CSV into an escaped GitHub-style Markdown table.
• TSV to CSVConvert rectangular tab-separated rows to quoted CSV.
• VLOOKUP generatorGenerate a spreadsheet VLOOKUP formula from explicit cell/range settings.