All Collections
Export Products Data Format
Export Products Data Format

To export product data with different format.

Christian Wijaya avatar
Written by Christian Wijaya
Updated over a week ago

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 choose the CSV file format.

The steps below will explain the differences between CSV and XLSX formats and the purpose why DealPOS provides choices of these formats when users want to export product data

Step 1. Go to the Products Menu, then Click the Export Button

Export Product

Step 2. Choose the Data Format to Export

Data Format to Export


The minimum Microsoft Office requirement to open a DealPOS XLSX file is Microsoft Office 2003. We do not recommend using the version below.

Step 3. Try to View Exported Data

XLSX Format:

XLSX Format


The system will not change automatically data that has comma usage.

CSV Format:

CSV Format

Notes :

The system will change automatically data that has comma usage.

Our purpose in creating XLSX format while exporting products is to reduce data that is automatically changed by the CSV system. This will 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 other differences between CSV and XLSX formats, please check the table below.

Different between CSV & XLSX Format:



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 a data warehouse, CSV follows a fairly flat, simple schema

In a data warehouse, Excel is preferable for detailed standardized schema specification

CSV is safe and can differentiate between 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 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 files can be opened with Microsoft Excel doc only.

Related Articles




Did this answer your question?