Skip to content
LovelyTools
EN

Data Tools

Reshape and tidy data: convert CSV to JSON and back, JSON to YAML and back, and format XML and SQL.

32 tools

XML FormatterPretty-print XML and catch mismatched or unclosed tags.SQL FormatterFormat SQL queries for MySQL, PostgreSQL, SQL Server, SQLite and more.CSV to JSON ConverterConvert CSV or TSV data to JSON with headers and type detection.JSON to CSV ConverterConvert JSON arrays to CSV for Excel and Google Sheets, flattening nested objects.JSON to YAML ConverterConvert JSON to clean YAML for config files.YAML to JSON ConverterConvert YAML to JSON and catch YAML syntax errors with line numbers.Text Column AlignerAlign comma-, tab- or pipe-separated text into neat columns.CSV to Markdown TableConvert CSV or spreadsheet data into a Markdown table.CSV Delimiter ConverterChange the delimiter of CSV data — comma, semicolon, tab or pipe.CSV to SQL INSERT GeneratorTurn CSV rows into SQL INSERT statements with escaped values.YAML Formatter & ValidatorValidate YAML and re-format it with consistent indentation.HTML Table to CSVExtract tables from HTML into CSV, including colspans.Test Data GeneratorGenerate fake people records as JSON, CSV or SQL for testing.List to SQL IN ClauseTurn a list of values into a SQL IN (...) clause with proper quoting.CSV to XML ConverterConvert CSV rows into XML elements using the header row as tag names.CSV to SQL CREATE TABLEInfer column types from CSV and generate CREATE TABLE plus INSERTs.CSV Column ExtractorKeep only the CSV columns you need, in the order you want.CSV TransposeSwap rows and columns in CSV data.CSV Duplicate RemoverRemove duplicate CSV rows, by whole row or by one key column.CSV SorterSort CSV rows by any column, as numbers or text.CSV to YAML ConverterConvert CSV rows into a YAML list of records.Chart MakerTurn data into bar, line, pie or doughnut charts and download them.CSV Row FilterKeep only the CSV rows where a column matches a condition.CSV ValidatorCheck a CSV for wrong field counts, duplicate headers and quote errors.JSON to SQL INSERTConvert JSON objects into SQL INSERT statements and a CREATE TABLE.SQL INSERT to JSONConvert SQL INSERT statements into JSON objects grouped by table.XML to CSV ConverterFlatten repeating XML records into a CSV spreadsheet.Sankey Diagram MakerShow how money, energy or users flow between stages with a Sankey diagram.Venn Diagram MakerCompare two or three lists and see what they share in a Venn diagram.CSV Data ProfilerInstant data-quality report: types, blanks, unique values, stats and outliers per column.CSV Join (Merge Two Tables)Join two CSVs on a key column — inner, left or full outer — like VLOOKUP or SQL JOIN.CSV Pivot TableSummarise a CSV like a spreadsheet pivot: rows, columns, sum/count/average, totals.

Other categories

PDF Tools27 toolsMerge, split, compress, rotate and protect PDF files without uploading them.Image Tools79 toolsCompress, resize, crop and convert JPG, PNG and WebP images locally.Video Tools124 toolsGrab still frames, make thumbnail sheets and inspect video files in your browser.Audio Tools43 toolsTrim, convert and analyse audio using the Web Audio API.Text Tools77 toolsCount words, change case, sort lines, remove duplicates and clean up text.SEO Tools13 toolsGenerate meta tags, robots.txt, sitemaps and schema markup.Developer Tools48 toolsEncode, decode, hash, format and generate data for everyday coding.Calculators98 toolsPercentage, age, BMI, discount and other everyday calculators.Math Tools82 toolsScientific calculator, fractions, primes, GCD/LCM and equation solving.Converters24 toolsNumber bases, Roman numerals, numbers to words, binary text and Morse code.Unit Converters160 toolsLength, weight, temperature, area, volume, speed and data-size units.Date & Time31 toolsDate differences, time zones, Unix timestamps and working days.Color Tools15 toolsConvert colours, check WCAG contrast and generate palettes.CSS Tools31 toolsFormat and minify CSS, and generate gradients, shadows and border radius.HTML Tools11 toolsFormat, minify and escape HTML entities.JavaScript Tools6 toolsFormat and minify JavaScript code.JSON Tools30 toolsFormat, validate, minify and convert JSON.Security & Privacy31 toolsPassword generator, strength checker and hash functions.File Tools9 toolsChecksums, file type detection and Base64 encoding for any file.Document Tools6 toolsMarkdown to HTML, HTML to Markdown and text to PDF.QR Code Tools6 toolsCreate QR codes for links, Wi-Fi and contacts, or read one from an image.Barcode Tools1 toolGenerate EAN-13, UPC-A, Code 128, Code 39 and ITF-14 barcodes.Web Utilities28 toolsURL parser, UTM campaign builder and redirect rule generator.Social Media18 toolsPlatform character limits, hashtag formatting and bold/italic text.Writing Tools27 toolsReadability scores for clearer English writing.Education Tools51 toolsGPA and weighted grade calculators and multiplication tables.Business Tools24 toolsProfit margin, markup, break-even and VAT calculators.Finance Calculators53 toolsLoan, EMI, compound interest, savings and investment calculators.Productivity34 toolsPomodoro, countdown and stopwatch timers, name pickers and dice.