Ask Your Question

Merge multiple csv files removing duplicates [closed]

asked 2012-12-17 11:08:55 +0200

Chris Vella gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 01:10:39.727822

2 Answers

Sort by » oldest newest most voted

answered 2013-03-03 02:10:10 +0200

m.a.riosv gravatar image

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.

image description

edit flag offensive delete link more

answered 2013-03-03 00:02:05 +0200

qubit gravatar image

Hi @Chris Vella,

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?

edit flag offensive delete link more

Question Tools


Asked: 2012-12-17 11:08:55 +0200

Seen: 2,630 times

Last updated: Mar 03 '13