REMOVE ROWS

Which Ways Can You Pick Rows to Remove?

• Row numbers and ranges, such as 1-5, 12, 40-.
• The first N rows, such as report title lines above the real data.
• The last N rows, such as totals or footer lines.
• Every empty row.
• Rows that match a filter expression.
• Rows you selected in the grid by clicking row numbers.

In each case the tool shows the number of rows that will be removed before you press the button, so you can catch a range that is wider than you meant.

How Do You Write Row Numbers and Ranges?

Rows count from 1, starting at the first row below the header, so the header itself can never be removed by a number. A range uses a hyphen, and parts are separated by commas. You can mix single rows and ranges in one entry, such as 1-5, 12, 40-.

1. 12 is row 12, and 1-5 is rows 1 through 5.
2. 40- runs from row 40 to the end of the table.
3. last is the final row, and odd or even picks every other row.

How Do You Select Rows in the Grid?

Click a row number to select that row, and Shift-click another row number to select the range between them. Selected rows can then be removed here, or in the CSV editor. Undo keeps the last five changes, and Reset to original returns to the file as it was first read.

Removing rows works on one table at a time. Removing duplicate rows has its own tool, Remove duplicates, which shows groups of copies with their row numbers and keeps the first or last of each, so you do not have to find the repeated rows by eye.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.