Well, it's a tough and very broad question, man. Maybe one of these tools can help you:
openrefine.org/
cloud.google.com/dataprep/