Open Innovations

CSV Cleaner

ALPHA

Tidy up some of the common formatting issues that make CSV files harder to consume. This tool is aimed at those in Local Authorities who publish open data and want to make their files easier to reuse. We also have a tool to generate a GeoJSON file from a CSV and another tool to add Latitude and Longitudes columns to a CSV using Postcodes.

Select a CSV file

We'll only work with it within your browser so you don't need to worry about anything getting uploaded. You could check it is a valid CSV file first with CSVLint from ODI HQ.

Drop CSV file here (or click to browse files)

Check the table

Make sure to check if the table has been cleaned correctly.


						

or copy and paste the output into a file with a .csv extension.

Messages