# Can't export product data to excel sheet **URL:** \ **Category:** Questions\ **Tags:** litium-7\ **Created:** [August 8, 2019, 3:18pm UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017 "2019-08-08T15:18:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![MariliaBognandi](https://avatars.discourse-cdn.com/v4/letter/m/3d9bf3/32.png) [@MariliaBognandi](https://forum.litium.com/u/MariliaBognandi)\ **Post date:** [August 8, 2019, 3:18pm UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/1 "2019-08-08T15:18:51Z")
We have created a custom product data template with additional fields and created a product with it. When trying to export product data to an excel sheet (to be able to add more similar products and then import them) some fields can’t be exported, see image. Most fields work, some don’t. I have identified the fields that don’t work. But I don’t understand why they don’t work. Did anyone else come across this? ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/018d43536835829006dc251b351801e2b2f4c0b1.png) Litium version: 7 ---
**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\ **Post date:** [August 8, 2019, 3:54pm UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/2 "2019-08-08T15:54:27Z")
Are there any errors in the logs? What are the fields that doesn’t work? Have you tried restarting the site and then exporting? ---
**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\ **Post date:** [August 8, 2019, 4:25pm UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/3 "2019-08-08T16:25:53Z")
Also, which exact version of Litium are you using? ---
**Author:** ![MariliaBognandi](https://avatars.discourse-cdn.com/v4/letter/m/3d9bf3/32.png) [@MariliaBognandi](https://forum.litium.com/u/MariliaBognandi)\ **Post date:** [August 9, 2019, 2:08pm UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/4 "2019-08-09T14:08:11Z")
There are no error messages in the log. And we’re using Litium 7. We have a theory that the export can’t be done when you try to export fields (with type TextOption) that don’t contain any options. When we added some option to the field, the export was completed. We were hoping to be able to add the options when you import the excel, but I guess then it needs to be done before even exporting an excelsheet to add data in. ---
**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\ **Post date:** [August 12, 2019, 7:44am UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/5 "2019-08-12T07:44:55Z")
This sounds like a bug that was fixed in 7.2.1, [https://docs.litium.com/support/bugs/bug\_details?id=45821](https://docs.litium.com/support/bugs/bug_details?id=45821) The options for the field needs to be set in advance. The import will only set the value if it’s a valid option, not create new options “on demand”. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/12eddac3b8b661de1db86af10ac8151b571e6fb9.png) [@system](https://forum.litium.com/u/system)\ **Post date:** [September 9, 2019, 7:56am UTC](https://forum.litium.com/t/cant-export-product-data-to-excel-sheet/1017/6 "2019-09-09T07:56:07Z")
Closed on September 9, 2019, 7:56am UTC This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.