Fix a Broken CSV

Fix a Broken CSV by normalizing rows with inconsistent column counts. Fill missing cells, trim fields, and export the cleaned CSV instantly.

Paste your input above or import a file below.
No file chosen
Supported file types: .csv, .txt, .tsv, .log, .json, .xml, .md, .ini, .yaml, .yml, .html, .htm, .css
Total characters: 0
Options
Trim fields
Fill missing cells
Maximize output

How to Use:

  • Paste your broken CSV data into the Broken CSV Input box or upload a file using Choose File. Supported formats include .csv, .txt, and other plain text files.
  • Enable Trim fields to remove extra spaces around each cell.
  • Toggle Fill missing cells to automatically add empty values so every row has the same number of columns as the header.
  • Use Maximize output to expand the result area for easier reading.
  • The Fixed CSV Output updates live and flashes each time it’s refreshed.
  • Copy the result using Copy Output, or save it with Export to File.
  • A live Total characters counter appears below the output.
  • Click Clear All to reset everything, including input, toggles, and file.

What Fix a Broken CSV can do:

Fix a Broken CSV helps repair rows that are too short or too long by comparing each row to the longest one and adjusting accordingly. It’s ideal for malformed exports, scraped CSVs, or manually edited files that lost structure. You can trim each field for cleanliness and choose whether to fill out missing columns with blanks. It’s fast, browser-based, and doesn’t require uploading to any server.

Example:

Input:

Name,Age,City  
Alice,30  
Bob,27,London,UK  
Charlie,33,Sydney

Output (with Fill missing cells on):

Name,Age,City,  
Alice,30,,  
Bob,27,London  
Charlie,33,Sydney

Output (with Fill missing cells off):

Name,Age,City  
Alice,30  
Bob,27,London  
Charlie,33,Sydney

Common Use Cases:

Use Fix a Broken CSV when importing data from inconsistent sources, recovering partial exports, or trying to prep messy spreadsheets for analysis or upload. It’s especially helpful when you don’t know how many columns should exist the tool figures that out for you and pads or trims each row accordingly.

Useful Tools & Suggestions:

Start with Validate CSV to spot where the structure falls apart. Then give Replace a CSV Column a try if you need to swap out corrupted sections without rebuilding the whole file.

Related Tools