Different formatting when copy and pasting when submissions are downloaded as CSV file

  • Profile Image
    Asked on June 21, 2016 at 11:20 AM

    I have another question and hope I can explain it.

    We had a form last year called Photo Entry Contest Form.

    When I export the data from the entries to this form as a CSV file and open in Xcell and save as a .txt file, then copy the info into a text editor, highlight the text and remove formating, all the fields show as a hard return.






    This was a live (published) report and I can use that data to import into In Design and send to printer.


    When I do the same thing with the Clone of Clone of Workshop Sponsor form (preview and fill in the form and click enter), export report as CSV, save as a .txt file and copy and paste into the text editor, highlight all, remove formating, all the info disappears.

    What I notice is that even though I seem to have done everything the same in exporting, etc, when I copy from the .txt file in xcell, the fields paste differently into the text editor (the Photo form as cells and the other as a row).

    What I am wondering is if the published form and the preview form return different info so that an export would format differently.

  • Profile Image
    Answered on June 21, 2016 at 12:06 PM

    I am not entirely sure what you meant here, if you could provide us some screenshots to better understand, that would help.

    I am also not sure about the app Xcell? Are you perhaps referring to Microsoft Excel? May I know what you are doing copy pasting and formatting on a repetitive process? It would be easier for us to understand if we know the reason.

    Also, the old form you previously mentioned might have different types of input, like widgets, etc... that holds the submission data, if they are completely different from the new form that you have, then it is possible that they will have different formatting when exported as an excel/CSV file.

    We'll wait for your response.

  • Profile Image
    Answered on June 22, 2016 at 09:00 AM

    This is how the text looks when copied from MS Excel into a text editor from the jot form that has been published and then the report exported as CSV file.

    When I remove the formatting each cell stacks on top of one another and I get this.

    6/2/15 0:14
    2887 Highway UU
    United States
    (417) 9876340
    Midnight Oasis
    Spray Paint on Poster Board
    11" x 14"


    Which I can save and import into InDesign.


    The form which has not been published yet but filled out in preview and submitted and then a report made in CSV format and copied from Excel and pasted into text editor looks like this:

    When highlighted and turned into plain text (to remove formating), the text disappears.

    Can't figure out what is happening.

    This is important for me to figure out as form will go to 50 organizations to fill out and submit about 500 workshops. My aim is to not have to type anything.

    Thanks for your understanding and patience.

  • Profile Image
    Answered on June 22, 2016 at 10:31 AM

    I am not entirely sure if this is a JotForm related issue. The application that you are using, especially the formatting tool is actually one of the main factor as to why the text is being formatted like that. 

    From the looks of the screenshot, I am not sure if you are using a text editor, is that an MS Excel application? It actually looks different but it seems like a spreadsheet editor also. 

    Is this the "Clear Format" you were referring to? If you are using MS Excel?


    Please note that we do not have control on how the application will handle this contents. This is mostly related on their end and not on JotForm. They might have got a new update and resulted to this. 

    The only way I can see this is find another formatting function or have a custom script or formula in MS Excel to have your data formatted the way you like it to.