One of our Web Applications gives the users the ability to add multiple items to our database using a CSV file. To do this, they enter their items into an Excel template and then export to CSV.
However, most end users don't understand that if they put commas into the "Description" field it messes with the formatting of the exported CSV file, causing errors when trying to add items to the database.
I would normally just parse through the CSV in the back-end of the web app, but in my case I cannot just simply take out commas for obvious reasons.
Is there any way to disable the use of commas (,) right in the Excel Template? Like formatting a column?