Use the delimited import to merge data
Use the delimited import to merge data
The new delimited import function allows a spreadsheet containing multiple entity types eg. columns for author, place, period, collection, to be split off incrementally into new records, or matched from existing records, and then used as pointer fields within the imported records. Some initial preparation of the spreadsheet may be required if it has been used as a sort of ‘enhanced wordprocessor’, in which notes are appended to fields or values implied by position relative to other values. Open Refine can be a useful tool for cleaning up incoming data. See also importing data.