Importing Excel data

📘

Introduction

Read https://avni.readme.io/v2.0/docs/structure-import-metadata-excel-excel

Note: dates get parsed incorrectly sometimes while converting from CSV to XLSX in Google Sheets (Eg. 12-01-2018 (dd-mm-yyyy) gets parsed as 01/12/2018) which may not be easy to spot. One solution is to download the CSV file and convert to XLSX in LibreOffice.

Template of an ideal migration file: