Remove Duplicates

Tags: Calc Extensions

last edited: 2023-01-24


Quickly remove duplicates in LibreOffice Calc.

remove duplicates 0f2a44d3 d288 4dab bd6c 402d822d4ad2


To use Remove Duplicates, do the following steps: 1. Install the extension; 2. Restart LibreOffice; 3. Open your spreadsheet; 4. Select a range with cells of duplicate content; 5. Click "Remove Duplicates" button in Toolbar or "Data" Menu; 6. Change options and click 'ok' button. Available on 3 languages: English, 简体中文, 繁體中文


Release List

Release: 0.9.2 – Add zh_TW

Compatibility: 3.3
Operating Systems: Linux, Windows, macOS
License: GPL

Release: 0.9.1 – First Release

Compatibility: 3.3
Operating Systems:
Release Notes: First Release


Post your review

You cannot post reviews until you have logged in. Login Here.


  • Ilya Dash Jan 19, 2021, 3:39 AM (2 years ago)

    Thank you!

  • Simon Nov 11, 2020, 9:17 AM (3 years ago)

    We've got 2 spreadsheets we've combined, but now there are some duplicate lines. Together there is almost 1 million rows. I can see two identical lines, but when I run Remove Duplicates, it doesn't seem to do anything. The duplicate I can see is still there. Is this too much for your extension to process?

  • raoul Jul 13, 2020, 7:10 PM (3 years ago)

    Works great on my Windows 10 computer, unfortunately does not on my Linux Mint one...
    I still don't really understand why it is not a native function in Calc though.

    • LobaLuna Sep 3, 2020, 6:10 PM (3 years ago)

      Because it is easily achievable in Calc using a simple filter. Check Google for this answer.

      • Philip Staiger Nov 22, 2020, 9:29 PM (3 years ago)

        Google did not show me how to do this with a Filter. Can you post a url?

  • Rajesh Jun 15, 2020, 8:53 AM (3 years ago)

    Much needed feature that is missing in LibreOffice. You can select which columns to use to check for a duplicate.

    • LobaLuna Sep 3, 2020, 6:11 PM (3 years ago)

      This function is easily achievable in Calc using a simple filter. Check Google for this answer.

  • Pedro Jun 3, 2020, 5:43 PM (3 years ago)


RSS feed for reviews on this page | RSS feed for all reviews