Remove Duplicate Rows in LibreOffice Calc

Libreoffice Icon

How to Remove Duplicate Rows in LibreOffice Calc

For many PC users, LibreOffice needs no introduction. This open source office suite is the de facto standard for Linux and also a good alternative for Windows users who can do basic editing without the complex formatting and feature set of Microsoft Office. Free is another obvious plus of LibreOffice.

LibreOffice started as a fork of OpenOffice in 2010. Both products are open source and are a powerful office suite. LibreOffice is developed by a huge community curated by The Document Foundation, a non-profit foundation, and is funded by donations.

The LibreOffice suite includes word and spreadsheet processor, a program for preparing and viewing presentations, vector graphics editor, database management system and a formula editor. The main file format used in the application is OpenDocument, ODF, and also allows you to save documents in other popular open and closed formats.

LibreOffice supports a variety of operating systems, including Windows and a whole family of Unix-like operating systems, including Linux and FreeBSD.

Duplicate Rows in LibreOffice Calc

The LibreOffice Calc spreadsheet processor allows you to remove duplicate rows in documents. However, this can't be done in an obvious way. Unlike Microsoft Excel, which has a dedicated Remove Duplicates feature, LibreOffice has nothing like that.

In this program, the removal of duplicate lines is implemented through the line filter, and therefore it can be difficult for beginners to use it. It is unlikely that anyone would think of using a filter for such a task.

This post will show you how to remove duplicate rows in LibreOffice Calc.

For example, we will have the following source table.


To remove duplicate lines in LibreOffice Calc

  1. Select a range of cells or entire columns containing duplicates.
  2. Select the menu item Data > More Filters > Standard Filter.
  3. Set the filter rule: "ColumnA = Not empty".
  4. Expand Options, and check (enable) the box "No duplications".
  5. Click OK to execute the filter.
  6. Duplicate lines are now removed.

Using this method, you can quickly remove duplicate lines in LibreOffice Calc. Of course, it would be more convenient if there was a separate button or menu for this in the program, but at the time of this writing it is still not available.

Thanks to Winreview.

Support us

Winaero greatly relies on your support. You can help the site keep bringing you interesting and useful content and software by using these options:

If you like this article, please share it using the buttons below. It won't take a lot from you, but it will help us grow. Thanks for your support!

Author: Sergey Tkachenko

Sergey Tkachenko is a software developer who started Winaero back in 2011. On this blog, Sergey is writing about everything connected to Microsoft, Windows and popular software. Follow him on Telegram, Twitter, and YouTube.

7 thoughts on “Remove Duplicate Rows in LibreOffice Calc”

  1. Dear Sergey, After applying this trick the file numbers (at the left) for the files that were deleted just dissapeared. How can I make those numbers to be consecutive again? Many thanks. Regards. Marcelo

      1. Hell yeah. The legend stays in our hearth + we still got mister Rex and Phil ! Anyway, thanks a lot man, all the best to you !

Leave a Reply

Your email address will not be published.

Exit mobile version
Using Telegram? Subscribe to the blog channel!
Hello. Add your message here.