Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migration rejected from superuser.com Mar 4 at 5:04

This question came from our site for computer enthusiasts and power users. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Rubén, jonsca Mar 4 at 5:04

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking for us to recommend or find a Web Application are off-topic and out of scope, as they tend to attract opinionated answers and spam. However, your question may be on topic at Software Recommendations if you can rewrite it so that it meets their quality guidelines" – Rubén, jonsca
If this question can be reworded to fit the rules in the help center, please edit the question.

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
    
Well done, dude. Cool solution. :) – cregox Mar 7 '14 at 14:12

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

Try this:

http://www.enterprisesheet.com

It allows you to upload more than 256 columns.

share
    
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. – codingbadger Jul 27 '12 at 7:44

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