Purpose
Help shippers, forwarders, and traders prepare accurate EU ICS2 Entry Summary (ENS) data directly in Google Sheets. The add-on structures required fields, validates HS6 and descriptions, and exports carrier-neutral CSV for submission via your carrier or customs platform.
What it does
- Create ENS templates (Master/House) for sea, road, and rail.
- Validate HS6 format (6 digits), goods description quality, UN/LOCODE shape, and structured party addresses.
- Generate a validation log and a completeness score within the same file.
- Export Master/House CSV for upload to your chosen system.
How it works
- Open a spreadsheet → Extensions → Add-ons → ICS EU ENS HS6 Prep.
- Generate templates → fill data → run “Validate”.
- Download CSV and submit through your carrier/platform.
Data access & permissions
Operates only in the spreadsheet where it is installed. No developer servers are used.
https://www.googleapis.com/auth/spreadsheets.currentonly– read/write the current file to create templates, validations, logs, and exports.https://www.googleapis.com/auth/script.container.ui– display the sidebar/dialog inside Google Sheets.
No access to other Drive files, Gmail, or external accounts.
Privacy & support
Contact: support@ensworks.com