I am making a table for the user to fill out the information. My question is what approach to use; is it best practice to make the user chose the number of rows and columns beforehand, like so :
or to give them an excel like sheet and then they can chose how many rows and columns they need just by filling those out along the way.
The former forces the user to figure out the number of rows/columns beforehand, which might be frustrating since they actually have to make the math themselves and I’m afraid the latter will confuse the user that he has to use all the input fields on the screen (and what if he actually needs more then provided?)
Or is there other alternatives? What would be best practice?