How to Remove Duplicates in LibreOffice

Want to learn how to remove duplicates in LibreOffice ? LibreOffice Calc is a powerful spreadsheet program that can be used to store, analyze, and manage datasets for any project. You can also manipulate the data and perform various operations and calculations. However, when working with large datasets, you often encounter a common problem: duplicate values.

Duplication can occur in a number of ways, as it can occur in a single column or in multiple columns or even in an entire row. Duplicate values ​​can make your calculations inaccurate, they can cost you a considerable amount of money, they can result in multiple emails being sent to a single person, etc.

Fortunately, with LibreOffice's advanced filter tool, you can easily remove these duplicate values ​​from your data.

Here you can learn about: What is a DOTX file? What is it used for and how to open one

In this post, we'll show you how to remove duplicates in LibreOffice using the Advanced Filter tool. LibreOffice Calc's Advanced Filter tool essentially hides data instead of deleting it. Let's see how it works!

1 method: Remove duplicates in LibreOffice from a single column

Here is the sample data that has duplicate values. We will remove the duplicate values ​​from your first column.

image

1. Step 1:: Open the LibreOffice Calc program. Press the super key and type libreoffice calc in the search box. From the search results, click LibreOffice Calc to open it
2. Step 2:: Upload the file or copy and paste the data you want to remove duplicates from
3. Step 3:: Then select the data range which in our case is the first column
4. Step 4:: Now, from the top menu bar, head to Data > More filters > Advanced filter

5. Step 5:: The following dialog box will appear Advanced filter. Click on the icon in front of Read filter criteria from(also highlighted by an arrow) and then, using the mouse, select the range of cells to which you want to apply the filter. You can also enter cell values ​​to select the desired range.

NOTE : In this example, to select the cell range A2 to A14 on Sheet 1 , you can type $Sheet1.$A$2:$A$14 in the Read filter criteria from field.

6. Step 6:: After selecting the desired range, Press Log in.

7. Step 7:: Now, in the dialog box Advanced Filter, click Options to expand the menu.

8. Step 8:: Then, in Options, check the checkbox No duplications. Then click on Accept to apply the filter.

9. Step 9:: Now all duplicates within the defined range (first column) will be removed.

Method 2: Remove Duplicates in LibreOffice multi-column

Now, we will remove duplicates from multiple columns or you can say from an entire row. Following is a sample dataset with duplicate values.

1. Step 1:: Open the LibreOffice Calc program. Press the super key and type libreoffice calc in the search box. From the search results, click LibreOffice Calc to open it.
2. Step 2:: Upload the file or copy and paste the data you want to remove duplicates from.
3. Step 3:: Then select the data range which in our case is the complete data.
4. Step 4:: Now, from the top menu bar, head to Data > More filters > Advanced filter.

5. Step 5:: The following dialog box will appear Advanced filter. Click on the icon in front of Read filter criteria from(also highlighted by an arrow) and then, using the mouse, select the range of cells to which you want to apply the filter.

NOTE : You can also enter cell values ​​to select the desired range. In this example, to select the cell range A2 to C15 on Sheet 1, you can type $Sheet1.$A$2:$C$15 in the Read Filter Criteria From field.

6. Step 6:: After selecting the desired range, Press Log in.

7. Step 7:: Click Options to expand the menu.

8. Step 8:: Now, in Options, check the checkbox No duplications. Then click on Accept to apply the filter.

9. Step 9:: All duplicates within the defined range will now be removed.

As discussed in the Introduction, the Advanced Filter in LibreOffice Calc doesn't remove duplicates, it only hides them. Therefore, you can also copy the filtered data to other cells and leave the original data as the default. To do this, check the " Copy results" box and, in the corresponding field, enter the location of the new cell where you want to copy the filtered data (data with duplicates removed).

The filtered data will be copied to other cells in the same sheet, as shown below:

Method 3: Remove Duplicates in LibreOffice Calc

You can remove duplicates in your spreadsheet data in LibreOffice Calc using advanced filters.

Remove duplicate data

1. Step 1:: Open your spreadsheet in Calc

1. Step 2:: Click Facts & figures in the menu bar

1. Step 3:: Go to More filters, then choose Advanced filter

1. Step 4:: The dialog box will open Advanced filter

