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.


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


**Multiple commodities per consignment may be included by repeating the consignment details across rows.  See sample CSV file attached (refer to HAWB3)



Consignment
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
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)
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)

Package / Commodity
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
TariffCode OR Tariff
The following formats are acceptable:
392620
3926.20 

3926206202H
3926.20.62.02H

3926.20.62 02H
GoodsCurrency
The goods currency.  For example, USD, EUR, GBP, AUD
GoodsValue
The total goods value
ManufactureCountry
The goods manufacture/origin country.  For example,ple US, CN, DE    
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