Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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|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.

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. :) – 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:


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

Try this:


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

Your Answer


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.