📊 データ整形

Convert CSV (Comma Separated Values) data to JSON format. Supports quoted fields, commas within values, and uses the first row as headers. Perfect for data import, API preparation, and ETL workflows.

Turn a CSV table into SQL insert queries in your browser.

Transpose (rotate) a CSV table — rows become columns.

Trim a list to a limited number of lines.

Convert comma-separated CSV to tab-separated TSV.

Turn a CSV string into well-formed XML.

Multiply each line of your list.

Cut out a portion of text by position or pattern.

Compare two JSON objects and spot the differences right in your browser.

Escape a raw string into a valid JSON string literal.

Format, beautify, minify, and validate JSON data in one tool. Paste your raw JSON and we'll pretty-print it with proper indentation, validate its structure, highlight any syntax errors, and let you copy or download the result. Essential for developers working with APIs, configuration files, and data interchange. All processing runs locally in your browser.

Sort the keys of any JSON object alphabetically, recursively.

Stringify JSON with your preferred formatting.

Turn a JSON array into a properly quoted CSV file.

Convert JSON data into XML format right in your browser.

Convert JSON into readable YAML format in your browser.

Check whether your JSON data is valid and well-formed. Our validator catches common syntax errors — missing commas, unquoted keys, trailing commas, mismatched brackets — and pinpoints the exact line where the error occurs. Perfect for debugging API responses, config files, and data exports.

Identify duplicate entries in any list and see how many times each duplicate appears. Useful for data cleanup, audit, and analysis.

Organize key=value lines into groups.

Instantly reverse the order of any list of items. The first line becomes the last, the last becomes the first. Simple, fast, and entirely in your browser.

Randomly shuffle any list of items. Perfect for drawing lots, randomizing the order of names, and breaking up predictable sequences.

Sort any list of items — text lines, numbers, or mixed content. Choose alphabetical, numeric, or by-length sorting, in ascending or descending order. Paste items separated by newlines, commas, or tabs.

Remove duplicate entries from a list and keep only unique values. Optionally enable case-insensitive mode to treat "Apple" and "apple" as the same item.

Unwrap and clean up formatted lists by removing bullet prefixes (-, *, •) and joining wrapped lines into clean single entries.

Add bullet points, dashes, asterisks, or numbered prefixes to each line of your list. Choose the bullet style and get a formatted list instantly.

Find which lines appear most often in your text.

Quickly calculate the sum of any list of numbers. Paste numbers (one per line, comma-separated, or space-separated) and get instant results including total sum, count, average, minimum, and maximum values. Great for quick mental math, spreadsheet verification, and tallying.

Find the most frequent words in any text right in your browser.

Format raw XML with readable indentation.

Validate whether your XML is well-formed.

Convert YAML into JSON format directly in your browser.

Generate Open Graph and Twitter Card meta tags for any page.