Skip to main content
All CollectionsProducts
Export Products Data Format
Export Products Data Format

To export product data with different format.

Ridho Alamsyah avatar
Written by Ridho Alamsyah
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, XLSX or TXT 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, XLSX, and TXT 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

Product - Export

Step 2. Choose the data format to Export

Export Product Format

Notes:

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

Notes:

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.

TXT Format:

TXT Format

Different between CSV, XLSX and TXT Format:

CSV

XLSX

TXT

Structure

Stores data in plain text with values separated by commas. Each line represents a row, and commas separate columns.

A binary file format used by Microsoft Excel. Supports multiple sheets, complex formatting, formulas, charts, and more.

Stores plain text without formatting. Data is unstructured, often with a line break or spaces between values.

Usecase

Ideal for simple tabular data and easy to import/export between different applications (e.g., Excel, databases).

Best for complex data, including calculations, formatting, and interactivity.

Best for simple notes or unformatted textual data. It can be used to store lists or logs.

Limitations

No support for complex formatting or multiple sheets.

Larger file size compared to CSV, proprietary to Microsoft Excel (though can be opened by others like Google Sheets).

No support for tables, rows, columns, or any complex structure like CSV or XLSX.

In summary:

  • CSV: Simple, text-based, easy to import/export tabular data.

  • XLSX: Supports rich data, formatting, and calculations.

  • TXT: Plain text with no structure, used for basic data or text storage.


Related Articles


DealPOS is an online point-of-sale (POS) application specifically designed for retail businesses in categories like Fashion, Minimarkets, Electronics, Fresh Food, and Building Material Stores.

With DealPOS, you can manage both online and offline store inventory in real-time on a single platform. You can also sell through omnichannel (offline and online) as DealPOS integrates with marketplaces (Shopee, Tokopedia, TikTok Shop, Lazada) and instant web stores (Shopify and WooCommerce).
​

dealpos-trial-indonesia


​


​

Did this answer your question?