Column to Comma Separated List
Join one-per-line values into a single comma delimited line, with presets for SQL IN lists, JSON arrays and Python lists.
14 tools in this category
Reshape data from one form into another without leaving the browser.
These tools take data that is already correct and change its shape: a column of IDs into a comma list for a SQL IN clause, a minified API response into indented JSON you can read, a printed Python dict into JSON a config file will accept. None of them alter the values themselves, and each one shows a counter or a status line so you can see what went in and what came out.
Which one you need depends on where the data is going. Moving values between a spreadsheet and code, use Column to Comma Separated List or its reverse, Comma Separated List to Column; they hand off to each other with one click. If a JSON payload will not parse, the JSON Formatter reports the line and column of the fault. If the text only looks like JSON because it came from Python (single quotes, True, None), start with Python Dict to JSON instead, or go the other way with JSON to Python Dict. Page source that needs to become a README or a note is a job for HTML to Markdown, which keeps headings, lists, tables and links and escapes the characters Markdown would otherwise misread. Resizing an image or video without distorting it is a job for the Aspect Ratio Calculator: give it the original width and height and a new target dimension, and it works out the other one.
Join one-per-line values into a single comma delimited line, with presets for SQL IN lists, JSON arrays and Python lists.
Split comma, semicolon, pipe or tab delimited text into one item per line; the separator is detected automatically.
Beautify or minify JSON and see exactly where a syntax error is.
Paste a printed Python dict and get valid JSON with proper quotes, true/false and null.
Paste JSON and get a Python literal back, ready to assign to a variable or paste into a REPL.
Convert between Unix time and a human date, with explicit control over seconds/milliseconds and time zone.
Find the exact gap between two dates: a calendar breakdown plus totals in weeks, days, hours and weekdays.
Convert between bytes, KB, MB, GB, TB and PB, with decimal and binary shown separately instead of conflated.
Turn a CSV file into a JSON array of objects, with type detection and a custom delimiter.
Turn a JSON array into a CSV file, ready to open in a spreadsheet.
Paste a HEX, RGB or HSL color and get every format back, plus its contrast ratio against black and white.
Paste an integer in any base and get binary, octal, decimal and hex back at once.
Get the simplified ratio of any width and height, then scale a new dimension to match it.
Paste HTML source and get GitHub-flavored Markdown back, with the structure kept and stray symbols escaped.
No tools match. Try a different word.
Shown only when you're not typing in a field, so "?" still works normally in every tool's input.