Ha! There are no general purpose tools--lots are a) overkill or b) not robust enough given your task but two general ones that have served me well (and of course lot of Python scripting for my domain-specific issues):
Refine (formally from ITA/Google, now open source)
IBM Watson Analytics - Don't knock it until you try it. Forget the 'analytics' bit but the ETL bit is pretty decent for getting through the basics