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.
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.
Load example (14/01/2019 Leeds City Council Business Rates data from Data Mill North)
Make sure to check if the table has been cleaned correctly.
Save CSV or copy and paste the output into a file with a .csv extension.
