Subscribers List

Combine the master subscriber file, operative list, and statuspage export into a single deduplicated email list, with domains from the exclusion file removed.

The encrypted master file — open it in Excel, select all, copy, and paste below. Tab-separated; first row must be the header row.

Required headers (any order, exact spelling): account.u_ora_account_number, account.number, account.u_sfdc_account_id, Type, account.u_sta_tenant_id, account.u_sta_service_zone, account.u_account_friendly_name, user_name, name, email, active, account.u_dp_auth_owner, account.u_account_owner.

Must contain an "Email" column.

Statuspage subscriber export. Must contain an "Email" column.

Any layout — every non-blank cell becomes an exclusion token. Tokens are matched as a substring of each email's domain. So gmail drops foo@gmail.com AND foo@mail.gmail.co.uk; thales drops anything @thalesgroup.com, @thalescpl.io, etc. Cells with spaces, @, or pure numbers are skipped (full audit list printed in the server console).

Clear

How it works

  1. Emails are extracted from the email column of the master paste, and the Email column of files 2 and 3.
  2. All emails are lowercased, trimmed, and deduplicated.
  3. The exclusion file is scanned cell-by-cell for domain-shaped values (case-insensitive).
  4. Any email whose domain matches — or is a subdomain of — an exclusion is removed.
  5. The surviving unique emails are written to a single-column XLSX, sorted alphabetically.

Verbose progress is printed to the server console.