[EN] Convert market inspection agency check schedules from Excel to CSV/JSON

[ivbeg]

Goal

To make available Market inspection agency check schedules as JSON or CSV files.

Tasks

Market inspection agency yearly publishes check schedules as Excel files on its website http://www.msib.am/hy/applications
Example file
ՇՈՒԿԱՅԻ ՎԵՐԱՀՍԿՈՂՈՒԹՅԱՆ ՏԵՍՉԱԿԱՆ ՄԱՐՄՆԻ 2023 ԹՎԱԿԱՆԻ ՍՏՈՒԳՈՒՄՆԵՐԻ ԾՐԱԳԻՐ.xlsx

Tasks are:

1. Collect all check schedules as Excel files
2. Analyze Excel files structure
3. Convert Excel files to CSV or JSON files
4. Merge data into single CSV or JSON files adding check schedule year to each record

Context

This data is interesting for business, converting it from Excel to open data could help to create services and apps to help business to plan and operate.

Requirements

• create a public GitHub repository to store code and data under one of the free and open licenses like Creative Commons license or MIT license

Wishes

Please write your code as reusable code that could be launched by someone else later since we could need to update this dataset later.

Resources

• Market inspection agency check schedules web page http://www.msib.am/hy/applications

Prepared by

The Open Data Armenia team prepared this task.