How to Mass Delete Blank Rows in Your Spreadsheet After Importing CSV

·

is there a way to mass delete rows. i imported a CSV and it created like 500 extra blank rows. I don't want to have to select the box for each row individually

4 comments

Channeled
APP
·
·
You can efficiently remove multiple blank rows by using the deduplication feature. Here's how: 1. Right-click on any column that contains blank values in those extra rows 2. Select "Dedupe > Delete Duplicate Row"This will help you remove duplicate blank entries across your table. If you have multiple columns with blank values, you may need to repeat this process for different columns to ensure all unnecessary rows are removed. Source: Auto-update and Auto-dedupe Table
Owen C.
·
·
Hey Troy, thanks for reaching out! You can delete rows in mass by selecting the first row you'd like to delete on the left hand side of the screen, scrolling down to the last row you'd like to delete, hold shift, and click on the small box on the left hand side of the cell. Then you can right click and select "Delete x# of rows". Recorded a quick video showing the process. Hope this helps! Let me know if you have any other questions. :)
Channeled
APP
·
·
Channeled
APP
·
·
Hi Troy B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: