I am looking to incorporate two drop down menus on my website. One for selecting car brands and the other for choosing specific car models. I have successfully set up the drop down menu for car brands, but it currently only displays four options: Maruti Swift, Maruti Alto, and Maruti WagonR. I have an Excel file containing a list of 210 cars with their respective brands and models that I would like to integrate into this selection menu. Entering each model individually would be time-consuming, so I am wondering if there is a more efficient method to add all the car models at once?
Here is the code snippet I have implemented:
<div class="wrap-input100">
<span class="label-input100">Car Make:</span>
<form action="/action_page.php">
<select name="cars">
<option value="select">select</option>
<option value="Maruti,Swift">Maruti,Swift</option>
<option value="Maruti,WagonR">Maruti,WagonR</option>
<option value="Maruti,Swift Dzire">Maruti,Swift Dzire</option>
<option value="Maruti,Alto">Maruti,Alto</option>
</select>
<span class="focus-input100"></span>
</div>