Loona Automation logoLoona Developer Tools
Home › Developer Tools › CSV Profiler

CSV Profiler - Understand a File Before You Trust It

In short: the CSV Profiler reads a whole file and reports, for every column: the guessed data type, how many cells are empty, how many values are unique, the numeric minimum and maximum, and the three most frequent values.

Someone hands you a CSV and the first question is always 'what is actually in here?' The profiler answers it in one paste.

Private by design: everything in this tool happens 100% in your browser with JavaScript. Your input is never uploaded to a server, never stored and never seen by us - close the tab and everything is gone.

How to use the CSV Profiler

  1. Paste your CSV with its header row.
  2. Click Profile this CSV.
  3. Read the per-column table: type, empties, uniques, min/max, top values.
  4. Use it to spot dirty data - mixed types, unexpected blanks, near-duplicate categories - before importing.

How it works

Types are guessed by scanning every value with the same rules as our CSV to SQL converter: integers, decimals, booleans and ISO dates are recognised, and a mixed column falls back to text - which is itself a useful warning. Unique counts and top values expose category problems instantly (a city column with 900 uniques for 1,000 rows is not a category). Numeric min/max only appears for numeric columns; a text column shows its top values instead.

Frequently Asked Questions

Is this tool free?

Yes - completely free, no sign-up.

How accurate is the type guessing?

It is a scan of the actual values, so it reflects your data - a column of '001' codes guesses integer, which is why the top-values column is shown alongside for a sanity check.

What counts as empty?

A cell with nothing in it (or nothing after the CSV parser reads it). Spaces alone count as a value - trim first with the Dedupe & Cleaner if that matters.

Is my data uploaded?

No. Profiling runs 100% in your browser.

Related Developer Tools

Embed this tool on your website — free

Add this tool to your own website or blog — it is completely free, needs no sign-up, and always shows the latest version. Copy the code below and paste it into your page where you want the tool to appear. Keeping the small “Powered by Loona Automation” credit line under the embed helps keep this tool free — but you are free to style or remove it; the tool works either way.