Skip to end of banner
Go to start of banner

Creating Fake Barcodes in Excel

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

For some FOLIO workflows (for example, Course Reserves,) you may find yourself needing to add barcodes to electronic items. 

Some institutions use the item HRID as a stand-in (since it should be unique,) but you may want to take an approach that is more standardized (since the item HRID is not available in the Fast Add workflow since it doesn't exist yet.)

  1. In an excel sheet, copy paste "CR" into column A all the way down to the end of the number of barcodes you are trying to create.
  2. In column B, type in the number and then use a formula to add 1 to the number all the way down (so you create the desired sequence).
  3. In column C, use TEXT to transform the number into a string with leading zeros

  4. in Column D, concatenate column A and Column C to create the desired barcode format:



  5. Finally, copy / paste just the values from column D into Column E, so that staff can copy/paste the barcode without the formula reference.


  • No labels