Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Maya_Shiff
Product and Topic Expert
Product and Topic Expert
554
From simple lists to complicated reports – we all use spread sheets. So basic and yet so powerful… no wonder that exporting data to spreadsheets has become a standard feature. SAP Business One has been supporting export to Microsoft Excel since forever and recently the option to export from the regular client to Microsoft 365 using OneDrive was made available as well. Now, taking another step forward, the integration to Microsoft 365 is supported also by the Web client:

No alt text provided for this image

When clicking the Export to Excel button, the given file opens in a new browser tab:

No alt text provided for this image

You can export list views, search results and the detailed views of sales documents to Microsoft OneDrive as Excel files using templates which are similar to ones used by the regular client.

Available in SAP Business One 10.0 FP 2105 and SAP Business One 10.0 FP 2105, version for SAP HANA. This tip and all the other tips are available on SAP Community. You can also visit the Implementation Arena for useful implementation tips.