I have a sheet for an event and I need to generate identification cards like in the image for the pieces on the contest, around 1000 pieces, so no way to manually do it.

enter image description here

I did a similar thing years ago but I can't remember how I've done it and can't find the file.

Some kind soul could help me?

  • first, you will create "template" by copypasting range A1:L8
  • when done you can deploy your formula after you respectively change ranges:


  • demo spreadsheet - copy


| improve this answer | |
  • There is no other way to do this? To copy and paste and change the cells for around 1000 of this cards is not that effective. Can we do this with a google script or something similar? I really need this automatic as possible – Comunicação Andreia Jul 11 '19 at 8:33
  • it could be all done under 15-20min if you would provide all the necessary stuff. also, a lot of it is just me guessing coz of a major lack of your desired output format of the final project – user0 Jul 11 '19 at 10:59
  • here I made you already a pre-formatted template for 1000+ cards - docs.google.com/spreadsheets/d/… – user0 Jul 11 '19 at 13:06
  • hello, sorry for the delay. I talked yesterday with the organization of the event. They discarted the possibility of doing the labels prior to the event because if someone doesn't attend it will be work thrown to the trash. What they want is to print the labels when the people arrive at the place to confirm the registration with a thermic printer or a small label printer, like a "shipping label". – Comunicação Andreia Jul 14 '19 at 22:30
  • Can it be done on google docs with a better design template? I think it can be treated like a shipping label because it will be printed 1 by 1 at the moment the person deliver the pieces for the contest – Comunicação Andreia Jul 14 '19 at 22:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.