VGM Excel Template

Hapag-Lloyd’s VGM Excel Template is an easy solution to submit VGM information via e-mail. It is especially suitable when sending VGM information for recurring business cases.

Main benefits include:

• Easy one-time registration to use VGM Excel Template 
• No log-in required to submit VGM information via e-mail
• Validation checks prevent the most common errors
• Dispatch of acknowledgement e-mails
• Status monitoring available via webVGM
  

Work with the VGM Excel Template

As a security measure, we will only accept VGM Excel files from email addresses registered with our Online business.
Therefore, in order to use the VGM Excel template, you need to
- make sure you are registered with our Online Business (you are already logged in!)
- only use the registered email address when returning filled VGM Excel files

Detailed step-by-step instructions on how to use the VGM Excel Template can be found in the user guide which can be downloaded below.

Additional Note: In case you are having trouble with the "Untrusted File" warning from Excel in M365, please follow the instructions from these official Microsoft articles:
Unblock VBA Makros
Unblock Specific File