Export – Import

Hi there,

Users do often report issues with Excel, so we generally recommend using something like Google Sheets or Open Office instead.

Something in the conversion back and forth between XLSX seems to break something in the formatting/file, or add extra data to the file that messes up the import. You could try opening up the CSV file in a text editor, and compare what you see in a CSV file right after it’s exported with what you see in one that has been converted to XLSX and back. (I don’t have Excel here, so can’t test it myself)

Thank you.
Can xlsx install directly with customization? So I want to import as xlsx instead of csv. Is this possible ?

Hi there,

There is no built-in functionality for that in the WooCommerce plugin, however it looks like it should be possible either via a plugin, or custom code — here are some examples:

https://www.ads-software.com/plugins/woo-product-excel-importer/
https://www.webtoffee.com/woocommerce-import-products-from-excel/
https://codeable.io/how-to-import-products-from-xlsx-into-woocommerce/

If you have any questions about any of those particular solutions, please reach out to the appropriate team directly.