Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
RenzoSb
Contributor
Contributor

Exporting a table to Excel and keeping the colours of the cells

Good morning is it possible to export the data and having in the Excel spreadsheet the colours that appear in Qlik Sense?

Many thanks.

Labels (1)
1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

When you select the option to export to excel it is stated "Download as .. > Data", which means that the export will take care only of the date to be exported into the EXCEL file. 

 

The same question was raised by other users as well, such as "Export Excel with color" [1], where the response states that it is not possible. In the same post it is stated that you can use the customer extension "LogiExport " [2], which will give you the option to keep the colors within the cell.

 

If you would like to have this option natively, then you can submit a feature request [3] and elaborate in detail as to why this feature is very important for you and probably other users as well.

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue or address your concerns, please mark it as accepted solution to give further visibility to other community members. 
 

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Export-Excel-with-color/td-p/1455575

[2] https://logiexport.logsys.co.il/

[3] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

2 Replies
Andrei_Cusnir
Specialist
Specialist

Hello,

 

When you select the option to export to excel it is stated "Download as .. > Data", which means that the export will take care only of the date to be exported into the EXCEL file. 

 

The same question was raised by other users as well, such as "Export Excel with color" [1], where the response states that it is not possible. In the same post it is stated that you can use the customer extension "LogiExport " [2], which will give you the option to keep the colors within the cell.

 

If you would like to have this option natively, then you can submit a feature request [3] and elaborate in detail as to why this feature is very important for you and probably other users as well.

 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue or address your concerns, please mark it as accepted solution to give further visibility to other community members. 
 

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Export-Excel-with-color/td-p/1455575

[2] https://logiexport.logsys.co.il/

[3] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
Sebastian_Dec
Creator II
Creator II

Hi, it's been 2 years since this question.

Is there anything known about this? Straight tables can already be downloaded in colors, but pivot tables are still not available, do you know when it will be introduced?

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.