the task at hand ought to be a simple one… the user has a data table of some sort (a Excel sheet).

and wants only unique data sets (no duplicates) in a certain column

theoretically Libre Calc can do that, but it failed so created a web based tool in PHP

so export Libre Office file -> to file.csv and purify it with this tool 🙂

have phun!

download:

check integrity:

sha512sum -c CSV_DELETE_DUPLICATES_v1.tar.gz.sha512sum.txt
CSV_DELETE_DUPLICATES_v1.tar.gz: OK
# unpack
tar fxvz CSV_DELETE_DUPLICATES_v1.tar.gz

requirements:

  • a PHP enabled webserver (no mysql required)

THIS PROGRAM IS NOT SAFE TO USE ON A PUBLIC ACCESSIBLE WEBSERVER

(the form could be tricked into displaying all sorts of files from webserver (e.g. wp-config.php containing MySQL database passwords etc.)

how to install:

  • (S)FTP or SSH into webserver / webspace
  • create a new subdirectory like “csv”
  • upload files to subdirectory “csv”
  • browse to https://domain.com/csv/

how to usage example:

admin