Merge multiple csv files removing duplicates

I have a series of backups of a csv file. I would like to merge them in a single spreadsheet, removing the duplicate entries.

Is there an easy way to do this in Calc?

If you join all csv data in one table in the spreadsheet, you can get it with the standard filter, Menu/Data/Filter/Standard and in more options mark No duplication, and a different place to copy the results.

Hi @ChrisVella,

We need to know a bit more about your particular situation in order to be able to help you. Could you please provide an example of the kinds of CSV files you want to be able to merge?