How to make a copy of a template tab for each name in a list

By Jake Marsh · Updated

To make a copy of a template tab for each name in a list, open Extensions, Tabherd, Open Tabherd, choose Copy a template tab per row, pick the Template tab, choose One copy for every row of a tab in this file (or a name you paste), set Name each copy from the row such as {Last}, {First}, and click Preview, then Apply. You get one named copy per row, up to 200 per run.

When this saves the most time

  • A gradebook or feedback tab for each student in a class roster.
  • A timesheet or budget tab for each employee, client or project.
  • A tab for every week or month of a year, from a list of dates.

Duplicating by hand means copy, rename and type the person's name into the tab, once for every row. With 30 students, that's 30 rounds.

Steps

  1. Build the template tab with the layout every copy should have.
  2. Make the list. A tab with a header row and one row per copy, such as First, Last and Email. Or skip the tab and paste names, one per line.
  3. Open Tabherd and choose Copy a template tab per row.
  4. Pick the Template tab.
  5. Under One copy for every, choose row of a tab in this file, then the List tab, its Header row and the Name column. Rows where that column is blank are skipped. To paste names instead, choose name I paste.
  6. Set Name each copy. Use the list's headers in braces: {Last}, {First} or {Name} feedback.
  7. Fill cells in each copy if you want, such as B1 = {Name} and B2 = {Email}, so each copy already shows whose it is.
  8. Pick where they go: Right after the template or At the end, and what to do if a tab with that name exists: Skip that row or Add (2), (3).
  9. Click Preview to see every copy's name and the cells it fills, then Apply.

Undo a batch of copies

Undo in History deletes the copies the run made. Copies someone has edited since are kept unless you tick the option to delete them too, so a week of work in one student's tab isn't lost.

Plain duplicates

For copies without a list, such as five spare copies of a form tab, choose Duplicate instead, set Copies of each (up to 50) and Name the copies with a pattern like {name} copy {n}, where {n} counts 1, 2, 3.

What it costs

Tabherd is $2.99 a month or $19 a year per Google account. Free trial: 30 days or 60 applied changes, whichever comes first. No card needed. Every plan and the install link are on the Tabherd page.

Tabherd: Bulk Tab Manager for Sheets

Hide, sort, rename, protect and copy many Google Sheets tabs at once, with a preview and undo for every change $2.99 a month or $19 a year per Google account.


Questions

How many copies can I make?

Up to 200 per run. For a longer list, run it twice. The preview also warns if the copies would take the spreadsheet past Google Sheets' 10 million cell limit.

Do formulas in the template keep working?

Yes. Each copy is a regular Google Sheets copy of the template, with its formulas and formatting.

Can I make the copies in another spreadsheet?

No. Tabherd works only in the spreadsheet you have open, so the copies go next to the template.

What if two people have the same name?

Choose Add (2), (3) and the second copy gets "(2)" added. Or include another column in the name, such as {Last}, {First} {ID}.


More Tabherd guides


More Google guides