User Tools

Site Tools


open_refine_tips_and_tricks

Open Refine is an open source tool that allows you to clean up spreadsheets in preparation for conversion into EAD, or just general cleanup. There is an extensive user manual, but we will be collecting commands here that are most useful for our use cases.

Insert text at beginning or end of string

Select column you wish to insert text in then select Edit cells—>Transform…

Beginning of string: (“text to insert”)value+

End of string: value+ (“text to insert”)

open_refine_tips_and_tricks.txt · Last modified: 2025/03/12 17:02 by jeremy