Envíos / Shipment Management
Excel shipments
Table of contents
Steps to make mass shipments
- Log in to envia.com and go to the Create Shipment > Create shipments with excel
- You will see two sections; one to store the uploaded excel files and another to create shipments.
- Download the provided template
- Complete the shipping details, including origin, destination, package details, and any optional additional services.
- Once you have completed the template, click Upload excel
- Upload the file and all your submissions will be visible.
- Choose if you want to quote the shipping service or create labels directly.
Recommendations
- Correct any errors and make sure you comply with the country specifications before uploading the excel
- Be careful when expanding cells to avoid errors.
- Perform a second validation on the platform after loading the Excel to ensure the correctness of the information.
- Please review the examples provided with the Excel templates, as the columns may vary by country.
Excel template
Origin Information
| Column | Description |
|---|---|
| Order Reference | Order reference number |
| Name Origin | Sender's full name |
| Company Origin | Sender's company name (Optional) |
| Email Origin | Sender's email address |
| Phone Origin | Sender's phone number. |
| Country Code Origin | Country code of the destination |
| Street Origin | Sender's full address without abbreviations or special characters |
| Street Number Origin | Sender's address number |
| Interior Number Origin | Interior number (if applicable). |
| District Origin | District or locality of the address of origin. |
| City Origin | City of origin without abbreviations |
| Zip Code Origin | Postal code of the destination |
| State Code Origin | ISO state or province code (2 digits) |
| Street Reference Origin | Additional details about the street of origin (Optional) |
| Identification Number Origin | Precise location identification number (Brazil and LTL - Required) |
Destination information
| Column | Description |
|---|---|
| Name Destination | Recipient's full name |
| Company Destination | Destination's company name (Optional) |
| Email Destination | Recipient's email address (Optional) |
| Phone Destination | Recipient's phone number |
| Country Code Destination | Country code of the destination |
| Street Destination | Complete address of the addressee without abbreviations or special characters. |
| Street Number Destination | Recipient address number. |
| Interior Number Destination | Interior number (if applicable). |
| District Destination | District or city of destination (optional). |
| City Destination | Destination city without abbreviations |
| Zip Code Destination | Postal code of the destination |
| State Code Destination | State code of the destination |
| Street Reference Destination | Additional details about the destination street (Optional) |
| Identification Number Destination | Precise location identification number |
Package information
| Column | Description |
|---|---|
| Package Type | Type of packaging (envelope, box, pallet) |
| Content | Package contents |
| Unit Length | Unit of measure used for package length (e.g. cm, in). |
| Length | Package length. |
| Width | Package width. |
| Height | Package height. |
| Unit Weight | Unit of measure used for package weight (e.g. kg, lb). |
| Weight | Package weight. |
| Declared Value | Declared value of package content. |
| Currency | Currency in which the value of the package is declared |
| Insurance amount | Amount of insurance for the package, if purchased |
| Cash on delivery | Amount receivable |
| Carrier standard packages | Indicates whether standard carrier packages are being used |
| Product Name | Product description |
| Product Code | Harmonized System (HS) code for international shipments, and for domestic shipments. |
| Product Price | Price of the product being shipped |
| Product Weight | Weight of product being shipped |
| Made In | Country of origin of the product |
| Quantity | Quantity of items being shipped |
ISO country codes and state codes
| Country | ISO | States Code | Currency |
|---|---|---|---|
| Argentina | AR | State Code | ARS |
| Brazil | BR | State Code | BRL |
| Chile | CL | State Code | CLP |
| Colombia | CO | State Code | COP |
| Guatemala | GT | State Code | GTQ |
| Spain | ES | State Code | EUR |
| USA | US | State Code | USD |
| India | IN | State Code | INR |
| Mexico | MX | State Code | MXN |
Other Country Codes
| Country | ISO |
|---|---|
| Afghanistan | AF |
| Albania | AL |
| American Samoa | AS |
| Andorra | AD |
| Angola | AO |
| Antarctica | AQ |
| Antigua and Barbuda | AG |
| Argentina | AR |
| Armenia | AM |
| Aruba | AW |
| Australia | AU |
| Austria | AT |
| Azerbaijan | AZ |
| Bahrain | BH |
| Bangladesh | BD |
| Barbados | BB |
| Belgium | BE |
| Benin | BJ |
| Bermuda | BM |
| Bolivia | BO |
| Bosnia and Herzegovina | BA |
| Brazil | BR |
| Brunei Darussalam | BN |
| Bulgaria | BG |
| Burkina Faso | BF |
| Burundi | BI |
| Denmark | DK |
| Ecuador | EC |
| Egypt | EG |
| El Salvador | SV |
| Equatorial Guinea | GQ |
| Eritrea | ER |
| Estonia | EE |
| Ethiopia | ET |
| Falkland Islands (Malvinas) | FK |
| Faroe Islands | FO |
| Fiji | FJ |
| Finland | FI |
| France | FR |
| French Guiana | GF |
| French Southern Territories | TF |
| Gabon | GA |
| Gambia | GM |
| Georgia | GE |
| Germany | DE |
| Ghana | GH |
| Gibraltar | GI |
| Greece | GR |
| Greenland | GL |
| Grenada | GD |
| Guadeloupe | GP |
| Guam | GU |
| Guatemala | GT |
| Guinea | GN |
| Guinea-Bissau | GW |
| Guyana | GY |
| Haiti | HT |
| Heard Island and McDonald Islands | HM |
| Holy See (Vatican City State) | VA |
| Honduras | HN |
| Hong Kong | HK |
| Hungary | HU |
| Iceland | IS |
| India | IN |
| Indonesia | ID |
| Iran, Islamic Republic of | IR |
| Iraq | IQ |
| Ireland | IE |
| Israel | IL |
| Italy | IT |
| Jamaica | JM |
| Japan | JP |
| Jordan | JO |
| Kazakhstan | KZ |
| Kenya | KE |
| Kiribati | KI |
| Korea, Democratic People’s Republic of | KP |
| Korea, Republic of | KR |
| Kuwait | KW |
| Kyrgyzstan | KG |
| Lao People’s Democratic Republic | LA |
| Latvia | LV |
| Lebanon | LB |
| Lesotho | LS |
| Liberia | LR |
| Libyan Arab Jamahiriya | LY |
| Liechtenstein | LI |
| Lithuania | LT |
| Luxembourg | LU |
| Macao | MO |
| Macedonia, the Former Yugoslav Republic of | MK |
| Madagascar | MG |
| Malawi | MW |
| Malaysia | MY |
| Maldives | MV |
| Mali | ML |
| Malta | MT |
| Marshall Islands | MH |
| Martinique | MQ |
| Mauritania | MR |
| Mauritius | MU |
| Mayotte | YT |
| Mexico | MX |
| Micronesia, Federated States of | FM |
| Moldova, Republic of | MD |
| Monaco | MC |
| Mongolia | MN |
| Montserrat | MS |
| Morocco | MA |
| Mozambique | MZ |
| Myanmar | MM |
| Namibia | NA |
| Nauru | NR |
| Nepal | NP |
| Netherlands | NL |
| Netherlands Antilles | AN |
| New Caledonia | NC |
| New Zealand | NZ |
| Nicaragua | NI |
| Niger | NE |
| Nigeria | NG |
| Niue | NU |
| Norfolk Island | NF |
| Northern Mariana Islands | MP |
| Norway | NO |
| Oman | OM |
| Pakistan | PK |
| Palau | PW |
| Palestinian Territory, Occupied | PS |
| Panama | PA |
| Papua New Guinea | PG |
| Paraguay | PY |
| Peru | PE |
| Philippines | PH |
| Pitcairn | PN |
| Poland | PL |
| Portugal | PT |
| Puerto Rico | PR |
| Qatar | QA |
| Reunion | RE |
| Romania | RO |
| Russian Federation | RU |
| Rwanda | RW |
| Saint Helena | SH |
| Saint Kitts and Nevis | KN |
| Saint Lucia | LC |
| Saint Pierre and Miquelon | PM |
| Saint Vincent and the Grenadines | VC |
| Samoa | WS |
| San Marino | SM |
| Sao Tome and Principe | ST |
| Saudi Arabia | SA |
| Senegal | SN |
| Seychelles | SC |
| Sierra Leone | SL |
| Singapore | SG |
| Slovakia | SK |
| Slovenia | SI |
| Solomon Islands | SB |
| Somalia | SO |
| South Africa (ZA) | ZA |
| South Georgia and the South Sandwich Islands | GS |
| Spain | ES |
| Sri Lanka | LK |
| Sudan | SD |
| Suriname | SR |
| Svalbard and Jan Mayen | SJ |
| Swaziland | SZ |
| Sweden | SE |
| Switzerland | CH |
| Syrian Arab Republic | SY |
| Taiwan, Province of China | TW |
| Tajikistan | TJ |
| Tanzania, United Republic of | TZ |
| Thailand | TH |
| Timor-Leste | TL |
| Togo | TG |
| Tokelau | TK |
| Tonga | TO |
| Trinidad and Tobago | TT |
| Tunisia | TN |
| Turkey | TR |
| Turkmenistan | TM |
| Turks and Caicos Islands | TC |
| Tuvalu | TV |
| Uganda | UG |
| Ukraine | UA |
| United Arab Emirates | AE |
| United Kingdom | GB |
| United States | US |
| United States Minor Outlying Islands | UM |
| Uruguay | UY |
| Uzbekistan | UZ |
| Vanuatu | VU |
| Venezuela | VE |
| Viet Nam | VN |
| Virgin Islands, British | VG |
| Virgin Islands, U.S. | VI |
| Wallis and Futuna | WF |
| Western Sahara | EH |
| Yemen | YE |
| Zambia | ZM |
| Zimbabwe | ZW |
Did you find this resource useful?