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?


1 Answer 1

  • 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


  • 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 Jul 11, 2019 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, 2019 at 10:59
  • here I made you already a pre-formatted template for 1000+ cards - docs.google.com/spreadsheets/d/…
    – user0
    Jul 11, 2019 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". Jul 14, 2019 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 Jul 14, 2019 at 22:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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