Data Import is a tool that simplifies the loading of CSV data to the Operational Data Store (ODS) of the Ed-Fi ODS / API. The import tool handles domains where vendor integration to the Ed-Fi APIs is not possible from legacy data sources such as state assessment systems. The system works by providing methods to extract information out of spreadsheet-based CSV data files, and transform and load to the Ed-Fi ODS / API.