convert an address list from Excel to a common format

you Need 3 programs or 1 but with a choice of options and selection of files to process:
1) Converts the address to a given type
2) removes duplicate addresses on the specified criteria
3) Copies of file 2 to file 1 selectable columns (and their headers) with identical