Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a CSV file with 1 column for each day of the year, obviously giving me greater than the 256 column limit that stops me from importing it into a Google Docs spreadsheet. Is there any online app (or transpose tool for that matter) that would get me around this?

share|improve this question

migrated from superuser.com Jul 22 '12 at 1:37

This question came from our site for computer enthusiasts and power users.

add comment

3 Answers 3

With the new Google Spreadsheet, you are able to add more than 256 columns.

To test this, I added this formula in A1:

=TRANSPOSE(REPT("A,", 367))

and continued with this formula in A2

=SPLIT(A1, ",")

It will raise an error, telling you to add more columns (it will add 300 as a standard): enter image description here

Once added, the split result will expand and show all the data in the 367 columns.

share|improve this answer
add comment

Try this:

http://www.enterprisesheet.com

It allows you to upload more than 256 columns.

share|improve this answer
    
Please can you elaborate on this web application. Maybe provide a bit more information about it? You should also state if you are affiliated with this product. –  Barry Jul 27 '12 at 7:44
add comment
up vote 1 down vote accepted

So as I was saying...

I couldn't find anything that would let me do this that didn't involve installing a full spreadsheet app so I created a simple CSV transposition tool on app engine:

CSV Transposer Tool

share|improve this answer
    
Well done, dude. Cool solution. :) –  Cawas Mar 7 at 14:12
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.