Forum Discussion

Brass Contributor

Aug 12, 2022

Export SharePoint list retaining SharePoint formatting

I had a request to see if we can export our sharepoint list to excel but retain the color coding and formatting. Is there a way to do this?

MVP

Aug 12, 2022

VeeExcelLearn No, you cannot export SharePoint JSON formatting while exporting list to excel.

If you are trying to create a new list based on existing SharePoint list & retain the same JSON formatting in new list, you have to use this option: Create a new list based on the columns in another list

Note: This approach will not copy data from old list to new list.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

VeeExcelLearn

Brass Contributor

Aug 12, 2022

ganeshsanap, we have users in the C-suite space that will probably print this SharePoint list out. The color scheme matters because it helps them visually see if a position has urgency. Some of them want to export it to excel so they have a list. I know kind of silly as it should stay in SharePoint but they asked me to look into it. Maybe there is some way to use Microsoft flow to creat some sort of a report in HTML or something. Not sure.

RobElliott
Silver Contributor
Aug 12, 2022
VeeExcelLearnnope, it won't retain the JSON column formatting. An HTML table could be created in a flow in Power Automate but you would have to go to quite a lot of effort to re-create the formatting. There is nothing in Power Automate that will keep the formatting from the SharePoint list.

Just give your users the link to the SharePoint list and make them read-only users. Or add a List web part to a page in your SharePoint site and give them the link to that page.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)