You might want to know the product data that you've added to DealPOS. To see the products list, you can try to Export the product data from the Products menu. The exported data will be formatted as a CSV File or XLSX File.
While Excel (XLS and XLSX) file formats are better for storing more complex data, CSV files are supported by nearly all data upload interfaces. If you are planning to move your data between platforms, export and import it from one interface to another, you might be better off with the CSV file format.
This article will explain what are the differences between the two formats. And what is the purpose of DealPOS providing a choice of these formats when users want to export product data.
Step 1. Go to Products Menu, then Click Export Button
Step 2. Choose Data Format to Export
Notes :
The minimum microsoft office requirement to open DealPOS XLSX file is Microsoft Office 2003. We not recommend to use version below that.
Step 3. Try to View Exported Data
XLSX Format :
Notes :
System will not change automatically data that has comma usage.
CSV Format :
Notes :
System will change automatically data that has comma usage.
Our purpose to create XLSX format while exporting product is to reduce data that automatically changed by CSV system. This will really help users who have a product code of more than 13 digits, because when a user has a product code of more than 13 digits and they exports data to CSV, the system will automatically replace / change these numbers or digits. And it will result in the product code listed on DealPOS not being the same as the one exported. To know about another different about CSV and XLSX format, please check the table below.
Different between CSV & XLSX Format :
CSV | XLSX |
CSV stands for Comma Separated Values. It is a plain text format with a series of values separated by commas. | It is a binary file that holds information about all the worksheets in a workbook |
CSV files can be opened or edited by text editors like notepad | Files saved in excel cannot be opened or edited by text editors |
In data-warehouse, CSV follows a fairly flat, simple schema | In data-warehouse, Excel is preferable for detailed standardized schema specification |
CSV is safe and can clearly differentiate between the numeric values and text. CSV does not manipulate data and stores it as-is. | With no clear distinction or separation between numeric values and text, Excel can mess up with your postal codes and credit card numbers with its auto formatting features |
In CSV, you write column headers only once | In Excel, you have to have a start tag and end tag for each column in each row |
Importing CSV files can be much faster, and it also consumes less memory | Excel consumes more memory while importing data |
CSV can be opened with any text editor in Windows like notepad, MS Excel, Microsoft Works 9, etc. | Excel file can be opened with Microsoft Excel doc only. |
You might like to read these related articles below :
To create a product, you can read this article : Create New Product
You can edit the product data by CSV file, to edit the product data using CSV file, you can read this article : How to Edit Product Bulk
You can also input the product data by using CSV file if you have large products data. To input the product data by using CSV file, you can read this article : Importing Product using Excel/CSV File
If you are having trouble opening the CSV file on your device, you can check this article : Fix Bad Format in CSV File (Windows OS) | How to Solve Bad Format in CSV File (MacOS)