CareerByteCode

JSON Data Profiler: Column Types and Nulls

For analysts doing a first data-quality check on an API export or dataset. Paste a JSON array of objects and get a one-table summary of every column.

FreeRuns in your browserNothing uploadedNo sign-up neededAll 10 tools in the Data Toolbox
Keep this resultSign in to email it to yourself or save it to your profile. The tool itself never needs an account.

ByteLabs

Close the gaps with real-world projects

Build industry projects on ByteLabs and add verified proof of your skills to your public profile.

Explore ByteLabs
How to use

How to use the Data Profiler

  1. Paste a JSON array of objects into the box.
  2. Click Profile.
  3. Read the table: Column, Type, Filled, Null, Unique and Range for each field.
Worked example

An example, step by step

You enter

[{"name":"A","age":20},{"name":"B","age":null},{"name":"A","age":30}]

The tool shows

name: string, filled 3/3, null 0, unique 2 age: number, filled 2/3, null 1, unique 3, min 20, max 30, avg 25.0

FAQ

Questions about the Data Profiler

What counts as a null in the data profiler?

A missing key, a null value or an empty string all count as null for that column, and Filled shows the remaining rows.

How is the column type decided?

A column is number when every non-null value is a number, boolean when every value is true, false or null, and string otherwise, including mixed columns.

Can I profile a CSV file?

Not directly. Convert it with the CSV to JSON tool first, then paste the JSON array here.

Is the Data Profiler free and private?

Yes. It is free, needs no sign-up and runs entirely in your browser, so what you type is not uploaded. You only sign in if you want to email a result to yourself or save it to your CareerByteCode profile.

Copied