The standard CSV format allows manifest data to be loaded into SpeEDI Cargo from comma separated data.


To output from an Excel spreadsheet with the correct delimiters you would save the file as CSV or alternatively 'Text (Tab delimited)'.  


The Excel template file attached contains the supported columns headers.


Limitations

Each line in the file is treated as a separate consignment.   For inbound cargo, each row must have a unique bill number (duplicates will be skipped).

Given this, only singular package/containers can be provided per consignment, so it more suited to a simple consolidation rather than a carrier manifest where you may have multiple containers per freight bill.



Delimiters

Fields must be separated by either a comma (CSV) or a tab (text).


Rows must be separated by carriage return and line feed characters (CRLF)



Data

The first row of data must contain the column names.


The column names can be in any order but must match those below exactly.


Columns names that are not recognized are ignored.


A BillNumber column is required. All other data items are optional


BillNumber    
This can be a booking number, bill or lading or housebill number.  This is a Required field
ClearanceNumber
A TSW clearance number.  Can be provided where the goods have been cleared externally.
ClearanceExemption
For NZ shipments enter the following:
  • WOF - To indicate import write-off clearance
  • LOW - To indicate export low value clearance
TariffCode OR Tariff
The following formats are acceptable:
3926.20.62.02H
3926.20
ShipperName
The shipper's name
ShipperAddress1 
The shipper's address (line 1)
ShipperAddress2
The shipper's address (line 2)
ShipperCity
The shipper's city (address line 3)
ShipperRegion
The shipper's region (address lne 4)
ShipperTaxNumber OR ShipperTaxNoThe shipper's business/tax number
For NZ this is the GST number for import taxes
TaxPrepaid

Valid values are:

  • Y = Pre-paid
  • N = Not pre-paid
  • null or omitted = Supplier is exempt (ie not required to collect tax)

For values Y/N, a valid tax number should also be provided for the shipper.   


ConsigneeName
The consignee's name
ConsigneeAddress1
The consignee's address (line 1)
ConsigneeAddress2
The consignee's address (line 2)
ConsigneeCity
The consignee's city (address line 3)
ConsigneeRegion
The consignee's region (address line 4)
ConsigneeContactName
The consignee contact persons name
ConsigneeContactPhone
The consignee contact phone number
ConsigneeContactEmail
The consignee contact email address
NotifyPartyName
The notify party name
NotifyPartyAddress1
The notify party address (line 1)
NotifyPartyAddress2
The notify party address (line 2)
NotifyPartyCity
The notify party city (address line 3)
NotifyPartyRegion
The notify party region (address line 4)
GoodsDescription
A description of the goods
NewOrUsed
Enter USED to indicate used goods, otherwise new goods will be assumed
PackageQuantity
The total package quantity
GrossWeight
The total gross weight
GrossWeightUnits
The total gross weight units.  Supported units are KGM, LBR, TNE, GRM,
Volume
The total volume
GoodsCurrency
The goods currency.  For example USD, EUR, GBP, AUD
GoodsValue
The total goods value
ManufactureCountry
The goods manufacture/origin country.  For example US, CN, DE    
OriginPort
The origin location as a port code.  A full UN/LOCODE is required such as USLAX
DestinationPort
The destination location as a port code.  A full UN/LOCODE is required such as NZAKL
ClientReference
The clients reference number (e.g. an order number)
ContainerNumber
A container number
ContainerStatus
FCL - Full container load
LCL - Part container load
FAK - Full mixed container load
ContainerISOCode
The ISO code for the container e.g. 20GP