CleanCSV

Remove Line Breaks Inside CSV Cells

Join multi-line cells, such as addresses and comments, into a single line so every record fits on one row in any system.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above.

  2. 2

    Remove line breaks inside cells is on. Each line break, and any spaces around it, becomes a single space.

  3. 3

    Check multi-line cells in the preview, which shows the old value underneath, then download.

Why line breaks break imports

CSV allows line breaks inside quoted cells, but many importers, older databases and command-line tools treat each line as one record. A comment that contains an Enter key then splits a record in two and shifts every column after it. Removing line breaks makes the file safe for all of them.

Alt+Enter in Excel

Cells where someone pressed Alt+Enter (Option+Return on a Mac) contain line breaks that are easy to miss in Excel but cause broken rows elsewhere. The preview shows these cells on several lines so you can spot them before cleaning.

Using a different separator

To join lines with something other than a space, for example “; ”, use Find & replace instead: turn on Regular expression, find \r?\n and replace it with your separator.

Frequently asked questions

Will this remove the line breaks between rows?

No. Only line breaks inside cells are removed. Rows stay separate.

Does it handle Windows and Mac line endings?

Yes. Windows (CR LF), Unix (LF) and old Mac (CR) line breaks are all handled.