How can I turn my racing league spreadsheet into an app that imports results?

You may not need a separate app yet. Excel can import CSV data, and VBA could automate the repetitive steps around importing files, updating the driver list and refreshing the reports.

The bigger change would be getting away from formulas that depend on a sheet for each race. Consider keeping results in one table with a race identifier on every row, then building standings and stats from that table. That also avoids having to prepare a fixed set of race sheets.

Google Sheets with Apps Script is another route if you want something people can access online. A script could handle imports and update a shared sheet, while forms or triggers could help with input and automation. Apps Script can also expose an endpoint if you later need one.

It still takes some coding, and a shared spreadsheet setup is different from giving every league its own independent app. Decide how you want leagues to keep their data separate before building around a master sheet.

If the goal is a standalone app, separate the job into three pieces: import the CSV, store the results, and calculate the reports. A database could hold leagues, seasons, drivers, races and individual results. The app can then calculate standings from those records rather than from fixed workbook sheets.

Start by writing down the columns in the CSV and the rules your workbook uses for points. The importer needs a way to match incoming drivers to existing ones and add new drivers when appropriate. It should also check for missing fields and prevent the same race from being imported twice by accident.

A CSV is the upload format, not necessarily the database itself. You could still use files for an early version, but a database becomes useful when people need to manage and retrieve multiple seasons and leagues.