How can I save my Excel file in the right format for serial printing of CSV files?

If you want to use the serial printing function, check the article How can I do serial printing of CSV files?

The CSV file for the serial printing needs to be saved as a CSV UTF-8, in order to ensure that all signs (mainly special characters or language specific letters) are displayed in the app and then printed. If you cannot select this option directly in your MS Excel version, follow the steps below:

1. Open Excel and create the table of your choice.
2. Go to File and then Save as and choose the location where you want to save your file.
3. At Save as type select CSV (Comma delimited) and press Save.
   
4. A pop-up window will appear on your screen that some features might be lost. Press Yes.
5. Close Excel. If a pop-up window appears asking you to save changes, please press No.
6. Now right-click on the file you just saved, click Open with and then select Notepad.
   
7. Go to File and then Save as. At the bottom of the window you will find a dropdown list called Encoding, there select UTF-8 and press Save.
   Note: It is crucial to NOT change the name of the file. If you change the name, a separate text file will be saved which cannot be imported to the e-mark app.
   
8. A pop-up window will appear on your screen asking you if you want to replace the file, press Yes.
9. Proceed with importing the file to your e-mark app.
   Note: If you change or add data in your already saved file, you will have to carry out the steps again because the Excel file will reset the format.