ICCID spreadsheet column check

Client

ICCID spreadsheet column check is for analysts who live in Excel and Sheets. Copy the ICCID column (one cell per line when pasted), run Luhn on each row, and fix failures before VLOOKUP or pivot steps—no upload to Toolcore.

Excel hygiene before paste

Set ICCID column to Text format. Remove thousand separators. Copy values—not formulas—then paste below for Luhn pass/fail per row.

Privacy: digits are evaluated only inside your browser. There is no carrier, GSMA, or SM-DP+ query—format math only. Treat SIM identifiers like any sensitive operational paste.
?

The ITU‑T E.118 layout follows ISO/IEC 7812 for card identifiers: a Major Industry Identifier (telecom ICCIDs usually start with 89), an issuer/country/account block, then a trailing Luhn mod‑10 check digit using the same doubling rule as many payment PAN validators. Printed cards commonly show 18–22 digits; issuers pin one length profile per range.

Result

Passes Luhn mod 10 on the full 19-digit string.

  • MII (first 2): 89
  • Issuer / account core (between MII and check): 3530012345678901
  • Check digit (last): 1

Common use cases

  • Validate ICCID column before mail-merge to activation letters.
  • Clean supplier XLSX exports where scientific notation mangled long digits.
  • Share a browser checklist with ops teams who do not run scripts.

Common mistakes to avoid

  • Pasting scientific notation from Excel

    Format column as text first—truncated digits fail Luhn.

  • Including header row in paste

    Skip column titles—digits only per line.

  • Merging ICCID and IMSI into one column

    Split fields before validation.

FAQ

How to paste from Excel?

Select ICCID cells, copy, paste here—one serial per line.

Does Google Sheets work the same?

Yes—copy column values, paste multi-line.

Will formulas upload to Toolcore?

No—only what you paste is evaluated locally.

Common search terms

Phrases people search for that match this tool. See the full long-tail keyword index.

  • iccid check
  • iccid checker online
  • iccid validator luhn online
  • sim card iccid checksum check browser
  • e118 iccid validate digits locally
  • telecom iccid mii 89 checker
  • integrate circuit card id luhn mod 10
  • iccid luhn check
  • validate iccid online
  • esim iccid check
  • iccid check digit
  • iccid vs imei
  • iccid format e118
  • iccid check online
  • bulk iccid check
  • sim iccid check
  • verify iccid number
  • iccid csv validator
  • free iccid checker
  • travel esim iccid check
  • iccid barcode scan check
  • iccid privacy safe check
  • iccid mod 10 checker
  • prepaid sim iccid check
  • iccid before carrier activation
  • iccid shipment validation
  • iccid enterprise inventory

More tools

Related utilities you can open in another tab—mostly client-side.