←

CSV / JSON Data Workbench

Waiting for input data.waiting for input

Reading CSV

0%
0 / 00%time 00:00Estimated remaining --:--0 rows/swaiting for input

100% only means the quantity is completed; success will be displayed only after the parsing and verification pass.

Import and parse

Import UTF-8 CSV or a JSON array of objects. Files are processed only in local memory. Select the input format explicitly first.

Column mapping and cleaning rules

Use stable numbers for each column; any changes will expire old results.

After parsing the CSV, the mapping and cleaning rules for each column are shown here.

Check and export

Changes, issues, and downloads must come from the same immutable result snapshot.

data row0
output column0
Modify0
Issues0

After applying the rule, a summary of differences, issues, and exports is displayed here.

Final export summary

File name: cleaned-data.csv

formula risk treatment approach

There is no universal non-destructive decontamination that will work for all spreadsheets and downstream systems; choose based on practical use.

Original vs. Cleaned Value Preview0 / 0
Displays up to 100 lines; highlights indicate modifications or issues

Import or paste UTF-8 CSV, confirm structure settings, configure field rules, apply and review differences. The download button is only enabled if the structure and type checks pass, the results are not expired, and formula risks are explicitly addressed.

Parsing and cleaning methods

The parser distinguishes between field start, unquoted field, quoted field, and closed quotes, and handles delimiters, double quotes, embedded newlines, and CRLF. Cleaning performs retain, rename, trim, null, type and deduplication in column order.

JSON accepts only arrays of objects whose values are text, numbers, booleans or null; nested values are not supported. Numbers retain their original notation, and all cells become text. null, missing fields and empty strings all become empty cells, so original types cannot be recovered. CSV output always uses commas and CRLF; all values in JSON output are strings.

Verifiable example

The tutorial example contains two lines of data, leading and trailing spaces, and a =2+3 formula risk. After applying the default rules, you should get two rows and three columns, two trim modifications, and keep download blocking until the formula policy is selected.

Limit

Only supports UTF-8; maximum file size 10 MiB, 100,000 data records, 500 columns, single field 1 MiB. The preview renders up to 100 lines. Type checking is a syntax check and does not replace business verification.

Combined limits: at most 1000000 cells including headers, and at most 32 MiB of output. Input limits are 10 MiB, 100000 records, 500 columns and 1 MiB per field; these maximums cannot all be reached at once. The preview shows only the first 100 records and at most 1000 characters per field. Copying and downloading do not truncate the output.

Privacy and recovery

The file content is only retained in the current page memory and is not uploaded or written to localStorage. Refreshing will clear the data. Canceling a long task does not preserve partial results and restores the last full snapshot.

CSV / JSON Data Workbench

Import or paste UTF-8 CSV, confirm structure settings, configure field rules, apply and review differences. The download button is only enabled if the structure and type checks pass, the results are not expired, and formula risks are explicitly addressed.

Settings