columnly.io
Upload a file

Clean, visualized data in minutes

columnly.io is a do-it-all data cleaning tool. Upload a file, set code-free cleaning rules, and export a clean file and chart. All in one place.

Try it free How it works

Hours of cleanup, done in a few clicks.

Duplicate rows highlighted in the columnly workspace
01

Remove duplicates

Find rows repeated across every column and drop them, keeping the first.
Mixed date formats converted to YYYY-MM-DD
02

Reformat mixed columns

03/04/2026, Mar 5, 2026, 2026.03.14: one rule turns them all into one standard format.
Bar chart of amount by region in the chart builder
03

Create visualizations

Start from a suggested chart, preview it live, export as PNG, SVG or PDF.

More rules for messier data.

  • Concatenate
    Concatenate columns with a chosen separator

    Concatenate columns together

  • Default Value
    Replace NaN's and N/As with a default value

    Set default values in columns

  • Split Columns
    Split columns into new columns based on a separator

    Split a column into two columns

  • Standardize Data
    Standardize data based on a key value

    Standardize data sharing a common identifier

  • Trim Characters
    Trim characters from the left or right side

    Trim characters off the left or right side of a column

Bring on multiple datasets.

Join datasets
Inner Join · Left Join · Right Join

Multiple ways to join datasets

Join your datasets in a way that fits your workflow. See a live SQL preview of your join.

Build it once.
Rerun it forever.

Save your steps as a workflow. Next month’s export goes in, the same clean file and chart come out.

Explore workflows
The chart builder showing an Amount by region bar chart, refreshed from the workflow’s latest run
  1. 01Build it once.
  2. 02Every step, saved.
  3. 03Next month’s file goes in…
  4. 04…the same clean file and chart come out.

Priced per workflow, not per seat.

Free
$0
  • 4 exports / month
  • Files up to 50k rows
  • PNG and CSV export
Start free
BasicPopular
$5 /mo
  • 6 exports / month
  • 1 saved workflow
  • Files up to 250k rows
  • All export formats
  • Create visualizations
Subscribe
Professional
$15 /mo
  • 32 exports / month
  • 4 saved workflows
  • File history
  • Scheduled reruns
  • All export formats
  • Create visualizations
Subscribe
Unlimited
$30 /mo
  • Unlimited exports
  • 32 saved workflows
  • File history
  • Scheduled reruns
  • All export formats
  • Create visualizations
Subscribe

Bring the ugliest
file you have.

Upload a file