- INOVATECAsked 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.
- JotForm SupportEltonCrisAnswered 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!