What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by INOVATEC 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

    excel rows survey JotForm problem
  • Profile Image
    JotForm Support

    Answered by EltonCris on September 17, 2013 at 01:03 AM

    Hi,

    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!