KitNelo
All Studios

Data Studio

Multi-tool · Local processing

Define canonical fields, aliases, units and types; validate required values, dates, decimals and enums before exporting

Current function

Field Dictionary

How to use this tool
  1. Edit or import the dictionary JSON and confirm aliases, units, types and required fields.
  2. Import one sheet and inspect validation issues and unmapped columns.
  3. Fix source issues, then download canonical CSV and continue cleaning, reporting or template filling.
Example and limits

Date, ID and amount aliases map to date, id and amount. Leading zeros and long decimal spellings stay intact.

200 KB dictionary, 100 fields; 100,000 rows, 300 columns and 2 million cells. Exports contain dictionary fields only; no formula calculation or unit conversion.

Loading tool…
Full instructions and common questions

Field Dictionary

Define versioned fields, normalize headers and validate a table.

How to use

  1. Edit or import the dictionary JSON and confirm aliases, units, types and required fields.
  2. Import one sheet and inspect validation issues and unmapped columns.
  3. Fix source issues, then download canonical CSV and continue cleaning, reporting or template filling.

Try an example

Date, ID and amount aliases map to date, id and amount. Leading zeros and long decimal spellings stay intact.

Limits and privacy

200 KB dictionary, 100 fields; 100,000 rows, 300 columns and 2 million cells. Exports contain dictionary fields only; no formula calculation or unit conversion.

Common questions

Are long IDs converted to numbers?

No. Validation preserves original text.

Explore tools

简体中文