Clay Icon

Automatically Adding 2000 Rows to a Blank Table in Excel

Β·
Β·

Are there a way I can add 2000 on a blank table automatically? so i don't have to click "new row" 2000 times?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Unfortunately, there isn't a direct way to automatically add 2000 blank rows at once in our app. However, you can add new rows one at a time by clicking the "+ New Row" button at the bottom of your table. For bulk operations like this, you might want to consider using our API or integrations. If you need further assistance with this specific task, please request to talk to a person in this chat for more tailored help.

  • Avatar of Amir D.
    Amir D.
    Β·
    Β·

    talk to a human

  • Avatar of Amir D.
    Amir D.
    Β·
    Β·

    how can i do this with API

  • Avatar of Amir D.
    Amir D.
    Β·
    Β·

    it takes me so many hours

  • Avatar of Muhammad S.
    Muhammad S.
    Β·
    Β·

    Amir D. you can just genreate a csv online with x number of rows and upload that csv and it will auto generate the number of rows in table, then you can delete the column in clay table

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    Hey Amir, can you try the following: Open a Google Sheet and copy the first 2,000 empty rows. Then, go back to the first blank row in your Clay table and paste those "empty" rows. This should trigger Clay to recognize and populate an additional 200 rows. Let me know if that works!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·
  • Avatar of Amir D.
    Amir D.
    Β·
    Β·

    It works sorry for the radio silence