Data Cleansing Tool: A Hidden Gem, Google Refine

By September 3, 2012Latest News

While making my way through my daily news sites and social feeds, I happened to stumble upon a phenomenal FREE product from Google, called Google Refine.

Google Refine is a tool that allows you to cleanse and transform data from various disperate sources. Often times when gathering multiple data sources to import data into salesforce, or another system, a lot of manual cleansing is required in excel. We’ve become experts at writing vlookups and other excel formulas to finally get the data in an appropriate format for import into a database.

Google Refine makes it that much easier, and on top of it all, allows you to scrape data from webpages, cleanse it, and load it into salesforce for analysis.

You can download the program free here.