Exporting from Excel into the Advanced Wire Marking Systems Software

Recently we have had a number of requests for troubleshooting the export/import function of legends for printing heat shrink sleeves. We thought it would be a great time to review the process and share our notes and a video.

Users of the Advanced Wire Marking System software for the Impact 245+ Thermal Printer for printing heat shrink sleeves have two ways to input data:

1. Use the Advanced Wire Marking System software; enter the legends directly into the software.
   1. If you want to enter your legend and print without saving, use the Quick Entry.
   2. If you wish to save your legends, create a file and save it for later retrieval and or modification.
2. Enter your legends into Excel and export them to the Advanced Wire Marking System Software (detailed instructions below).

Importing One Line of Data from Excel:

1. Isolate data into its own spreadsheet. Be sure the column A is your data, column B will be the quantity number for the marker in column A.
2. To import; go to “Import Data into Marker File” option on AWMS software menu.
3. Select “Excel” option.
4. Select the file to import from drive, directory, “file name”.
5. Double click on File Name.
6. Choose Sheet (usually Sheet 1).
7. Columns for copies – type “2” if there is a column “B” with quantities.
8. Number of rows to exclude – refers to a header row you do not wish to print (if so, type “1”, if not type “0”).
9. Select “Accept”, view Excel sheet if needed
10. Set up marker, code, size, lines..
11. Close window.
12. Choose “Open an Existing Marker File”, proceed as usual.

If you have a question about this process, please contact andrew@neumannmarking.com