$ input_area resizeable

items: 0

# total_sum

0

min -

max -

avg -

$ list_data resizeable

dupes: 0

unique: 0

non-dupes: 0

# duplicate_list & counts

No duplicate items found yet.

$ source_text paste text or upload a file

click to upload .xlsx / .xls / .csv (scan by row)

non-ascii: 0

# detected chars & unicode

No non-ASCII characters found.

# highlighted preview

No text entered yet.

$ original (left) resizeable

$ modified (right) resizeable

# comparison_result

Waiting for input on both sides...

$ source_file (excel / csv)

click to upload or drop your file here supported: .xlsx, .xls, .csv

$ table_name

# where conditions (min 1)

$ source_file (excel / csv)

click to upload or drop your file here supported: .xlsx, .xls, .csv

# group_by_column (optional) Rows with the same value in this column stay in the same file. Leave empty to split purely by row count.

$ max_rows_per_file Each output file will contain at most this many data rows.

$ list_data resizeable

# query_template (optional) use {values}

items: 0

detected: -

Paste a list above to generate values ready for WHERE col IN (...).

$ source_text resizeable

# total_chars 0

# total_lines 0

# words 0

# sentences 0

# paragraphs 0

# spaces 0

# size_utf8 0 B 0 bytes

# size_utf16 0 B 0 bytes

size_utf8 = storage estimate for MySQL utf8mb4 (VARCHAR / TEXT) & PostgreSQL — actual bytes of the text in UTF-8. size_utf16 = estimate for SQL Server NVARCHAR (2 bytes per character). Row/length overhead per record is not included.

$ json_input upload .json or paste below

click to upload a .json file

$ head_table All root fields that are NOT arrays go into this table.

# detail_tables (json_key → table)

include column names in output set identity "ID" column to null (for restore)

$ list_data

# separator

items: 0

# ascending

# descending

$ sql_files (multiple)

click to upload one or more .sql files merged in the order selected

clear SQL comments (--, #, /* */)

# boundary comment (per file) Inserted as a comment before each file. Use {filename} as a placeholder. Leave empty to use the filename.

$ file_type

# file_name (optional)

$ file_size

The file is blank — padded to the target size. Max 100 MB.

$ log_source upload or paste

click to upload a .log / .txt file

entries: 0

shown: 0

time	level	user	ip	category	message

Upload or paste a log to begin.

$ json_input resizeable

status: waiting

keys: 0

$ csv_source upload or paste

click to upload a .csv file

rows: 0

columns: 0

tip: click a column header's filter box below to narrow that column specifically.

Paste or upload a CSV to begin.

DataDev Utilities

Sum a list of numbers online — calculator with formula support and Indonesian/European number formats

Find duplicate values in a list — detect duplicates, unique, and non-duplicate entries

Detect non-ASCII and hidden Unicode characters in text or an Excel/CSV file

Compare two texts line by line — free online text diff tool

Generate SQL DELETE, UPDATE, and template statements from an Excel or CSV file

Split a large Excel or CSV file into multiple files by row count

Build a SQL WHERE IN (...) clause from a pasted list

Count characters, bytes, and database storage size of text

Convert JSON to SQL INSERT statements to restore data

Sort a list of numbers or text ascending or descending

Merge multiple SQL files into one

Generate a blank dummy file of any size and format for upload testing

View and search an application log file as a table

Format JSON online — code view and tree view, validate JSON live

View and filter CSV data as a table — paste or upload, client-side CSV viewer