Spreadsheet widget - Separate data into each own cells when exported to Excel

  • Profile Image
    CEAExecutive
    Asked on April 01, 2020 at 09:04 PM

    It is not allowing me to take this list and just get the names of all the delegates in alpha order. It is a big mess of names. I have tried to follow the steps but it still gives them to me just as the screen shot I sent to you. I just want last names and first names in alpha on one vertical list



    This is a re-post of a comment on How to Download Form Submissions as Excel/CSV/PDF

  • Profile Image
    JohnRex
    Answered on April 02, 2020 at 12:15 AM

    If you're referring to this form: 2020 Reporting form for Local Delegates and Alternates to the 2020 Delegate Assembly , I can see that you have used SPREADSHEET widget to capture the names:

    15858007122238129.png

    Note that this widget's data is being added to the submission as a single field. So when you export it to Excel, you'll see that all the data in this table is placed on a single cell.

    You can try using Excel functions to separate the data into different cells. Though this might be a bit tedious, you can try this method: Text-To-Columns-Excel