1. Step 5:: Click on the reduction icon

1. Step 6:: Highlight your data

1. Step 7:: Click on the expand icon

1. Step 8:: Click on the + symbol next to the options

1. Step 9:: If your data has headers, make sure there is a check mark in the option. The range contains column labels

1. Step 10:: Put a check mark on the option No duplications

1. Step 11:: Click Accept
2. Step 12:: Your data has now been leaked - duplicates are not removed
3. Step 13:: Highlight your filtered data and Press Ctrl + C
4. Step 14:: Open a new sheet (or navigate to where you want your data without duplicates)

1. Step 15:: Press Ctrl + V to paste your filtered data
2. Step 16:: Your pasted data does not contain duplicates

Defilter your original data

To get rid of the filter on your original data (if you want), navigate back to it.

1. Step 1:: Click anywhere in your dataset.
2. Step 2:: Click Facts & figures(in the menu bar), choose More filters, then click Reset filters.

NOTE : (Alternatively, you can select your data, right-click on the row labels and choose Show Rows ).

Method 4: How to remove duplicates in OpenOffice Calc and Excel

The sophisticated filter allows you to extract data from a list according to simple or complex criteria, and also to remove duplicate rows. The procedure is almost identical in Excel and OpenOffice Calc:

Under OpenOffice Calc, a variety of criteria are required. If the operation is limited to deduplication, simply enter the name of one of the columns elsewhere in the spreadsheet.

1. Step 1:: Select the data list to deduplicate. This must contain a header row.
2. Step 2:: Go to the menu «Data->Filter->Advanced Filter» (in Excel), or «Data->Filter->Special Filter» (in OpenOffice Calc).
3. Step 3:: In the dialog box, check the box «Extraction without duplicates»Or«No duplicates«. In OpenOffice, select the range created in step 1. (the title and the cell just below it).
4. Step 4:: You can choose to replace the existing list with the filtered list (default option) or check the box “Copy to another location» to place the filtered list elsewhere on the sheet.

In Excel:

In OpenOffice:

Result:

Method 5: Remove duplicates in LibreOffice from a Calc table

There's another way to deduplicate a data list in Calc. When you want to create a chart of the internal links in a data list, you can remove duplicates in LibreOffice. There's a tool for this that seems very practical: Gephi.

So it was a matter of crawling the entire site with Screaming Frog, exporting the resulting list into a spreadsheet, and processing the data to import it into Gephi.

• The problem: Screaming Frog creates thousands of rows and duplicates need to be removed. After years of training in databases Excel, most people know how to do it in Excel. But they have never had to do it under Calc…

Here's how to remove duplicates in LibreOffice:

1. Step 1:: Place the cursor anywhere in the database
2. Step 2:: Then, you must go to Data / Filter / Standard Filter
3. Step 3: For the field name, choose none
4. Step 4: Click on Options
5. Step 5: Check no duplicates
6. Step 6: Here you should also verify that Range contains labels because the table has a row of titles.

NOTE : You can then export the result by selecting all the data and copying it to another tab. Otherwise, duplicates will only be masked by the filter.

Method 6: Remove duplicates in LibreOffice Calc for columns

To extract data without duplicates or simply hide duplicates, this is how to do it.

Hide duplicates

1. Step 1:: In your workbook, select the appropriate column by clicking on the letter (e.g. B); this can also be done with multiple columns, e.g. "Last name" and "First name".
2. Step 2:: On the menu “Data” → “More filters” choose “Standard filter…”
3. Step 3:: In the window that opens, select “none in “Field Name”".
4. Step 4:: Then display the submenu «Options» and mark «No duplicates«.
5. Step 5:: Validate by clicking on «Accept«.

Optionally, you can check the " Match case " box if you wish. Duplicates will simply be hidden.

Remove duplicates in LibreOffice

If you also want to extract the data without duplicates, you should also check the box " Copy the result to: " and indicate the first cell (this can be in a new workbook sheet, for example).

You might also want to read about: How to Use the Quartile Function in Excel – Complete Guide

Conclusion

As you can see, it's necessary to remove duplicate entries to clean up your data. By following the procedure above, you can easily get rid of duplicates in a single column or multiple columns in LibreOffice . We hope this has helped you understand how to remove duplicates in LibreOffice.