In some cases when using a CSV file to with Microsoft Excel, you will need to correctly format the file in order for it to import seamlessly into Retail POS.
- Retail POS for Mac
- Microsoft Excel
- Open the CSV file
- Select the first column
- Click to convert the Text to Columns
- Change the text to be delimited
- Click Next
- Select Comma or select other and type in a comma character
- Click on Finish
The instructions for a Windows PC can be found in Using Excel to edit CSV files - truncated numbers/scientific notation. However, Retail POS now supports .xlx and .xlxs files for imports and exports on the product page.