Refine
Google Refine is a free desktop application designed to clean up messy data or transform it from one format to another.
The program performs "faceted browsing," which functions like pivot tables in spreadsheet programs. Refine also uses clustering to group similar but irregular cell data like names and dates, which can then be corrected.
For advanced users, Refine is capable of reformatting data using Web services (geocoding for example) and using "recipes" for complicated, but common, tasks.
Refine supports the following formats, according to its documentation:
- TSV, CSV, or values separated by a custom separator you specify
- Excel (.xls, xlsx)
- XML, RDF as XML
- JSON
- Google Spreadsheets
- RDF N3 triples
Latest Reviews
-
Outwit Hub Pro can scrape almost any database, but learning curve steepens with complex datasets
-
Pdftotext excels at extracting data from conventional tables, stumbles with more complex tasks
-
For Monarch, high cost translates to unmatched spreadsheet conversion
-
DeskUNPDF stumbles with complex formatting
-
Helium Scraper a powerful extraction tool that rewards patience
Latest Tutorials
See more»
