Plugins for CSV import

OK. Did you check the app market for any fitting plugins?

There are two approaches for CSV import -> readcsvpaging() for in-memory parsing and the Import CSV to Database plugin for direct database import. Since your requirement involves a fixed template CSV with only varying row counts, I recommend using the Import CSV to Database plugin. This approach directly imports data into a temp table in a single operation, which you can then query through Records and display in a read-only grid. It's faster and more robust than in-memory processing, especially for large datasets, as it bypasses memory constraints and leverages database-level operations. Additionally, using Records as your data source automatically provides filtering, sorting, and pagination capabilities for the grid. This makes it the optimal solution for handling CSV imports with varying row counts while maintaining performance and flexibility.

Use the Excel Tools plug-in (readcsvlogtoCDT()) to parse the uploaded CSV into a CDT and then display the CDT list in a grid; for large files, use the CSV Importer Smart Service to load into DB before showing in a grid.