• Search tip: for exact phrase use "quotation marks" or for all words use +
  • More search tips here

                  Guide to cataloguing

                  Creating or adapting an archival catalogue for your collections

                  This guide is for groups who collect and care for archival collections, and would like to create a catalogue that will be suitable for sharing through Your Scottish Archives.

                  Starting a catalogue can be a daunting process. But, it is possible to take this step by step, to gradually build up catalogues for your whole collection. You do not need to create a complete catalogue all at once, and you do not need to have described every item in your collection before you can share your work with the public. It may be good to know that:

                  • Most professional archives do not have catalogues that individually describe each item, for all the material they hold; instead, they use a hierarchy method which allows material to be described in sections, going from a broad summary to individual details – this approach is explained below
                  • Catalogues are always a work in progress: it is possible to add in more information over time or change information
                  • Even a simple or ‘incomplete’ catalogue offers researchers a starting point to be able to find and use what is in your collection

                  What is a catalogue?

                  An archival catalogue is a descriptive list of the material in a collection. For archival collections, the catalogue reflects the structure of a collection, indicating groups of linked items created or collected within the same context and for the same purpose within a each collection. This may be a series of minute books, a file of research papers, or box of newspaper clipping from a specific span of time (e.g. 1990 – 1991).

                  Why catalogue?

                  A catalogue helps to:

                  • Keep important information about your archival material safe and easy to find
                  • Create an overview of which archival material a repository holds, making it easier to care for the collection over time
                  • Preserve the integrity and evidence within each of a repository’s collections
                  • Make it easier to find, share use archival collections in a way which protects the collections and can be repeated over time

                  Cataloguing approaches across heritage organisations such as archives, museums, rare book collections and libraries are different.

                  This guide offers tips on how to create a catalogue that you will be able to share through Your Scottish Archives. This means that if you follow these suggestion, you will create a catalogue that you are able to upload to Archives Hub, partners with the Your Scottish Archives portal, and share with the public.

                  As Your Scottish Archives is focused on archival collections, the suggestions in this guide are led by the approach of the archive profession to cataloguing.

                  If you already have a catalogue which follows a different approach, such as museum cataloguing or standards for archival film collections, have a look at the segment on adapting catalogues below.

                  This guide will:

                  • Help answer the question: what is an archive collection, and how many collections do you hold?
                  • Shed light on the idea of ‘levels’ in an archival catalogue
                  • Provide information on catalogue “descriptive fields” – the categories of information you need to include
                  • Outline a step by step process for creating a catalogue for a collection which has no existing catalogue
                  • Provide tips on how you can use or adapt catalogues you already have
                  • Provide guidance on using the Archives Hub spreadsheet system

                  Step by step guide to starting a catalogue from scratch

                  This is an overview of how to create a catalogue for an archival collection which does not yet have a catalogue.

                  If you already have a catalogue, you can find out how to adapt this in the ‘Adapt a catalogue’ tab.

                  You may find it helpful to review the informational tabs on Archive Cataloguing and Descriptive fields, which provide details on:

                  • archival versus museum approaches to creating a catalogue
                  • the terminology used in this overview, such as ‘collection’, ‘level’, and ‘arrangement’
                  • in depth descriptions of the types of information you will need to include in your catalogue

                  Note that there are professional archival services which can provide support for people, groups or organisations wishing to undertake work with their own archival collections:

                  National Register of Archives of Scotland

                  Business Archives Council of Scotland

                  In addition, many local authority archivists or regional university archivists are able to provide advice or support. You may find an appropriate archive service listed in the index of services in Scotland.

                  1. Select a collection

                  Identify the collection you want to catalogue

                  Each individual ‘collection’ will require its own catalogue, and unique reference number.

                  • If you are unsure which collections you hold or how to identify a ‘collection’, take a look at the Collections tab on this page, which outlines the archival understanding of a collection.

                  2. Gather information

                  Find any existing information on the collection

                  This may include information about:

                  • when and how the collection was donated or purchased;
                  • information on the location of items in this collection;
                  • lists or indexes relating to the collection.

                  Using this information can help you to understand:

                  • what material is included in this collection? Does the collection include different formats, especially those that may need special care, such as film?
                  • was the collection in a particular order or arrangement when it was donated?
                  • what actions have been taken so far since in your care – has material been rearranged, moved to new boxes, or listed previously?

                  If the archival collection you are starting to catalogue is from a business, family estate or historic organisation, check with the National Register of Archives for Scotland to see if the collection has ever been surveyed.

                  Email nras@nrscotland.gov.uk or look at the NRAS surveys online. Be aware that not all surveys are available online.

                  3. Survey

                  Conduct a survey of the collection

                  Having identified which materials belong to this collection (steps 1 and 2), go through the boxes of materials and, if relevant, any computer or digital files:

                  • Record how many boxes of material / other groups of materials there are
                  • List what is in each box and/or stored digitally
                  • Record the type and subject of the material, approximately how much there is, and any problems you find e.g.:

                  Example (fictional) collection: Cupar Baking Society Papers

                  BOX 1: 4 lever-arch files of banking records for Cupar Baking Society; envelope of colour photos of cheque donation;

                  BOX 2: Folder of handwritten recipes (1972 commemorative recipe book research); sales ledger (note: spine detached); minute book 3

                  BOX 3: Album of black and white photographs; minute books 1-2; loose correspondence

                  BOX 4: Commemorative china for 50th anniversary of society (6 plates); file of financial papers; letter books 2- 5; poster for 1972 anniversary cake sale

                  External hard-drive: digitised film of 1972 cake sale

                  4. Decide on arrangement

                  With a pen and paper to hand, and using any existing documentation you have found and the survey list you have made, decide on a suitable arrangement for this collection, considering:

                  • Whether the documentation you found suggested a pre-existing order?
                  • Whether your survey indicated an original order?
                  • Whether your survey has indicated key series of records?
                  • NOTE: if an original order is not clear, sections should, in the first place, be based on why records were made and used rather than material format.
                    • In the fictional example of the Cupar Baking Society, for example, one series may be the ’50th Anniversary Celebrations’ which would include the handwritten recipes, china, poster and film. All these items were created as part of the ‘Anniversary Celebrations’, so form a single section even thought they are in many different formats

                  5. Sketch out arrangement

                  • draft a plan of the main sections or series you have identified in your collection, and which materials you have identified through your survey will appear in each section

                  6. Choose a collection reference number

                  • you should assign a unique reference number to your collection. For tips on reference numbering, see the tab on Descriptive fields.

                  5. Start your catalogue

                  • You may find it helpful at this stage to look at the tabs on Descriptive Fields and on Spreadsheet tips. These provide detailed information on which categories of information you will need to record and how to use the Archives Hub spreadsheet template.
                  • If desired, download the Archives Hub Spreadsheet Template; using this template will allow you to add your catalogue to Archives Hub and share it on Your Scottish Archives
                  • Start with with the broadest description of your archival collection; this is a ‘collections’ level description, and provides a summary and overview of the key information relating to this collection.
                  • Add descriptions for each of the main sections of the archive arrangement you identified in the previous step
                  • Finally, start to add more detailed lower level descriptions such as sub-series, files or items

                  What is a ‘collection’?

                  • An archival ‘collection‘ (sometimes known as a ‘fonds‘) is a group of archival items that are connected and form a body of linked items within an archive.
                  • A ‘collection’ or ‘fonds’ is formed when all the archival material originated from the same organisation – ‘The Kentucky Bowling Club Papers’ – or from the same person – ‘Personal papers of Mavis Gray of Springfield’; in some cases a “collection” may also be created out of items linked by theme, such as ‘Materials relating to farming in Springfield’, or by format, ‘The Springfield photo collection’.
                  • Some archive holders, such as a Heritage Society, hold several different archive fonds / collections. This could be, for example, (a) the papers of John Smith local butcher, (b) papers of the village golf club, (c) local political pamphlets from the 1960s – 1990s. Each of these collections should have its own catalogue.
                  • Other heritage societies may hold only one fonds / collection; for example the Village Flower Society may hold just papers relating to running that society, the ‘Village Flower Society Records’.

                  How do I know which/how many collections we have?

                  • If you have material that has all come from the same place – a person, organisation, society or similar, as described above, archivists will try to keep such materials together as a collection. So, if you have a box of Mr Forbe’s papers, photos and pamphlets, that may become the ‘Mr Forbes Collection’.
                  • BUT – community archives often work a little differently to traditional archives. So, how your group currently uses and stores your materials can offer clues to what your ‘collections’ may be: do you have a box of ‘Bruce family history stuff’, a series of files on ‘research on local houses’, a crate of ‘Artefacts from local Schools’? Each of these could be one of your collections. How a collecting organisation, such as a heritage society, has gathered and used archival materials over time becomes part of the history of those items, and is also important.
                  • Note that an item can only be in one collection and should stay in that collection over the longer term; however, a different version of that item may appear in a different collection. So, the ‘Order of Service for Harvest Festival 1949’ may appear in Reverend Brigg’s Personal Papers, as well as a different copy of the same Order of Service being within the Parish Records for the Kirk of St Stephen.
                  • Items from the same collection do not need to be physically next to one another: the ‘Junior School Collection’ may include a box of items in the cupboard, 3 building plans in the loft, and a roll of honour displayed in the hallway. The thing that connects them is their provenance – which you will identify with a reference code and through a catalogue.

                  Archival approaches to making a collection catalogue

                  The approach which archivists and museum curators (and librarians) take to making a catalogue of their collections is different. This has developed in part because they have historically looked after different kinds of materials collected in different ways.

                  Museums generally have a flat approach to cataloguing, where each historic item/object is listed individually:

                  e.g. Village Museum Collection

                  • item 1: letter
                  • item 2: book
                  • item 3: bowl
                  • item 4: dress

                  Archivists take a hierarchical approach, viewing each collection as a whole within which there are subsections, and then items.

                  This is based on two important ideas:

                  • Provenance: part of what makes an archival record unique is the history of that collection. This history includes the context of where, when and how it was made; which person(s) or organisation created it; and how it has been used and kept since that time. These aspects form the provenance of the collection. In general, archive services will keep material with the same provenance together as a fonds / collection; material which has a different provenance should not be added to this fonds / collection; however, material which has become accidentally separated from the collection may be re-integrated.
                  • Original order: this is the idea that the way the items within a collection were ordered or arranged by the person(s) or organisation creating and using them in the first place is part of the evidence and value that the collection provides. It is important to keep information about this order or arrangement in place when a collection is cared for by an archives service.

                  Archive services use a structured cataloguing approach – a hierarchy or tree – as it helps to capture and remember the way a fonds/collection was used by the person or organisation creating the collection in the first place; the way different records were made and used along side each other originally is part of what makes the records in an archive unique.

                  e.g. Collection: “The Bowling Club Collection”

                  Series 1: Minute Books

                  Series 1: item 1: Minute Book 1

                  Series 1: item 2: Minute Book 2

                  Series 2: Club correspondence

                  File 1: Administrative correspondence 1930 – 1933

                  Series 2: file 1: item 1: Letter on opening times

                  Series 2: file 1: item 2: Letter on dispute over grass cutting payments

                  File 2: Summer Prize Competition

                  Series 2: file 2: item 1: Letter of application to participate in competition

                  Series 2: file 2: letter 1: Letter of thanks for receipt of prize trophy

                  What is a ‘level’ of description?

                  For archival catalogues, the ‘level’ of description refers to whether the description relates to a whole collection, a section within that collection, or a smaller group of items or item within that collection:

                  • the whole of the collection or materials being described – sometimes known as a “top level” description. This gives a summary or overview of a single collection which may be comprised of many smaller sections and many items. E.g. The Bowling Club Papers
                  • a smaller section within the collection – sometimes known as a “lower level” description. This could be a series of items, a group of items, or a file of items: e.g. Series 1: Bowling Club Minute Books
                  • an item within a smaller section within a whole collection – another “lower level” description. E.g. Series 1, item 1: Minute Book 1

                  NOTE: while the names of level values may be descriptive, this is not always the case e.g. a ‘file’ level description does have to relate to items physically or digitally stored in a file, it may simply represent a smaller group of items than a collection, series, or sub-series

                  Detailed advice on using levels and the names given to each level is provided in the Descriptive fields tab

                  Do I need to use a hierarchy for my catalogue?

                  • All catalogues added to Your Scottish Archives must have a top level ‘collection’ record, but following this you do not need to use sections and can simply list each item.
                  • Large catalogues which have a flat structure cannot be processed by the Archives Hub system, as this system is designed for catalogues with an archival approach. Some tips for adapting collections catalogued in this way are provided in the Adapt a Catalogue tab.
                  • Please do get in touch if this is the case and we can discuss which approach may suit your collection.

                  Information you must include

                  Our partners, Archives Hub, requires that all catalogues include certain key bits of information about each collection added.

                  Why?

                  This ensures that:

                  • Catalogues follow the professional standard for archives, ISAD(G)
                  • Each description can be identified easily in an online and international context
                  • Researchers get an accurate impression of the archival material
                  • Researchers are made aware when they may need particular skills to use the archives, e.g. ability to read Gaelic.

                  Which information must be included?

                  Archives Hub requires that ten catalogue fields are included for top level descriptions. These are: reference number; level; title; display dates; start date; end date; language; extent; scope and content; access conditions.

                  For lower level descriptions, your catalogue must include (at minimum): reference number; level; title.

                  An outline of the difference between top level and lower level descriptions is available under the previous tab on ‘Archive cataloguing’.

                  In addition to these fields, there are many different kinds of information you can include if you wish; however, there is no requirement to do so.

                  Must include at top level

                  Reference number

                  Required for? top level and lower level descriptions

                  What is it? A unique identity code that can include numbers and letters

                  How does it work? Following a traditional archival hierarchy, Archive Services create a main identity code for a whole collection.

                  • For example, the “Mr Forbes Collection” may be given the main collection reference “FOR” or “ARCH10” or “10”.

                  Reference numbers for the rest of the same “collection” are built using this main reference as a base, adding to this using slashes to build a connected hierarchy of reference codes for each part of the collection.

                  • For example, the diaries in the “Mr Forbes Collection” may be series 1, given reference number “FOR/1”. The first diary in this series would be “FOR/1/1”.

                  This results in a connected tree of reference numbers:

                  • FOR [collection]
                  • FOR/1 [series 1]
                  • FOR/1/1 [series 1, item 1]
                  • FOR/2 [series 2]
                  • FOR/2/1 [series 2, item 2]
                  • FOR/2/2 [series 2, item 2]

                  How should I come up with a reference code? This is totally up to you. Reference numbers are assigned in many different ways.

                  • Not too long! Remember that if you choose to use a hierarchy approach, you will be adding further parts to your reference number to represent series and items.
                  • A typical example is to use ‘ms’ (manuscript) and a running number: ms1; ms2; ms3 etc
                  • Using letters that help link the reference number with the collection e.g. “Mr Forbes Collection” gets reference “FOR”
                  • Using letters and numbers to show the type of collection and sequence, e.g. PP23 may be “Papers of Jenny Green”, the 23rd collection within your repository’s Personal Papers collections.

                  Good to know: Accession numbers

                  Both museum and archive approaches both use identity codes called “accession numbers”. However, the two professions use them in different ways.

                  • For professional Archive Services, an accession number is a temporary number assigned to a collection when it is first received by the repository. The “collection” will subsequently be assigned its permanent, unique reference number, which becomes its main identity code. For example, the Mr Forbes Collection may be assigned accession number 59 – and subsequently reference number “FOR”.
                  • For Museums the accession number is the main identity code assigned to an item, which will continue to be used.

                  For tips on how to use Museum accession numbers as your Archive reference numbers, see the following tab on converting existing catalogues.

                  Level

                  Required for? Top level and lower level descriptions.

                  What is it? A level indicates whether your catalogue description refers to the whole collection, a section of the whole collection, or a single item. See the previous tab on “levels” for a detailed introduction to the concept of levels in archival cataloguing.

                  How does it work? When cataloguing for Archives Hub, you must choose from the following prescribed levels, from highest to lowest level:

                  Collection  – Series – Sub-series – Sub-sub-series – File – Item – Sub-item

                  The level values you include will not be visible to the public, but are used by Archives Hub’s technical system to build a hierarchy, with sections and groups of records in your catalogue, that a researcher can click into to find more information.

                  How should I decide which level to use? You must always include a “top level” summary record, which describes the whole “collection”. Following this, you may include lower level records, either in a ‘flat’ form of a list or in a hierarchy with multiple sections. See the ‘Cataloguing’ tab for more information on these approaches.

                  Collection – the whole amount of materials in this collection

                  Series – traditionally, a section within whole collection which indicates a sequence of related items e.g. a series of account ledgers; a alphabetical or chronological series of correspondence folders. It may also be used to indicate a segment of related items: a group of printed materials; materials relating to a particular event.

                  File: a smaller group of materials. This may relate to a literal file or folder, such as a file of correspondence, but can also indicate a smaller sub-segment of items such as a bundle of photographs.

                  Item: a single item such as a photo, letter or poster

                  • Flat list

                  If you choose to follow a flat list approach, it is recommended to follow the sequence:

                  Collection – item – item – item – item etc.

                  • Hierarchy

                  A simple hierarchy may include a collection, divided into sections by series, with files or items falling within these series

                  Good to know

                  • Your level value will not always directly correlate to the physical form of your collection, e.g. a ‘file’ level description does not always indicate that items are kept within a file.
                  • You do not need to use every level value
                  • You can start with a broad collection description and add lower levels later
                  • Archives Hub’s system works on a strict hierarchy based on the level values shown above. This means that in a catalogue with a description with level value ‘item’ following a description with level value ‘file’, the system will assume that ‘item’ belongs in the previous ‘file’

                   

                  Title

                  Required for? Top and lower level descriptions

                  What is it? A brief label that indicates to catalogue users what the described collection, series, file or item is

                  How does it work? You choose a suitable title for the collection, section or item you are describing. Your title works like a label on a closed box or title on the spine of a book, providing a short-hand insight into what a user may expect to be inside.

                  • Keep your title short but clear – you can provide additional information in other fields
                  • For items that already have a title, such as printed items or reports, it is customary to use that title; if the title is very long it is acceptable to abbreviate it, and include the full title in the “Scope and Content” field.
                  • For collection level titles, provide a title that indicates it is a collection and the unique content of the collection: “Papers of Margaret Jones” NOT “Margaret Jones” or “Papers”

                  Good to know

                  • Consider how your title will appear when your catalogue is online: will it make sense to someone who finds the title through an internet search?
                  • Some original titles contain offensive language and racist terms, e.g. “List of niggers”. Indicate an original title by using quotation marks, and the term ‘sic’ e.g. “List of niggers” [sic]
                  • Use separate fields for different types of information, such as dates
                  • You can use the title to indicate where an item is a copy/not the original item, e.g. “Letter from Winston Churchill [copy]”
                  • You can use the title to indicate where an item is missing or mislaid: “Accounts of Springhill Paper Mill [missing]”

                  Display dates

                  Required for? Top level descriptions; recommended for lower level descriptions

                  What is it? The date or date span when the archival item(s) you are describing were created.

                  How does it work? This is a free text field. Ways of indicating the date may include:

                  • 19th Century
                  • 1900 – 1950
                  • c. 1842
                  • 1740s – 1780s

                  Good to know

                  Even if you do not know the exact date, including an estimate is helpful for researchers, even if this indicates a broad timespan.

                  • For example: 1920s, 18th century, approx. mid 20th century.

                  It is recommended to write dates in full where possible to make them as clear as possible for an international audience.

                  • For example 1 December 1900 NOT 1/12/1900

                  If an item is a copy, such as a transcription or a photocopy, you should give the date the copy was made.

                  • For example, for a photocopy of a letter written in 1780 but copied in 1970, use the date 1970. The date of the original can be indicated in the ‘Scope and Content’ segment.

                  Start date

                  Required for? Top level descriptions

                  What is it? The earliest date of creation an archival item to which the description you are writing refers. As this is at the ‘top level’ or ‘collection’ description, this is the earliest created item in the collection.

                  How does it work?  Dates in this field must be in the standardised format: YYYY.

                  • For example: if your collection dates to “19th Century” you would enter ‘1800’ as the start date.
                  • To include a date prior to the year 1000 CE you must include an initial zero E.g. the year 890 would be entered as 0890

                  Good to know 

                  This field is for search engine use only, and is not displayed to the public.

                  End date

                  Required for? Top level descriptions

                  What is it? The most recent date of creation of an archival item to which the description you are writing refers. As this is at the ‘top level’ or ‘collection’ description, this is the most recently created item or youngest in the collection.

                  How does it work?  Dates in this field must be in the standardised format: YYYY.

                  • For example: if your collection dates to “19th Century” you would enter ‘1899’ as the end date.
                  • To include a date prior to the year 1000 CE you must include an initial zero E.g. the year 890 would be entered as 0890

                  Good to know 

                  This field is for search engine use only, and is not displayed to the public.

                  You can indicate that a collection contains items dating up to the present day and ‘ongoing’ by entering ‘9999’

                  Extent

                  Required for? Upper level descriptions

                  What is it? Indicates how much material is in the collection.

                  How does it work? You can describe this in any way which makes sense for your collection.

                  • 3 meters
                  • 20 boxes
                  • 8 files
                  • 200 images

                  Good to know

                  • An estimate of the extent is acceptable
                  • Your description should give researchers an idea of what to expect from the collection, so they can plan how much time they may need to be able to use it.

                  Scope and Content

                  Required for? Upper level descriptions; recommended for lower level descriptions

                  What is it? A summary of the archival material you are describing and key content or themes.

                  How does it work? Scope and Content offers a space to provide more detailed information on the collection or items being described. This may include:

                  • A summary of the content present in the item(s) being described
                  • For example: Letter from Mrs McDonald to Annie Black discussing an upcoming family wedding; Handwritten account ledgers for the Cupar Cake Society, including expenditure on ingredients, visiting speakers and extensive kitchen renovations (January – August 1934) and income from subscriptions and weekly cake sales.
                  • Details on the physical form and appearance of the items, in particular where this relates to the production or use of the recrord E.g. “Handwritten report on building methods, 1860 – 1890; written in Gaelic, with brief summary in English; English and Gaelic segments are written in different hands”

                  Good to know

                  • Researchers using your catalogue may not have used your collection before and cannot see the item being described
                  • Researchers may not be familiar with your local customs, organisations or geography.
                  • Paint a picture by expanding your description e.g. “Johnson on holiday” is clearer as “Black and white photo of Mrs Johnson sitting on a beach, looking towards the sea; photograph is undated, however clothing suggests 1950s”
                  • Expand any acronyms or abbreviations where possible
                  • Provide context for local festivals where known E.g. “Schedule for Lanark Lanimers, an ancient festival in the Burgh of Lanark held in June and including a parade and crowning of a Lanimer Queen”
                  • Expand location descriptions E.g. “Market Cross (Dunkeld, Scotland)”

                  Access conditions

                  Required for? Top level descriptions

                  What is it? Is the material being described open to researchers, restricted or closed? Do researchers need to fulfil any requirements to see the material, such as making an appointment or paying a fee?

                  How does it work? Lay out in brief whether researchers may access material and how. Often this includes:

                  • Open or closed
                  • Restricted access
                  • Restrictions may apply in accordance with data protection requirements
                  • Please contact the archive to make an appointment

                  Good to know

                  You can include a contact email address here if desired.

                  It is acceptable for different parts of a collection to have different access conditions, for example to have an ‘Open’ collection, with a ‘restricted’ series or file.

                  Language

                  Required for? Top level descriptions

                  What is it? The language or languages of the archival materials being described.

                  How does it work? Identify the known languages present within the collection; separate multiple languages using a comma.

                  • For example: Scots, English, Latin

                  Good to know

                  For non-text materials, such as photographs, check for annotations or labels and use these to indicate a language.

                  Creator

                  Required for? You must include a creator field for top level descriptions; however this does not need to be filled in

                  What is it? The person(s) or organisation(s) who created the archival materials OR who created the collection

                  How does it work? This field identifies the known creator or creators; at collection level, this is NOT every individual or organisation who has created items in the collection, but the primary organisation or individual associated with the collection.

                  There are three different creator fields used by Archives Hub:

                  • creator (person): used if the primary creator is an individual, e.g a particular photographer; personal papers relating to a particular person
                  • creator (organisation): used if the primary creator is an organisation such as a business, charitable group, school, leisure club, sports club
                  • creator (family): used if the primary creator is a family e.g. ‘The McDougalls of Incholm”
                  • You can include multiple creators of the same type using a comma.
                  • For example: Annie Black, Arthur Kent

                  Good to know

                  For individuals, organisations and families associated with the collection but not who are not the primary creators, these names can be highlighted using the ‘index term’ fields – please see the tab below.

                  For non-text materials, such as photographs, check for annotations or labels and use these to indicate a language.

                  Optional additional fields

                  Administrative/biographical history

                  Required for? Optional field, recommended at top level

                  What is it? A brief history of the organisation which is the primary creator or biography of the person or family associated with the papers.

                  How does it work? This short history or biography provides context on the archival collection to researchers. This should help researchers to understand and use the collection, for example by:

                  • providing a timeline for a business or organisation
                  • outlining changes to an organisation or business name, mergers or divisions
                  • providing a family tree
                  • highlighting key locations associated with the collection, such as a business address or family properties.
                  • for family papers, clarifying which branch of a family the collections relates to, and how this branch may relate to wider parts of the family

                  Good to know

                  • When providing biographical information, be aware of data protection requirements surrounding information relating to living individuals.
                  • Consider whether there may be living relatives who could be impacted by sharing personal or sensitive information

                  Subjects

                  Required for? Optional field; used mainly at top-level but can be used throughout

                  What is it? Key words indicating the main themes or subjects present in the item(s)

                  How does it work? Key words can be added which act like ‘tags’, allowing these key words to be discovered by researchers searching using these terms. It is recommended to use a central source to identify which subject terms to use, such as:

                  Good to know

                  Key terms relating to people, named organisations and geographic locations should be placed in the appropriate “Index Term” field – see the segment below.

                  • When providing biographical information, be aware of data protection requirements surrounding information relating to living individuals.
                  • Consider whether there may be living relatives who could be impacted by sharing personal or sensitive information

                  Place names

                  Required for? Optional field, generally used at collection level descriptions

                  What is it? Key words indicating the main geographical sites or locations present in the item(s)

                  How does it work? Key words can be added which act like ‘tags’, allowing these key words to be discovered by researchers searching using these terms. It is recommended to use a central source to identify which place names to use.

                  • E.g. Edinburgh (Scotland)
                  • E.g. Cuillin Hills (Scotland)

                  Good to know

                  Key terms relating to people, named organisations and thematic subjects should be placed in the appropriate “Index Term” fields

                  Index terms

                  Required for? Optional field

                  What is it? Key actors linked to the content of the collection under three categories:

                  • persons;
                  • organisations;
                  • family names

                  How does it work? This allows the described collection to be discovered by researchers using these names. It is helpful to use a source such as VIAF or TNA discovery to identify names.

                  Good to know 

                  • Adding life dates helps to make names less ambiguous.
                  • For associated organisations or individuals who are not well known figures, information on known dates and location can help to add context, e.g. “Mrs Mariah Harmann (d. 1913, Aberlour)”; “Bill’s Garage (1960 – 1982, Dumfries)”.

                  Archivist's note

                  Required for? Optional field

                  What is it? Who created the catalogue description and when, and may note any major subsequent edits

                  How does it work? 

                  • E.g. “Original description created by Helen Green, 2003; description expanded by T. Birnam, 2010”

                  Good to know 

                  There is a separate ‘Note’ field for general notes relating to the collection or management of the collection.

                  Former reference

                  Required for? Optional field

                  What is it? Optional former reference for the described materials

                  How does it work? This indicates where archival materials have been known by a previous identity number, which has been superceded by a new reference number. It can be helpful to record this old reference to aid with continuity, to show the history of care for the material, and as the old number may still appear in older documentation or research. There may be a former reference number if:

                  • Material has been transferred from one organisation to another, for example when a heritage services close down or merge
                  • Items have been re-arranged within a collection
                  • Items have been moved from one archival collection to another

                  Alternative reference

                  Required for? Optional field

                  What is it?  Optional alternative reference for the described materials.

                  How does it work? An alternative reference may be in use, for example where an Archive Service uses one reference number as an identity number and a separate number to create an archival hierarchy.

                  Good to know 

                  • Note: not all collections have alternative reference numbers.

                  Digital material link

                  Required for? Optional field

                  What is it? A link (URL) to digital material on the web.

                  How does it work? Adding a URL link here allows researchers to click on the link to access digital or digitised archival material which you have made available on a publicly accessible website.

                  • Add a valid and current link, e.g. https://archiveshub.jisc.ac.uk/mediaImages/brighton/209729.jpg.
                  • This could be scanned or digitised images of hard-copy archival material
                  • It can also be material created in a digital format such as a digital photo or pdf document

                  Good to know 

                  • Separate each link by a semi-colon or the pipe character.

                  Digital material description

                  Required for? Optional field

                  What is it? An optional description of the digital material associated with your archival description

                  How does it work? The description provides information on the digital material which can be accessed through the URL link you have included, and appear alongside the link in the hub display.

                  Good to know 

                  • Separate each description by a semi-colon or the pipe character.
                  • Each description should be applicable to its respective digital material link.
                  • Including digitised materials is option; it is acceptable to provide a text catalogue only

                  Arrangement

                  Required for? Optional field

                  What is it? The physical or logical ordering of the archival material

                  How does it work? Information on how the materials you are describing are structured, and whether this has been put in place by the Archives Service or reflects the order in which materials were kept by the person or organisation creating them.

                  • e.g. ‘Maintained in original order’ – this indicates the collection has been kept in the logical arrangement in which it was kept when in use.
                  • e.g. ‘material is not arranged; box list only’ – this indicates the collection is described in the order in which it is stored; no logical or deliberate arrangement has been applied to the material.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Finding aids

                  Required for? Optional field

                  What is it? Information about other finding aids

                  How does it work? Provides details on additional aids regarding the collection you are describing:

                  • e.g. if you have your own online catalogue, this can include your own catalogue record. You can add a full URL to link to your catalogue if you wish.
                  • e.g. a hard copy list such as a typed box list or index, which may support a researcher to use and understand the collection

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Related material

                  Required for? Optional field

                  What is it? Any materials known to be related to the described material, held in the same repository or by other repositories.

                  How does it work? 

                  • e.g. “See also: ephemera regarding the Glenvale Curling Club held in the “Papers of Hettie McIntosh”, reference number ms892″

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Separated material

                  Required for? Optional field

                  What is it? Materials linked to the described materials by provenance (their origin of creation/collection)

                  How does it work? Indicates if there are known or suspected materials which have been linked to the item or item(s) being described but which may have been removed, destroyed, or physically separated.

                  • e.g. a known leaf or image cut out of a folio
                  • e.g. a manuscript known to have been held by a collector but which has been separated and sold
                  • e.g. a segment of a club’s archival papers held by a secondary organisation

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Appearance

                  Required for? Optional field

                  What is it? Significant aspects of appearance

                  How does it work? Provides details regarding the physical appearance of the materials, which may be of research interest

                  • e.g. colour, style, marks
                  • e.g. methods of creation
                  • e.g. ruled in red ink, bound in 19th century leather.

                  Genres/forms

                  Required for? Optional field

                  What is it? Types of material

                  How does it work? A space to include information on the physical format of materials or the genre of materials

                  • e.g. account books
                  • e.g. sound recordings, photographs

                  Dimensions

                  Required for? Optional field

                  What is it? The size of the described materials

                  How does it work? Usually used at item level

                  • e.g. 23 x 16 cm
                  • e.g. 15 mm x 32 mm

                  Accruals

                  Required for? Optional field

                  What is it? Information about anticipated additions to the described materials.

                  How does it work? For archival collections relating to continuing organisations, this field indicates whether additional material is expected to be deposited with the Archive Service, and how regularly (if known).

                  • You can also indicate if no additions are expected.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Appraisal

                  Required for? Optional field

                  What is it? Information on assessment, weeding and retention of the described materials.

                  How does it work? This can include details on whether decision to retain or weed material is based on a particular policy or agreement. Such information can help researchers to understand which actions have been taken by the Archive Service and why.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Conditions governing reproduction

                  Required for? Optional field

                  What is it? Restrictions on copying, quoting or publishing any of the described material.

                  How does it work? Note any restrictions that may effect researchers who wish to copy or take notes from material, for example:

                  • whether a work is in copyright
                  • specific donor restrictions, such as a requirement to request specific permission prior to copying or publication

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Custodial history

                  Required for? Optional field; primarily used at collection level descriptions

                  What is it? Information about the history of the ownership or care of the collection.

                  How does it work? Provide any details known where a collection or item has been, its care or ownership, prior to acquisition

                  • E.g. Letter was discovered under floorboards at 12 Market Street, Scotstown, by Mary Jones, prior to 1880; the letter remained in the possession of the Jones family, and was donated to the Village Museum by David Jones in 1954. It was transferred to the care of the Archive Service in 1989 with all other holdings when the Village Museum was closed.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).
                  • Consider Data Protection requirements when including details relating to living individuals
                  • Consider any known donor preferences with regard to privacy

                  Immediate source of acquisition

                  Required for? Optional field

                  What is it? 

                  How does it work? Where and when the repository acquired the described materials and in what circumstances. For example:

                  • Was the material purchased: from whom, and when? E.g. ‘Ledger purchased at Kinross Auctions, May 1999’
                  • Was the material discovered: how, where and when?  E.g. ‘Files discovered in attic of St Luke’s Church Hall during renovations, by Church Warden Alasdair Green, and brought into Archive Service January 1980’
                  • Was the material donated: by whom*, and when? E.g. Photograph album donated by Geraldine Parker, Glasgow, August 1900″

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).
                  • Consider whether inclusion of purchase value details may place an item at risk of theft
                  • Ensure any donor information presented is in line with data protection requirements
                  • Ensure donor information is presented in line with preferences expressed by the donor regarding anonymity (where known)

                  Location of copies

                  Required for? Optional field

                  What is it? Details regarding copies of the described original archival materials

                  How does it work? Where known, indicate if there are copies of the described materials, where the copies are held, and in what format.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Location of originals

                  Required for? Optional field

                  What is it? Where original material is held, in cases where described materials are a form of copy

                  How does it work? Indicates if there are originals of the described materials, for cases when the archival items being described are held as a form of copy, including formats such as microfiche, photocopies, scans, transcriptions, photographs of manuscript materials.

                  If known, this field can be used to note details such as:

                  • where the originals from which the copy was made are held, and in what format.
                  • E.g. Original treatise a bound vellum manuscript held by the Bibliotech Nationale de France, reference number …
                  • E.g. Original postcard collection retained in private collection by Donor, Perthshire (Scotland)

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).
                  • Where material has been retained by a donor or a known private collection, ensure information provided on originals is in line with data protection requirements and any expressed wishes of the donor.
                  • E.g. Do not include specific details of private addresses of living donors
                  • E.g. Where possible, ascertain from living donors/lenders their preference for being named as a donor or appearing in an anonymised form.

                  Note

                  Required for? Optional field

                  What is it? General comments relating to the archival materials

                  How does it work?  A free text field, used for short general comments that can’t be added elsewhere. e.g. explaining the text or citing sources.

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).
                  • The field ‘Archivist’s note’ should be used to record information on the creation and editing of the catalogue by archival staff or volunteers.

                  Publications

                  Required for? Optional field; primarily used at top-level descriptions

                  What is it? Publications which are based on, or written about the described material.

                  How does it work? Allows the catalogue to indicate published materials relating to the archival materials being described, which may aid researchers in understanding the archival material, or to gain an overview of previous research that has used the archival material.

                  • E.g. “R. Smythe, A Sweet History of the Cupar Cake Club (Cupar Printing Press, 1943)”

                  Good to know 

                  • Separate paragraphs of text by a line break (Alt + ENTER).

                  Using the Archives Hub spreadsheet to create a catalogue

                  This is an overview of how to use the Archives Hub template spreadsheet. Using this spreadsheet allows you to:

                  • create a catalogue that can be populated offline
                  • publish your catalogues online on Archives Hub and Your Scottish Archives

                  Note: even once your catalogue information has been uploaded to Archives Hub, you should always keep your own master copy of your catalogue data.

                  Overview of using the Archives Hub spreadsheet

                  Archives Hub provides a detailed guide to using this spreadsheet; you may find it helpful to read this before starting your catalogue.

                  The template spreadsheet is available to download here

                  • The top row of the spreadsheet shows field names (categories of information about your collection). Fields you must complete are shown in red, recommended fields in yellow, and other optional fields in black. You should not delete this row
                  • You can get tips on how to fill in each field by hovering your cursor over the field title; more detail is available in the guide linked above and here in the ‘Descriptive Fields’ tab
                  • Your first description, under the field name row, should be a top-level description, such as a ‘collection’ description; this is a summary or overview of the whole collection you are describing.
                  • Your top level description should include information in all 10 required (red) fields
                  • You should include one description per row
                  • Lower level descriptions should include information in the fields: reference number; level of description; title.
                  • The text options for the field ‘level of description’ are fixed; you will see a drop down menu appear to the right hand side of the field.
                  • You should include your descriptions in the order you wish them to appear when published; this is usually in order of your archival hierarchy (tree) or order of box listing

                  Naming and saving

                  Give your catalogue file a unique name that directly relates to the collection you are cataloguing. You may wish to use the collection’s reference number.

                  Excel in browser versus on desktop

                  Note that some functions within Excel work differently depending on whether you are using an online version – working on a file in an internet browser – or working offline.

                  Adjusting the spreadsheet for your needs

                  Protect / unprotect sheet

                  You may find that when you first download the Archives Hub spreadsheet template it is a ‘protected sheet’; this will prevent you from making certain changes, such as adding and deleting columns.

                  • To change this, select the review tab at the top of your sheet, select ‘manage protection’ in the ‘protection’ area, and switch the ‘protect sheet’ toggle to off.

                  Hide/unhide columns

                  You can adjust the template spreadsheet to fit your needs. For example, if there are fields (columns) you are not using for this particular collection, you can hide these.

                  • Highlight the column by clicking on the column letter at the top of the column; right click with your mouse, then select the hide columns option.
                  • To unhide the column again, highlight the preceding column and subsequent column by clicking on the top of the column to highlight, holding down the shift button, then clicking on the subsequent column, right click mouse, select ‘unhide columns’ option.

                  This can also be helpful when describing at lower levels, where, for example, you may only wish to use the ‘reference number’, ‘level of description’ and ‘title’ fields.

                  Deleting columns

                  If there are fields you will not be using for an entire collection, you may also delete columns. To do this, click on the top of the column to highlight the whole column, right click on your mouse, and select delete

                  NOTE: You must retain the columns ‘reference number’, ‘level of description’, ‘title’, ‘display dates’, ‘start date’, ‘end date’, ‘languages’, ‘extent’, ‘scope and content’, ‘conditions governing access’ and at least one creator column e.g. ‘Name of Creator – Person’.

                  Freeze top row

                  Freezing the top row – which shows the field names – enables you to continue to see the required content for each column as you fill rows of the spreadsheet. This can make it easier to keep track of which information to include in which column when you are cataloguing a large collection.

                  To do this, highlight the top row by clicking in the number at the left hand side, select the ‘view’ tab at the top of the page, select the ‘freeze panes’ option in the ‘window’ area, and click on ‘freeze top row’.

                  Selecting cells

                  To select a cell, place your cursor in that cell and click

                  To select multiple cells in a continuous area, click in first cell you wish to select, hold down the shift button on your keyboard, and click into the final cell you wish to select.

                  To select multiple non-continuous cells, click into the first cell, hold down the control key, click into the next cell you wish to select.

                  Copying, Cutting and Pasting

                  Copy: This makes a duplicate copy of selected text, which may be subsequently replicated elsewhere in your spreadsheet.

                  • To do this, select the cell or cells you wish to copy; select the ‘copy’ function in the clipboard area at the top of your page OR right click and select copy from the menu OR use shortcut CTRL + C

                  Note: if you try to copy multiple cells in a row while a column is hidden, the hidden column will also be copied

                  Cut: This ‘cuts out’ and removes selected text, which may be subsequently place somewhere else in your spreadsheet; note the original cut text is removed completely.

                  • To do this, select the cell or cells you wish to cut; select the ‘cut’ function in the clipboard area at the top of your page OR right click and select cut from the menu OR use shortcut CTRL + X

                  Paste: this places items you have previously copied or cut into your spreadsheet.

                  • To do this, click into the field where you wish to paste the item; select the ‘paste’ function in the clipboard area at the top of your page OR right click and select paste from the menu OR use shortcut CTRL + V

                  NOTE: when copying and pasting dates, you may notice that your text or numbers change when you paste your selection in a new location. Selecting the ‘paste as value’ option should ensure your date remains in the same format as that you have copied

                  Drag and fill

                  Filling multiple cells with the same text:

                  • enter the text you want in the first cell;
                  • click into the cell with your cursor;
                  • moving the cursor to the lower right hand corner of the cell, hover the cursor until it appears as a black cross;
                  • click with this cross and drag downwards. The cells will fill with the same text as the first cell.

                  Useful for:

                  • groups of very similar items, which may have the same title e.g. ‘Letter from Mr Patrick to Mrs Patrick’
                  • groups of items with the same date. NOTE: you will need to fill in two example dates, then select both fields and drag your cursor down.

                  Simple numerical pattern:

                  • enter the numbers you want in the first and second cells;
                  • highlight the first and second cells;
                  • moving the cursor to the lower right hand corner of the cell, hover the cursor until it appears as a black cross;
                  • click with this cross and drag downwards. The cells will fill with the desired numerical pattern, e.g. 1, 2, 3, 4, 5, 6, 7; OR ARCH/1, ARCH/2, ARCH/3; Minute Book 1, Minute Book 2, Minute Book 3;

                  Useful for:

                  • reference numbers;
                  • titles of items in a numbered sequence.
                  • NOTE: The drag and fill pattern will not work if the final character you enter is not a number, i.e. ARCH/3a will disrupt the pattern

                  Find and replace

                  The command ‘control’ + ‘h’ allows you to find and replace text in your spreadsheet

                  Useful for:

                  • replacing consistent typos e.g. find: respository – replace: repository
                  • changing reference numbers in bulk. For example if you introduce a series, this function can be used to adapt a reference number by changing only the element that has changed without impacting other elements of the reference e.g. find: ARCH/ – replace: ARCH/S1/

                  Go to cell

                  The command ‘Ctrl’ + ‘g’ allows you to go to a particular cell within your spreadsheet, by using the column letter (shown at top of the sheet) together with the cell number (shown at the left hand of the sheet)

                  ConCat

                  The ConCat function within Excel allows you to join text from multiple separate columns. This can save time if you already have information within an existing spreadsheet. See the ‘Adapt a catalogue’ tab for details on how to use this function.

                  NOTE: if you wish to cut and paste the results of a ConCat formula, such as the now combined text of two cells, to a new sheet or new location, you will need to select the ‘past as value’ option. This should ensure the data appears as text rather  than as a formula.

                  Text to columns

                  The text to columns function within Excel allows you to separate data in a single column into multiple columns. Again, this may be helpful if you already have data in a spreadsheet, and would like to split this information into the relevant columns for the Archives Hub fields. See the ‘Adapt a catalogue’ tab for details on how to use this function.

                  Adding existing lists or catalogues to Archives Hub 

                  For information on adding catalogues based within an archival cataloguing system, such as Axiell Calm, Axiell Collections or AtoM, please see: guide to adding your collections

                  Other catalogues can be adapted for use in Archives Hub. This may be the case if:

                  • You use a Museum cataloguing system, such as PastPerfect
                  • You use a Library cataloguing system, such as Koha
                  • You are not using any cataloguing system or software
                  • You describe your materials in accordance with a non-archival or specialised standard, which is not archival cataloguing standard ISAD(G). For example, you catalogue in line with museum standard SPECTRUM

                  Collection information from such catalogues may be included in Archives Hub by using an Excel spreadsheet:

                  • to create an ‘umbrella’ description of all the materials your service holds, such as your main collections, your service’s core collecting areas, key associated individuals, topics or geographic areas, archive material formats
                  • to create top-level (‘collections level’) descriptions for each of your collections
                  • to write out a whole catalogue, including all archival levels
                  • to provide links to your existing online catalogue or other digital or digitised materials you have made available online

                  An ‘umbrella’ or ‘top level’ approach may be a good option if:

                  • Your existing catalogue is not in a spreadsheet or your cataloguing system does not have the capacity to export spreadsheets
                  • Your catalogue relates to a large collection described on an item by item basis only (a flat cataloguing approach), without any sections or catalogue levels
                  • You hold a specialised collection, such as a music or moving image archive, which has specific description requirements that are not standard fields within ISAD(G)

                  Uploading a spreadsheet

                  Catalogues may be submitted to Archives Hub using an Excel spreadsheet. This allows you to submit a whole catalogue/multiple descriptive entries within a catalogue for the same collection, in a single batch.

                  Archives Hub provides a template spreadsheet; however, it is possible to use your own spreadsheet, as long as your spreadsheet includes columns for each of the required fields (categories of information). It is also possible to use the Manage Your Collections (MYC) spreadsheet for the National Archives Discovery system.

                  Note that some fields may only be completed using fixed terms; please see the tab on descriptive fields for further details.

                  Using a spreadsheet may be a good option if:

                  • You already have a catalogue in spreadsheet format
                  • You can export or report from your current catalogue system or database in spreadsheet or CSV (comma separated value) format. This includes systems such as: Microsoft Access; PastPerfect; Community Chest; eHive; Vernon; EMU; Koha.
                  • Your catalogue is in Word – in particular if this is in tabular form – as this can be converted to Excel
                  • You wish to be able to work on your catalogues offline / without internet access

                  Detailed instructions on how to use a spreadsheet catalogue are available through Archives Hub

                  Adapting your current catalogue spreadsheet

                  1. Each collection you have should be catalogued on a separate spreadsheet; so, ensure only one collection is included on your spreadsheet. If you have multiple collections, these will be uploaded individually on separate spreadsheets.
                  2. Only the first ‘sheet’ within an Excel book will be read, so ensure your catalogue appears on the first sheet
                  3. The first row at the top of your spreadsheet should show the catalogue field names [categories of information], for all required fields: reference number; level; title; scope and content; languages; extent; display dates; start date; end date; access conditions; creator. Take a look at the tab on ‘descriptive fields’, where these fields are outlined in detail. NOTE (a) you do not need to include all fields shown on the template spreadsheet; (b) You may retain your own field names as long as these contain the appropriate information; it is possible for Archives Hub to map your own field names with the required fields when submitting to Archives Hub for the first time; (c) fields may appear in any order
                  4. The second row of your spreadsheet should be a top level description, such as a ‘collection level’ description; this is a summary of the whole collection you are describing, for which all 10 required fields should be completed. Detailed information on completing these fields is provided in the ‘descriptive fields’ tab.
                  5. The subsequent rows should show the rest of your catalogue, with one description per row. Each description should appear in the order you wish the descriptions to appear, when the catalogue is published. For example, this may be in order of your collection’s hierarchical arrangement or box listing.
                  6. Ensure the required fields for lower levels are filled in – these fields are: level, title, reference number. Additional fields may be completed if desired.
                  7. In general, read over your catalogue for suitability of content and language for sharing with the wider public. In some cases, catalogues which have only been used internally within a society or organisation may include unsuitable aspects such as:
                  • informal notes intended for internal use only;
                  • information on your respository’s private agreements with donors or other heritage organisations
                  • abbreviations or shorthand forms of terms which are not widely understood
                  • sensitive information relating to living people, such as donor addresses or notes on volunteers

                  Common adaptations

                  Joining cells:

                  Your catalogue may include useful information over multiple columns, that would appear in a single column (field) in the Archives Hub spreadsheet. For example, in your ‘Village Newspaper Clippings Collection’, you may have a separate columns for publication name, publication location, author and article title. All this information is best included under the ‘Scope and Content’ field in the Archives Hub spreadsheet, as, together, it provides a summary of what the item being described it, and its context.

                  Excel allows several fields to be joined using the ConCat function. To do this:

                  • choose an empty field where you wish the completed description to appear in the same row as the information you wish to join together
                  • enter the equals symbol (=) into that empty field
                  • click your cursor into the first field containing information you wish to include
                  • click the ampersand symbol (&), then click your cursor into the next field with information you wish to include
                  • You can also add in punctuation, spaces or text to make your collated text easier to read by placing this within quotation marks, e.g. &”article by”
                  • E.g. using the formula =B2&” (“&C2&”), ‘”&D2&”‘ “&”by “&E2 the first four columns may be joined to create ‘Scope and Content’
                  Newspaper Place Title Journalist Scope and Content
                  Farming times Hopelstoun Are Cows better than Sheep? E. Grumpton Farming times (Hopelstoun), ‘Are Cows better than Sheep?’ article by E. Grumpton
                  Village Voice Elsrickledon The New Look Town Centre Betty Parker Village Voice (Elsrickledon), ‘The New Look Town Centre’ article by Betty Parker
                  Crochet Weekly Higginford Seasonal Patterns Horace McDougall Crochet Weekly (Higginford), ‘Seasonal Patterns’ article by Horace McDougall
                  Farmers’ Journal Meidle This week on the farm F. Brown Farmers’ Journal (Meidle), ‘This week on the farm’ article by F. Brown
                  Farmers’ Journal Mortonfeld A roundup of winter feeds Sally Harper Farmers’ Journal (Mortonfeld), ‘A roundup of winter feeds’ article by Sally Harper
                  The Organic Florist Beech Hill Working without plastic for the modern floral display Dr I.F. Greenleigh The Organic Florist (Beech Hill), ‘Working without plastic for the modern floral display’ article by Dr I.F. Greenleigh

                  Dividing cells:

                  In other cases, you may wish to separate information in a single column into multiple columns, so that you are able to include it in the most appropriate Archives Hub field.

                  In some cases, this can be done using the Excel ‘text to columns’ function. This is most effective when your original catalogue data is entered in a highly consistent fashion, e.g.

                  1770. Letter from Paul to Mary Ross. Describes Paul’s voyage on a herring fishing expedition and putting in to harbour at Cellardyke.

                  1773. Letter from Paul to Mrs Ross. Describes visiting Holland for the first time, Paul’s impressions of Dutch food and people, and describes Paul’s visit to a protestant church service.

                  1780. Letter from Annie Ross to Mrs Ross. Describes Annie’s family life, the illness of her younger son James, and the upcoming marriage of her sister Harriet.

                  • select the ‘data’ tab at the top of your Excel sheet
                  • highlight the area you would like to separate
                  • In the ‘data tools’ area, select the text to column option
                  • choose the symbol you would like to use as a point to separate the text in your column. For the example above, this may be a period ( . )
                  • The text will then be separated into three columns, which, in this example provided, may become ‘Display Dates’, ‘Title’ and ‘Scope and Content’ within the Archives Hub spreadsheet.

                  Reference numbers:

                  In the first instance, the Archives Hub processing system will use the reference numbers you provide to build the hierarchy (tree) for your catalogue.

                  If you wish to use reference numbers to build a hierarchy, your reference numbers must be constructed using a slash (/) rather than a period ( . ) e.g. ARCH/1/2 NOT ARCH.1.2.

                  • TIP: A quick way to change this is to highlight the appropriate area and use the find and replace function, holding ctrl + H, to replace the periods with slashes.
                  • Any reference number should include a collection identifier + item identifier e.g. the Henry Gray photographic collection may have collection reference ‘HGPC’, meaning that photo 12 would appear as HPCG/12.

                  Some collections may have a pre-exiting accession number/object number type system for identification numbers, which uses a date + running number approach, e.g: 2012.0032.

                  • A simple way to convert this so it will upload successfully to Archives Hub is to add a collection reference in front of the existing number e.g. ARCH/2012.0032.
                  • This can be used to form reference numbers for a simple top level description with flat item listing e.g.

                  ARCH [collection level]

                  ARCH/2012.0032 [item]

                  ARCH/2012.0037 [item]

                  ARCH/2020.0016 [item]

                  • This has the advantage that the existing reference number is clearly present as part of the adapted reference number.
                  • TIP: if you need to adapt your existing reference or identity numbers in order for your catalogue to upload, there is an ‘alternative reference’ field where you can also include you current identifier/reference

                  Creating an Archival Arrangement

                  In principle, collections which have not been arranged, or follow a flat list or museum approach can be included in Archives Hub. However, the Archives Hub system is not designed to manage large collection catalogues which are in simple list format with no hierarchy (sections).

                  The first option is to create a summary of your collection within a spreadsheet, that will provide an overview of what is in your collection, and highlight key associated people, organisations, places and themes or topics. This is described above.

                  The second option is to introduce sections. There are several ways to do this, and it is very dependent on your collection and how you look after this. Some options are:

                  Working with your catalogue as it is:

                  Consider whether your collection or catalogue already has sections which may be used; at the top of each section, introduce a new row, and give the section a reference number, level (“series”) and title

                  • These sections may be physical sections: for example, if you have a box by box list, you may be able to designate ‘box 1’ as section 1, ‘box 2’ as section 2 etc. If you follow this approach, it is recommended that you note in the ‘Arrangement’ field that the collection has not been arranged, and the catalogue is a box list.
                  • You may notice that your existing catalogue has descriptions clustered together in groups of related items, even though you have not deliberately arranged the collection. For example, within a photographic collection, images 1 – 50 may be related to farming, images 51 – 80 related generally to schools; images 81 – 170 related generally to Villages A and B. Each of these may be designated as a section
                  • If your catalogue follows a chronological accession pattern, you may be able to create sections for chronological periods e.g. “series 1: accessions 1950 – 1955”; “series 2: accessions 1956 – 1960” and so on

                  Re-arranging your catalogue to create sections:

                  In some cases, you may be able to re-order your catalogue descriptions to create logical sections.

                  • This should be undertaken with caution: you must ensure you remain able to identify the original item and description in your own catalogue and which item this relates to in your physical collection.
                  • This can be achieved through retaining your original reference or identification numbers as part of the new reference number hierarchy

                  If it is the case that when looking through your box list / flat list catalogue you can see material which appears to be linked to other material in the same collection, consider whether it would be beneficial to undertake a formal re-arrangement of your collection.

                  We are happy to provide support and advice on the best way to proceed with your catalogues. If in doubt, please do contact an Archivist!

                  Cataloguing guides and resources

                  These are some great resources which provide tips on how to go about cataloguing your collections. Bear in mind that in order to be able to share your catalogues through the Your Scottish Archives portal, you will need to be able to add your collections to Archives Hub, so it is important to ensure you include all the required information.

                  General cataloguing guides

                  Fair and inclusive cataloguing

                  How to describe your archival materials

                  • Be concise but descriptive
                  • Your description should help someone who is not currently looking at the physical item you are describing to understand
                    • what it is
                    • whether they may wish to see it in person
                    • whether it may be useful for their research
                  • Write for an external audience which has not used your collection before
                  • Avoid acronyms, slang or jargon, for example acronyms for local societies; if these are important to the records, try to offer a brief explanation
                  • Make locations or traditions clear for an international audience, by providing context where appropriate
                  • Avoid sharing details relating to living individuals protected under data protection legislation, such as home telephone numbers or addresses
                  • Consider whether personal information about the subject of an archival item may impact or distress living friends or relatives
                  • Consider whether archival items or historic language may be racist, offensive, inaccurate or upsetting, and include explanations or warnings where appropriate. This can be especially the case when cataloguing:
                    • records relating to colonial matters;
                    • records relating to illness and mental health;
                    • records relating to treatment of the poor;
                    • records relating to minority groups such as Travellers or Roma;
                    • records relating to different racial groups.
                    • Please see the Resources tab for guides and glossaries on such materials.

                  Checklist for uploading your catalogue

                  • Have you completed the 10 required fields at top level? If these are not completed, your spreadsheet will not upload and publish.
                  • Does each description (or row) include a ‘level’ value? You can check for blank fields in your spreadsheet by selecting the column, using the Excel ‘data’ function, and searching for ‘blanks’ only. You can then fill in values for any blank fields; make sure you do not drag down a value at this point as this will change the text in all the in-between rows
                  • Have you included any index terms in your top level description, if relevant? These terms will make it much easier for researchers to find your collection. Remember that if you wish to include more than one term per category, this should be separated by a pipe character or a semi colon e.g. Mrs Angela Green (1874 – 1945); Mr Ernest Green (1869 – 1918); Anabella Forsyth, nee Green (1896 – 1977)