Skip to content

Free Merit List Generator

Paste names and marks, get a clean sorted rank list with proper tie-handling. Runs in your browser. Free with a teacher account, no upload, nothing stored.

Checking your sign-in…

How it works

Paste two columns (name and marks) into the box, or build the list row by row with the editable table. The tool parses comma-separated, tab-separated, and space-separated formats automatically, so a copy-paste straight out of Excel or Google Sheets usually works without cleaning. Lines that cannot be parsed (header rows, blank lines, notes) are skipped quietly.

The default ranking method is dense rank, which gives the most compact ordering (tied students share a rank and the next student takes the immediately following number). Toggle to standard rank when you want competition-style ranking where tied positions create a gap (1, 1, 1, 4 instead of 1, 1, 1, 2). Both methods sort by marks in descending order by default; a separate toggle flips the order to ascending if you need lowest-first.

Once you are happy with the parsed list, print directly from the browser or download a CSV for further work in a spreadsheet. The output is a plain ranked list, no institutional letterhead, no signature, no seal, just rank, name, and marks. It is a working document for teachers, not a credential.

  • No student accounts.
  • No ads.
  • Data-processing agreement on request.
For schools

How to generate a merit list from class marks

  1. Paste your class data
  2. Choose tie-handling
  3. Pick sort order
  4. Review and edit the parsed rows
  5. Print or export

Questions teachers ask

What is the difference between dense rank and standard rank?

Both methods handle ties (students with the same marks) but assign the next rank differently. With standard rank (also called "competition" rank), tied students share a position and the next student skips ahead by the size of the tie group. For example, three students tied at first place all get rank 1, and the next student is rank 4, the sequence is 1, 1, 1, 4. With dense rank, tied students share a position but the next student takes the immediately following rank with no gap. The same three students tied at first place all get rank 1, and the next student is rank 2, the sequence is 1, 1, 1, 2. Use standard rank for prize ceremonies and competitive contexts where the gap signals scarcity; use dense rank when you want a compact ordering with no skipped numbers.

Is the data I paste sent to a server?

No. This tool runs entirely in your web browser using client-side JavaScript. Nothing is uploaded, transmitted, or stored on any server. When you close the tab, the data is gone. There is no database, no analytics tracking of the marks you enter, and no log of names. This makes the tool safe to use with real student names and scores during exam season without raising data-protection concerns. If you want to keep the list, use the Print or CSV export buttons to save a local copy. For institution-wide ranking that needs to be saved, shared with parents, or integrated with your gradebook, you will need a proper student information system, not a single-page tool.

What input formats does the tool accept?

You can paste rows in three common formats and the tool will detect them automatically. Comma-separated: "Aisha, 87" puts the name first and the mark second. Tab-separated: works the same way and is what you get if you copy a two-column selection from Microsoft Excel, Google Sheets, or LibreOffice Calc. One-per-line spaces: "Aisha 87" where the last whitespace-separated token is treated as the mark. Names can contain spaces, hyphens, apostrophes, and non-Latin characters. Marks can include decimals (87.5) for assessments where partial credit is given. Lines that cannot be parsed are skipped silently so you can paste from a spreadsheet that has header rows or footer notes without cleaning the data first.

Is this an official merit list or certificate?

No. This tool deliberately produces only a plain ranked list (rank, name, marks). It does not include institutional letterhead, school logo, principal signature, official seal, or "this certifies that" language. Outputs from this tool are working documents for teachers, not credentials. If you need an official merit list signed and stamped by the institution for prize-giving or transcript purposes, that should be generated through your school management system with the appropriate authorisation workflow and audit trail. This restriction is intentional and protects both the integrity of real credentials and the institutions whose names might otherwise be used in fraudulent documents.

How many students can I rank at once?

The tool has no hard limit; it has been tested with class lists of up to 10,000 entries and sorts them in well under a second on a typical laptop. In practice the largest realistic single use case (a public exam result list for a board with tens of thousands of students) starts to become awkward to review on screen and to print, but the underlying sort and rank computation will still complete instantly. For lists larger than a few thousand entries, the CSV export is the most practical output; you can then import the file into a spreadsheet for further analysis or filtering by section, class, or division.

Can I sort the list in ascending order (lowest first)?

Yes. The default sort order is descending (highest marks first), which is the normal way merit lists are presented for academic ranking. A toggle in the tool flips the order to ascending (lowest marks first), which is useful for some specific contexts, identifying students who need additional support, sorting by error counts on a diagnostic test, or generating a list ordered by time taken for a timed practical. The ranking method (dense or standard) is computed correctly in either direction; rank 1 always means the best performance under the selected ordering, not the lowest absolute number.

Can I edit the list inside the tool before printing?

Yes. After you paste the initial data, the tool shows the parsed rows in an editable table where you can correct typos, change marks, add rows with the "Add row" button, or delete rows you do not want included. The merit list output updates as you edit. This is useful for handling edge cases that ranking should not include, students who were absent, those who withdrew from the assessment, or honour-board entries that should be presented separately from the main list. Once you are happy with the result, the Print button opens a clean print preview and the CSV export downloads the final ranked data as a spreadsheet-compatible file.

How do institutions manage class ranking at scale?

When a single teacher ranks a class of 40 for one test, this tool is enough. When an institution publishes ranks for thousands of students across dozens of subjects every term, ranking has to be integrated with the gradebook so that scores flow in automatically, weighting rules (term tests, finals, internal assessment) are applied consistently, and rank lists for every section, class, and stream can be regenerated when even one mark is corrected. A platform like OpenEduCat handles ranking inside its gradebook module, supports configurable tie-breakers, publishes parent-facing rank cards through the parent portal, and keeps a versioned audit trail when a rank is adjusted. None of that is feasible from a paste-into-a-textarea tool, which is why this one is positioned as a quick utility, not a system of record.

Related tools

Rank thousands of students, not just one class.

Book a free demo
Was this useful?

Counted per page. Report a problem for bugs.