Editting Bulk submissions options at once?

Hi there, we'd like to edit bulk submissions.  For instance, on our Team Registration form, we have 'Division 5' as a choice, we wanted to list it as 'D5' so we can view it easier in our Excel Spreadsheets.  I know if we change the option in our form, the future submissions will accept the new naming convention, but it doesn't change the existing submissions.  Is there a way to do this?  Thanks very much for your time.

You're correct, you can't change the name of the selected checkbox for existing submissions. Since you mentioned Excel, you can get around this by using Find & Replace All.

e.g.

Find 'Division 5' then Replace All instances of it to 'D5'

Related article: Find-or-replace-text-and-numbers-on-a-worksheet

In case you need more help, don't hesitate to let us know.

Hey there.  

This doesn't accomplish my result as I'm pretty advanced in Excel and easily know how to do that.  I'd like to change every existing result in my submissions, and then match them with my future submissions so I can export the doc or display the form results dynamically on our webpage.

Is there anyway to import submissions?  So I'd change them in Excel, delete all the existing submissions on Jotform, then import them from Excel into Jotform.

Thanks.

Yes there is a way to import submissions. You can use the import app: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm