combine submissions into a single data

  • fvhsurvey
    Asked on May 18, 2021 at 4:04 AM
    I want to have data from all forms for data analysis. However, in Jotform I just could export each form in terms of an individual Excel file, and then I have to combine all Excel files to make general data for all forms. Do you have any way that exports a single Excel file with all data of all forms? Thank you
  • Richie JotForm Support
    Replied on May 18, 2021 at 4:12 AM

    It is possible to combine your submissions into a single CSV files.

    Here is a link https://www.jotform.com/integrations/combine-submissions

    Please check it out and let us know if this fits your requirements.

  • fvhsurvey
    Replied on May 18, 2021 at 10:59 PM

    Thank, Richie. The app is what I need to. However when I export the data into the CSV the file will be like below

    1621393053 60a47e9ddd99e  Screenshot 10

    In our form we used both Vietnamese and English, therefore it's look like that the csv file could not display Vietnamese parts.

    Would you have any solution for that? Thank you, Richie

  • John Support Team Lead
    Replied on May 19, 2021 at 1:41 AM

    I have tried downloading your form submissions into a CSV file and it shows fine here:

    1621402893 60a4a50d1b30e  Screenshot 10

    So I think the issue is with your Excel software's encoding option. You may want to check this guide I found online on how to fix it: https://tipsmake.com/how-to-fix-vietnamese-error-when-opening-csv-file-in-excel

  • fvhsurvey
    Replied on May 20, 2021 at 3:26 AM

    It's worked JohnRex. Thank you so much, JohnRex.