Clay Icon

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

  • Avatar of Channeled
    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

  • Avatar of Owen C.
    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. :)

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท
  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here.If you still need some help, just reply back here and someone from our team will be in touch!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Troy B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: