Tools for CSV, TSV, JSON and XML data

Data Convert dataConverts CSV, TSV, JSON or XML to data and spreadsheet formats. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Select or remove columnsKeeps or removes the requested columns. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Sort and filter dataSorts by a column and filters rows using a condition. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Clean dataTrims values and removes empty or duplicate rows. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Merge data filesCombines rows from multiple CSV, TSV, JSON or XML files. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Split dataSplits rows into several files packaged in a ZIP. Works with CSV, TSV, JSON, XML and creates ZIP while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Validate and formatValidates and formats or minifies JSON and XML documents. Works with JSON, XML and creates JSON, XML while keeping your original files unchanged. JSONXML Open tool

Data Validate schemaValidates JSON against JSON Schema or XML against XSD. Works with JSON, XML and creates JSON while keeping your original files unchanged. JSONXML Open tool

Data Query and map fieldsSelects data using JSONPath, XPath or a column expression and renames fields. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Join datasetsJoins two datasets by matching key columns. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Aggregate or pivotGroups rows, calculates values and optionally creates pivot columns. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Transform structureFlattens or rebuilds nested JSON and infers value types. Works with CSV, TSV, JSON, XML and creates CSV, TSV, JSON, XML, XLSX, ODS while keeping your original files unchanged. CSVTSVJSONXML Open tool

Data Compare datasetsReports added, removed and changed rows between two files. Works with CSV, TSV, JSON, XML and creates JSON, CSV, XLSX while keeping your original files unchanged. CSVTSVJSONXML Open tool