Definite cosign on Open Refine. It's intuitive and spreadsheet-like enough that a lot of people can understand it. You can do anything from standardizing state names you get from a patron form to normalizing metadata keywords for a database, so I think it'd be useful even for non-techies. Ruth Kitchin Tillman Metadata Librarian, Cadence Group NASA Goddard Space Flight Center Library, Code 272 Greenbelt, MD 20771 Goddard Library Repository: http://gsfcir.gsfc.nasa.gov/ 301.286.6246 -----Original Message----- From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of Terry Brady Sent: Monday, July 07, 2014 1:35 PM To: [log in to unmask] Subject: Re: [CODE4LIB] 'automation' tools I learned about Open Refine <http://openrefine.org/> at the Code4Lib conference, and it looks like it would be a great tool for normalizing data. I worked on a few projects in the past in which this would have been very helpful.