Somacon.com: Articles on websites & etc.

§ Home > Index > Freeware

Count Duplicates in a List Online Tool

This online utility quickly aggregates the lines pasted in the text box and shows you count of occurrences of each value. Use this to quickly aggregate the values to find duplicate lines, or to count the number of repeats.

This free, online Javascript tool eliminates duplicates and lists the distinct values in any web browser. Every line that is repeated is counted and displayed. This form is secure because your list of values is processed by Javascript on your device only.

If you have an Excel spreadsheet and want to get distinct values from a column, just copy and paste the column of data from your Excel sheet into the textbox below. The results will contain:

1. Paste Your Input Text

2. Click the ‘Show Results’ Button

Options
Sort By: Format:
   Values:

3. View, Copy, or Download the Results

-- the results will appear here after you click the 'Show Results' button above --

Privacy/Security

Any data you enter is never sent or stored anywhere besides your device. All functions of the form are processed client-side by Javascript in your web browser.

Usage Instructions

Tip Icon The TAB output format option allows you to directly copy and paste the results into Excel, Google Sheets, LibreOffice Calc, or other spreadsheet software. Click Copy Results to Clipboard button, then press Ctrl + V or ⌘ + V in your spreadsheet. (This helps you avoid using the cumbersome Data > Text to Columns feature in Excel.)

You can hide or show the ‘Counts’ column. You can also see all lines in the results, or just the lines with duplicates. Lines with duplicates are those that occur two (2) or more times.

The CSV output format option allows you save the results as a .csv file using a text editor like Textpad. Once saved, double-clicking the file opens it automatically in Excel or LibreOffice Calc.

Both TAB and CSV output are in Excel-compatible format, with double-quote as the enclosure and escape character.

Use the Clear Input button to clear the text input. Use the Restore Input button to restore the last cleared text input. (For your security, the data is saved in a Javascript variable only, and will clear as soon as you leave the page.)

Change Log

February 11, 2025

Added a 'Download Results' button. Improved instructional headings and button arrangement.

Related Tools


Have you heard of the new, free Automated Feeds offered by Google Merchant Center? Learn more in Aten Software's latest blog post comparing them to traditional data feed files.
Created 2011-03-11, Last Modified 2025-02-11, © Shailesh N. Humbad
Disclaimer: This content is provided as-is. The information may be incorrect.