Forum Discussion
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?
VeeExcelLearn You can't export the formatting into Excel, but this might work.
- Export to Excel
- Go to the Data tab, and open Queries and Connections.
- Double click on the connection, and set the spreadsheet to Refresh Data when opening file. Click ok.
- Update the spreadsheet to have similar conditional formatting.
- Post the spreadsheet where anyone can download a copy (SharePoint, Teams, OneDrive, Send a link out to it on a regular schedule).
When the document is opened the data will refresh and the formatting will be applied. Let me know if you have any questions.