"XLSX"

How to export data from Magento 2 in XLS & XLSX formats

January 14, 2021 - E-Commerce, Magento 2

Magento 2 export CLI

Recently, we’ve come across a question by user00247 regarding how to export data from Magento 2 in an XLS format. Another StackExchange user proposed a solution that is also provided below. However, it is aimed at technical users only. Therefore, we’ve decided to elaborate the provided answer with an alternative solution, shedding light on how to export data from Magento 2 in XLS & XLSX formats and what’s the difference between them. Before going any further, pay heed to the fact that Magento 2 supports neither XLS nor XLSX files by default. Continue Reading

How to Import Excel (XLS & XLSX) and OpenOffice (ODS) Files to Magento 2

May 4, 2018 - E-Commerce, Magento 2, Our extensions

Magento 2 Excel import export

If you have an Excel file (XLS or XLSX) with data that should be imported to Magento 2, you’ve come to the right place. Although the e-commerce platform supports neither XLS nor XLSX by default, we know how to achieve your goal. The following article describes the most user-friendly way of Magento 2 Excel files import. Continue Reading