Use the Bkper add-on for Google Sheets to quickly manage groups. It's a direct way to import or export existing groups between Bkper and Google Sheets. With this solution you can easily create groups in batch.

Import groups from Sheets to Bkper (Record)

  1. On your computer, open a Google spreadsheet.

  2. Click Add-ons > Bkper > Open.

  3. Select your book.

  4. Click Record tab.

  5. Choose Groups.

  6. Highlight the cells you want to import data.

  7. Click Record button.

  8. That's it! Now, the groups appear on your book.

Export groups from Bkper to Sheets (Fetch)

  1. On your computer, open a Google spreadsheet.

  2. Click Add-ons > Bkper > Open.

  3. Select your book.

  4. Click Fetch tab.

  5. Choose Groups.

  6. Select the cell you want.

  7. Click Fetch button.

  8. That's it! Now the Name, Type, Parent, (number of) Children and (number of) Accounts of your groups appear on Sheets.

Did this answer your question?