Keep supply chain data current in Microsoft Excel
Scheduled exports refresh your Microsoft Excel sheets with orders, shipments, and costs, and bulk imports read orders and rate cards back out.
| Type | Format | Rows | Status |
|---|---|---|---|
| Invoice Audit | xlsx | 1,284 | Pending |
| Finance Invoices | xlsx | 312 | Pending |
| Invoice Audit | xlsx | 5,902 | Pending |
Microsoft Excel Integration Capabilities
Spreadsheet software for shipping data analysis and bulk operations.
How the Microsoft Excel integration works
Connect Microsoft Excel
Authorize Microsoft Excel and choose the workbook and sheets CommerceShip refreshes and reads. Access is scoped to those files and can be revoked from either side.
Map columns
Match export fields to the columns your pivots use, and save a column mapping for the order, rate card, and address imports you read back out.
Refresh and import
Each run appends to the sheet or replaces the range, and imports read from the mapped sheet on demand.
Move data between CommerceShip and Microsoft Excel
Exports refresh the sheet on a schedule. Orders, rate cards, and address lists import from the sheet with a saved column mapping.
Other Data Destinations
Warehouses, databases, spreadsheets, and file storage you can send the same shipping data to
