Excel Validation Tool for Human-Entered CSV Data

[raphaelvp]

• Evaluate the previously developed Excel-based CSV validation solution and identify updates needed to support the latest CSV schemas and validation requirements.
• Assess the feasibility of adapting the tool to address current data quality issues arising from manually entered CSV files.
• Ensure that validated Excel files can be automatically converted into compliant CSVs ready for ingestion.
• Explore options to develop a cloud-hosted validation service that enables users to perform remote CSV validation prior to submission.