Canadian Tools ยท Batch checks
Bulk SIN validator.
Paste a column of Social Insurance Numbers or open a CSV and get a pass or fail for every row, with the reason. The list is read on your device and never leaves it.
Short answer: a valid-looking SIN is nine digits that pass the Luhn check and start with 1 to 7 (regular) or 9 (temporary resident). This page applies that test to every row and exports a results CSV. Passing means the number is well formed, not that it was issued to anyone.
What this page checks
A SIN is nine digits. Canada.ca describes it as a 9-digit identifier, and says a SIN that starts with 9 is issued to a temporary resident and expires with their immigration documents. Everything else this tool tests comes from the checksum rather than from a Government of Canada rule: the last digit is a Luhn check digit, the same modulus-10 scheme used on payment cards.
For each row the tool removes spaces and hyphens, rejects anything that is not a digit, and then runs four tests in order. First, are there exactly nine digits? Second, are all nine the same digit? Repeated digits are rejected on their own, since 000 000 000 would otherwise pass the arithmetic. Third, does the Luhn sum come out as a multiple of 10? Fourth, does the first digit fall in a range used for SINs? Rows that clear all four pass. Rows that pass the sum but start with 0 or 8 are marked Review, because per the Wikipedia article on the SIN those leading digits are used for CRA-assigned tax numbers (0) and business numbers (8) rather than SINs.
Worked example: how the Luhn sum works
Take 130 692 544. Reading left to right, multiply every second digit by 2 and leave the others alone: 1, 6, 0, 12, 9, 4, 5, 8, 4. Any product over 9 has its digits added (12 becomes 1 + 2 = 3). The nine values are 1, 6, 0, 3, 9, 4, 5, 8, 4, and they add up to 40. A total divisible by 10 means the number is well formed.
Change the last digit to 5 and the total becomes 41, so the row fails. That is the point of a check digit: most single typing mistakes and most swapped neighbouring digits change the total. Luhn does not catch every error. Swapping 09 and 90 in adjacent positions, for example, can slip through, which is why a pass is a format result and nothing more.
Using the batch controls
Paste one SIN per line, or open a .csv or .txt file of up to 5 MB and 50,000 rows. If your file has several columns, enter the column number that holds the SINs and tick the header box so row one is skipped. Quoted cells, tab-separated and semicolon-separated files are read correctly, and blank lines are skipped without throwing off the row numbers in the results.
The results table lists the file row number, the SIN, a Pass, Review or Fail badge, and the reason in plain words. Use the filter to show only failures, then download either the full results or just the failed rows as a CSV. The download uses the same row numbers as your source file, so you can go back to the original and fix the cells. Repeated numbers are labelled as duplicates of an earlier row.
Masking and privacy
A SIN is sensitive personal information, so masking is on by default. With the box ticked, the table and the exported CSV show only the last three digits, with the rest replaced by dots. Untick it only if you need the full number in the export, and then store that file as you would any other file that holds SINs.
The checker runs inside a sandboxed frame on this page. The frame has no network permission, so it cannot send your list anywhere even if it tried, and it does not write your list to cookies or local storage. The file is read with the browser's FileReader and the results leave only as a download you start yourself. The advertising on this page sits outside the frame and cannot see what you paste.
Common mistakes
Do not treat a pass as proof that a SIN exists or belongs to a particular person. Roughly one in ten random nine-digit strings passes the Luhn sum. Do not strip leading zeros in a spreadsheet and then wonder why the length fails: Excel drops them from numbers, so format the column as text before you export. Do not paste a column that includes names or other fields on the same line unless you pick the SIN column. And do not use a list of real SINs where a test file will do; the sample numbers on this page exist for that purpose.
What this tool does not do
It does not contact Service Canada, the CRA or any registry, so it cannot say whether a SIN was issued, is active, has been cancelled or belongs to the person named beside it. Confirming a worker's SIN for payroll is done through your own records and the documents the employee provides, not through a checksum. It also does not store or log the numbers you check. For a single number with the arithmetic shown line by line, use the SIN validator.
Common mix-ups
-
Often assumedAny SIN that passes the check is permanent.
What the source saysCanada.ca says a SIN starting with 9 is issued to a temporary resident and expires with their immigration documents, while the SIN of a citizen or permanent resident is permanent and does not expire. [1]
-
Often assumedA passing checksum confirms a SIN for payroll.
What the source saysCanada.ca says a person can request a Confirmation of SIN letter and that employers can confirm an employee's SIN. A checksum cannot do either, which is why this tool calls a pass a format result. [1]
Checked against these sources on .
Frequently asked questions
How many SINs can I check at once?
Up to 50,000 rows from a file of up to 5 MB. Longer lists are cut off at the limit and the summary says so.
What does a pass mean for a SIN?
The number has nine digits, passes the Luhn check, is not a single repeated digit, and starts with 1 to 7 or 9. It does not mean the SIN was issued or belongs to anyone.
Why is 046 454 286 marked Review instead of Fail?
It passes the Luhn sum, but a leading 0 is used for CRA-assigned tax numbers rather than SINs. It is a widely published fictitious example, so it is flagged for a look rather than rejected.
What is a temporary SIN?
Canada.ca says a SIN starting with 9 is for temporary residents and expires with their immigration documents. The tool reports those rows as passing, with the note temporary (9-series), so you can check the expiry separately.
Is my list uploaded?
No. The list is read in your browser inside a frame with no network access. The only output is a CSV you download yourself.
Why do I need to mask the output?
A results file that contains full SINs is sensitive data. Masking keeps only the last three digits so you can still match rows by number while keeping the file lower risk.
My spreadsheet dropped the leading zero. What now?
Format the column as text before exporting, or re-enter the number with its zero. A SIN that reads as eight digits fails the length test, and the reason column says how many digits were found.
Can this tell me if a SIN is real?
No. Only the issuing agency can. This is the same format and checksum test as the single SIN validator, applied to a list.
Sources
Retrieved
Format check only — not a lookup
This page tests whether each value is structurally valid under the published rule. It does not contact any registry, bank, carrier or issuer, and a pass does not show that a number was issued, is active or belongs to anyone. Your list is processed in your browser and is not uploaded.