Title: XML Sample File
Last modified: October 21, 2020

---

# XML Sample File

 *  Resolved [msdesignfoto](https://wordpress.org/support/users/msdesignfoto/)
 * (@msdesignfoto)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/xml-sample-file/)
 * Hello there.
    I am currently researching for a way to import a large amount of
   products into Woocommerce, and I know now that its possible to import a XML or
   CSV file. Ok, but now I have a very simple question: what is the layout / template
   we should use in, say, Excel spreadsheet, in order to export it correctly? I 
   can’t seem to find this information anywhere and all the tutorials about importing
   the csv or xml file start with some pre-made file, and I don’t know how to elaborate
   that file.
 * Thank you

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/xml-sample-file/#post-13592577)
 * Hi [@msdesignfoto](https://wordpress.org/support/users/msdesignfoto/),
 * > Ok, but now I have a very simple question: what is the layout / template we
   > should use in, say, Excel spreadsheet, in order to export it correctly?
 * Basically, you just need a header row with the column names (like “Product Title”,“
   SKU”, “Parent SKU”, “Price”, etc), then you’ll have rows below that for each 
   product. We have example files here: [http://www.wpallimport.com/documentation/woocommerce/example-files/](http://www.wpallimport.com/documentation/woocommerce/example-files/).
 *  Thread Starter [msdesignfoto](https://wordpress.org/support/users/msdesignfoto/)
 * (@msdesignfoto)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/xml-sample-file/#post-13592589)
 * Thank you very much! That’s what I needed to know 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘XML Sample File’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-xml-csv-product-import/assets/icon-256x256.png?
   rev=2570167)
 * [WP All Import – Product Import for WooCommerce](https://wordpress.org/plugins/woocommerce-xml-csv-product-import/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-xml-csv-product-import/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-xml-csv-product-import/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Excel](https://wordpress.org/support/topic-tag/excel/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [xml](https://wordpress.org/support/topic-tag/xml/)

 * 2 replies
 * 2 participants
 * Last reply from: [msdesignfoto](https://wordpress.org/support/users/msdesignfoto/)
 * Last activity: [5 years, 7 months ago](https://wordpress.org/support/topic/xml-sample-file/#post-13592589)
 * Status: resolved