How can I paste submission data to Excel so it won't spread in to two cells?

  • Profile Image
    jbefooty
    Asked on December 01, 2017 at 12:46 PM

    I have been using Jotform for over a year but this week my form submissions when pasted on to my Excel spreadsheet do not fit and where I have for example West Ham in one cell Jotform now puts that in to two cells. I have checked previous forms I have done and same thing is happening Has something changed or am I missing something??

  • Profile Image
    Jim_R
    Answered on December 01, 2017 at 02:40 PM

    From how you described it, you're having issues pasting values to your Excel Sheet. Have you tried pasting it in plain text? Like, pasting text from your clipboard using CTRL+SHIFT+V instead of the usual CTRL+V.

    Have you also tried pressing F2 on a cell first prior to pasting? With this approach, there is no way for your paste to spread to another cell.

    Related article: https://support.office.com/en-us/article/Edit-cell-contents

    While we're at it, I'm concerned why this process has to be done manually. In case you're not aware, you can export your submission data into XLS or CSV format.

    Complete guide: How-to-Download-Form-Submissions-as-Excel-CSV-PDF