Documentation For Users

Documentation hub for users

Where to start?

• Installation Instructions ([UpgradingTo2p0 upgrading instructions])
• User Guide

Love it so much?

• How To Participate with the development or help spread the meme about OpenRefine.
• Get Development Version so you can play with all the latest and greatest features, but if you are not afraid of bugs.

Feature Areas

Essential: These are the features you'd use 80% of the time when you use Refine. They help you clean up your data, extend it, and export it out for other tools to consume.

• Importers
• Faceting
• Editing:
• Cell Editing, editing cells by Clustering
• Column Editing, creating columns by Extending Data
• Row Editing
• Understanding Expressions
• Understanding Regular Expressions
• Exporters
• History (undo/redo)

Reconciliation: You can use the "reconciliation" support in Refine to link text names in your data to database identifiers (also known as database keys, IDs). By connecting your data with other databases, you get more value out of your data.

• Reconciliation
• Reconcilable Data Sources
• Extending Data
• Extending Data From Freebase

Uploading to Freebase: If you reconcile against Freebase, you can then align your data with Freebase's schemas using Schema Alignment and load your data into Freebase. For more information on Freebase data loading, see the Refinery project.

• Schema Alignment

Extensions: Add even more features to Refine by installing extensions.

• Installing Extensions
• Extensions that we know about

Recipes

For complicated tasks that are commonly done, just follow recipes that other folks have discovered and written up. A recipe is just a sequence of steps, and tips and tricks.

There are Recipes (like removing duplicate row values, etc.)

and there are full recipes:

• Geocoding - translating street addresses to lat/lng coordinates
• [FetchingURLsFromWebServices Fetching URLs From Web Services] - grabbing from the Web more data related to the data you already have
• [StrippingHTML Web Scraping & Extracting items from HTML pages]
• Recipe Apache Logs

Reference

Expressions

• Variables
• OpenRefine Expression Language (GREL)
• [GRELControls Controls]
• [GRELFunctions Functions]
• [GRELBooleanFunctions Boolean functions]
• [GRELStringFunctions String functions]
• [GRELArrayFunctions Array functions]
• [GRELMathFunctions Math functions]
• [GRELDateFunctions Date functions]
• [GRELOtherFunctions Other functions]
• Jython

External Sites

While there's a lot of information in this wiki, there's plenty more online too. Here are some notable sites,

• Tony Hirst's blog
• Martin Magdinier's blog
• Yours? Let us know!

And of course [https://www.google.com/search?q=%22google+refine%22 searching online].