8 guides

Data & Spreadsheets Guides

Workflows for cleaning, converting, profiling, and preparing CSV, spreadsheet, and structured data.

How to Clean CSV Files Before Importing Data

Clean CSV files by fixing delimiters, removing blank rows, deduplicating data, profiling columns, and converting to JSON or tables.

Find and fix common JSON errors like missing commas, bad quotes, trailing commas, invalid escapes, and broken nesting.

Convert CSV files to clean JSON by checking headers, delimiters, empty rows, duplicate columns, data types, and nested structures.

Compare text, CSV, JSON, XML, images, hashes, folders, URLs, PDFs, and Word documents to find changes before publishing or sharing.

Compare two text files online to find added, removed, and changed lines, then copy or download a difference report.

Choose between CSV and JSON for spreadsheets, APIs, exports, imports, tables, nested data, and data cleanup workflows.

Prepare CSV files for uploads by fixing headers, blank rows, delimiters, duplicates, data types, encoding, and suspicious columns.

Detect duplicate rows, inconsistent column types, missing values, bad headers, and suspicious CSV data before import or analysis.