Export my data into excel, but instead of rows in columms

  • Profile Image
    Asked on September 16, 2013 at 08:34 PM

    Hi Jotform Support,

    I've a problem in, when I export my information data into excel spreadsheet it only appears a part of it. This situation is duo the spreadsheet limits, it's only accepted 256 Columns per sheet and the data survey is   quite large.

    So to solve this problem I wonder if it's possible to invert the order of how the information is disposed. Thus, instead of exporting my data into excel columns I what to export into excel rows. I believe, with this situation is already possible to solve the problem of the limits of excel columns.


    Best Regards

  • Profile Image
    Answered on September 17, 2013 at 01:03 AM


    That's not possible with Jotform reports, we do not have such option. However, I think this is possible with MS Excel. I've made a quick search and found this "transpose", this might help: http://office.microsoft.com/en-us/excel-help/rotate-data-by-converting-columns-to-rows-or-vice-versa-HP005203138.aspx

    You can also try it with CSV and open your data to CSV programs that might support more than 256, you can try this one: http://www.csvviewer.com/

    By the way, what excel version are you using? According to MS Excel 2007 spec, it supports up to 16,384 columns. May I suggest to try it with this one first after you download your excel file.

    Hope this helps. Regards!