Saving issued barcode numbers into xls or csv format files

< return to Orders 01 Course

Goals: 

   Please click the [ Mark Complete ] button at the bottom of this page when you’ve completed these goals:

  • Learn how to quickly transfer issued barcode numbers into xls or csv format files. 

Watch:   

   82 – Saving issued Barcode Numbers into xls or csv format files
This video shows how to quickly transfer issued barcode numbers into an xls or csv file (as used in Excel or Google Sheets) | The numbers would have been sent by email, and are in the simple text layout “0123456781, 0123456782, 0123456783….” |
Start by copying the entire block of numbers and pasting into a blank MSWord document – they will paste with commas between numbers | Now you need to change their layout to one-per-line with no comma… | To do this, press ALT-E-E to open the Find and Replace dialogue, Type “, ” (comma space) into the Find text box and “^p” (linebreak) in the Replace text box, and click the Replace All button – this should rearrange the barcodes one-per-line | Press CTRL-A to select them all, then CTRL-C copy them all | Open a spreadsheet and CTRL-V to paste them | The numbers should now each be in their own spreadsheet cell | If they are in scientific format, right-click > Format cells > choose “Custom” > type thirteen zeros in a row and click OK > This forces them into the exact format that we want | Save the file as a spreadsheet (.xlsx) and also as a .csv file | You can send both of these files to the customer |
Note: sometimes Excel removes the leading zero for each number, but this is not problematic |