Tags: Calc Extensions
last edited: 2023-01-24
Quickly remove duplicates in LibreOffice Calc.
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, 简体中文, 繁體中文
Ilya Dash Jan 19, 2021, 3:39 AM (2 years ago)
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)