Forum Discussion

Retaining3118's avatar
Retaining3118
Copper Contributor
Dec 04, 2024

How to preserve colors when exporting SharePoint list data as an excel file?

I've been working with a SharePoint list that has several columns with specific color-coded formatting. When I try to export the data, I'm losing these important visual cues that help me quickly interpret the information.

  • How can I ensure color formatting preserved when I click the "Export to Excel" button?
  • Are there any known workarounds (i,e, via power apps or power automate)? If so, which would be best if I am exporting around ~1000 rows of data each time 
SharePoint Online

1 Reply

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Dec 04, 2024

    There is no way to keep the JSON formatting when the list is exported to Excel.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources