I built an Excel workbook for an online racing league that calculates championship standings, points, and driver statistics from race results. The calculations are mostly automated, but I still have to copy each race's CSV data into separate sheets, manually maintain the driver list, and make a few adjustments so the formulas reference the correct race sheet. The workbook currently supports up to 36 races per season.
I would like to turn this into a more user-friendly application where someone can upload one or more CSV result files and have the system automatically add new drivers, process the results, and generate standings, statistics, tables, and possibly charts. Excel works well for my personal use, but I want other leagues to be able to use the tool without needing to understand the workbook structure.
What programming language, platform, or approach would be suitable for building this?
3 Answers
Excel VBA may already be enough for this. A macro could let the user select or upload a CSV, place the data into the next available race table, update the driver list, and refresh the calculations and reports. If you eventually want multiple leagues or users accessing the system through a browser, move the data into a real database and build a web application. For a single workbook, though, VBA can automate nearly all of the repetitive steps.
You could stay within the spreadsheet ecosystem initially. Google Sheets combined with Apps Script can import CSV files, run custom processing, create or update sheets, and respond to triggers. Forms or an upload endpoint could provide a simple front end. If you already use Microsoft tools, Power Automate and related connectors are another possible low-code option, though licensing may apply. This is probably the quickest way to make the existing workbook easier to use before building a full application.
A practical approach would be Python with Pandas for reading and transforming the CSV files, plus SQLite for storing drivers, races, and results. You could then build a small web interface around it. The relationships between the data are already defined in your workbook, so the main work would be translating those formulas into database queries and Python logic. This would also make it easier to add charts, standings pages, and automatic driver creation. All of those tools are free, although you would need some programming knowledge or development time.
Excel is mainly handling the calculations right now. I would like to keep the same results but eliminate the copy-and-paste process, since other users may not understand which sheet each race CSV belongs in.
By database, I mostly mean the tables inside the workbook. At the moment I manually copy every CSV into a Race 1, Race 2, or Race 3 sheet so the formulas can read it. Automatically importing each file into the next race slot would solve most of the problem.