ShipRush
ShipRush Dashboard
Submit an Idea
Contact Support

Excel Integration

Descartes ShipRush Web can read Order/Shipment data stored in an MS Excel worksheet and place the information into the Order list in Descartes ShipRush Web.

To save Tracking Numbers to MS Excel, go to SETTINGS > ACCOUNT SETTINGS > Reports > Order & Shipment. At the bottom of the page, choose to export the data back to MS Excel.

Warning: If the same spreadsheet is imported multiple times, its data is duplicated in Descartes ShipRush Web. This can cause significant issues, including the possibility of duplicate shipments.


MS Excel Requirements

Descartes ShipRush Web works with most modern types of spreadsheet files in MS Excel format, including .xls, .xlsx, and .xlsb files. All currently supported versions of MS Excel can be used.

Before a worksheet can be used with Descartes ShipRush Web, it must have the correct column names. See Column Names in the Worksheet.

To display and download a sample xls file, click here. The Download file button will be at the top of the spreadsheet.

Only the first worksheet in the workbook is imported.


Spreadsheet File Name

The spreadsheet file can be assigned any name.


Column Names in the Worksheet

Each worksheet column must have an appropriate name in order to identify the data. A basic set of columns is required. Additional columns are optional. See the sections that follow for lists of column names.

Column names are set by simply typing the names in row 1 of the worksheet.

Tip: If you enter column names regularly, consider creating an MS Excel macro to enter the column names for you.


Required Column Names for Parcel and LTL Shipping

  • Contact

  • Company

  • Address1

  • City

  • State

  • PostalCode


Order ID Column

Note: The addition of an OrderID column is strongly suggested. Your order data can have unique values (one orderID per row, indicating the row is a single order) or you can have the same OrderID value entered on more than one row, to indicate a single order has multiple order items. We support full row data, or partial row data if more than a single OrderID is used to indicate a multi-item order

  • Full row data information populated, like example OrderID 601

  • Partial row data information populated (only first row has ship to address information), like example OrderID 602


Generating Unique OrderID Values Automatically

If your source data lacks a unique value for each row, do the following:

  1. In row 1 of an empty column, enter OrderID.

  2. In row 2 of this column, enter this formula: =Row().


  3. Select the cell from step 2, and then press CTRL+C.


  4. Select all cells in this column to the end of the data--except for the cells in row 1 and row 2.

  5. Press CTRL+V to paste the formula into the selected cells in this column. Each row should now have a unique row number in the OrderID column.


Optional Columns for Parcel and LTL Shipping

  • Address2

  • Country

  • Email

  • Phone

  • IsPaid (enter Y if true)

  • IsShipped (enter Y, yes, or 1 if true)

  • ItemSKU

  • ItemAccountingID

  • ItemID

  • ItemDescription

  • ItemQuantity

  • ItemPrice

  • ItemTotal (total dollar amount of all items for this line item)

  • Tags (separate multiple tags with commas; for example: Tag1, Tag2, Tag3)

  • TotalAmount (the Order's total dollars)

  • TotalWeight

  • PackageType

  • PackageLength

  • PackageWidth

  • PackageHeight

  • OrderDate

  • CustomerPO

  • Reference (can also be Reference1)

  • Reference2 (not supported by all carriers)

  • Reference3 (not supported by all carriers)

  • Reference4 (not supported by all carriers)

  • Reference5 (not supported by all carriers)

  • PaymentType

  • ThirdPartyAccount

  • ThirdPartyCompany

  • ThirdPartyCountry

  • DeclaredValue

  • ShipMethod

  • AccountNumber

  • ShippingPaid

  • BillingAddress1

  • BillingAddress2

  • BillingCity

  • BillingState

  • BillingPostalCode

  • BillingCountry

  • BillingAddressBlock (full address data for billing entered into a single cell)

To control the Ship From address, you can use the following columns. Please note that all the fields are required in order to set the From information correctly (except those indicated as not mandatory)

  • ShipperCompany

  • ShipperName

  • ShipperAddress1

  • ShipperAddress2 (not mandatory)

  • ShipperCity

  • ShipperState

  • ShipperPostalCode

  • ShipperCountry

  • ShipperPhone (not mandatory)


Additional Columns for LTL

Note: Some of these elements only accept specific values. Click the item to see accepted values.


Column Format/Data Type

This step is required if the Postal Codes and/or Order IDs contain any non-numeric data. Do the following for both the Postal Code and Order ID columns.

To format the column:

  1. Select the entire column.

  2. Right-click the selected column, and then click Format Cells.

  3. In the Number list, click Text (see below).

  4. Click OK.

This worksheet is ready to go:

Back to Top