
Export Content from SAP B1 to Spreadsheet
1. Open any marketing document. Right click the document form and choose “Copy Table”.
2. Go to Excel, right click and choose “ Paste”. You will see the document lines have copied over to the spreadsheet.

Import Spreadsheet Data into SAP B1
1. After you edit the data, you can select these items as documents lines and copy the table.
2. Open any of the Marketing document. First to fill in the Business Partner data. On the document line, right click and choose paste.
You will see the data in Excel has been copied over to SAP Business One!