Livestock producers often need help in standardising (i.e., converting and validating) their livestock event data. This article introduces a novel solution, LEI2JSON (Livestock Event Information To JSON). The tool is an add-on for Google Sheets, adhering to the livestock event information (LEI) schema. The core objective of LEI2JSON is to provide livestock producers with an efficient mechanism to standardise their data, leading to substantial savings in time and resources. This is achieved by building the spreadsheet template with the appropriate column headers, notes, and validation rules, converting the spreadsheet data into JSON format, and validating the output against the schema. LEI2JSON facilitates the seamless storage of livestock event information locally or on Google Drive in JSON. Additionally, we have conducted an extensive experimental evaluation to assess the effectiveness of the tool.

翻译：牲畜生产者通常需要在标准化（即转换和验证）其牲畜事件数据方面获得帮助。本文介绍了一种新颖的解决方案，即LEI2JSON（牲畜事件信息转JSON）。该工具是Google Sheets的一个插件，遵循牲畜事件信息（LEI）模式。LEI2JSON的核心目标是为牲畜生产者提供一种高效的数据标准化机制，从而大幅节省时间和资源。这是通过构建包含适当列标题、注释和验证规则的电子表格模板，将电子表格数据转换为JSON格式，并依据模式对输出结果进行验证来实现的。LEI2JSON有助于将牲畜事件信息以JSON格式无缝存储于本地或Google Drive中。此外，我们进行了广泛的实验评估，以检验该工具的有效性。