Take the 2-minute tour ×
Software Recommendations Stack Exchange is a question and answer site for people seeking specific software recommendations. It's 100% free, no registration required.

I have a data file with 14 columns and 9,523,125 rows.

What online spreadsheet program (NOT A DATABASE!) can handle at least 9,523,125 rows?

share|improve this question
1  
Do you care about pricing? –  Nick Wilde Jul 22 at 18:06
    
I would prefer free. –  user3503704 Jul 22 at 18:07
2  
Are you just listing data or do you need to do operations on it? If so what operations do you need? Sorting? formulas? –  Nick Wilde Jul 22 at 19:34
1  
I need to sort the first and second columns from smallest to largest. –  user3503704 Jul 22 at 19:36
    
You really need a webapp? Not an installable program? –  Nicolas Raoul Jul 23 at 8:38

4 Answers 4

You can use PowerPivot:

enter image description here

share|improve this answer

You can use Delimit:

  • offline and non-free (50 USD)
  • 64-bit Windows 8.1, 8, or 7
  • Open data files up to 2 billion rows and 2 million columns large
  • Open large delimited data files; 100's of MBs or GBs in size

enter image description here

More features:

  • Quickly open any delimited data file.
  • Edit any cell.
  • Easily convert files from one delimiter to another like
  • CSV to TAB.
  • Split-up any delimited file into file parts of equal size.
  • Join multiple delimited files into one resulting file.
  • Quickly select which columns to extract and in which order.
  • Extract data from any delimited file by specifying the columns,
  • rows and/or filter to apply.
  • Sort any delimited data file based on cell content.
  • Remove duplicate rows based on user specified columns.
  • Bookmark any cell for quick subsequent access.
  • Open large delimited data files; 100's of MBs or GBs in size!
  • Open data files up to 2 billion rows and 2 million columns large!
  • Work with: character delimited, string delimited, fixed column width or just plain text files.
  • Quickly see all your bookmarks, double-click to jump to any of them or click to rename.
  • Keep track of long running operations.
  • Keep track of the current selection.
  • Scroll to any part of the file or split the view into multiple panes.
  • Freeze the 1st row of any file.
  • Open multiple files and quickly switch between them.
  • Configure built-in and custom file delimitation rules for automatic parsing of files.
share|improve this answer

If you must you could give pySpread a go - it is not online but can handle up to 80 000 000 rows subject to possible memory limitations.

Alternatively you could look at Python + Pandas - the combination is very good for dealing with large data sets.

All the above are free and cross platform, just not online.

share|improve this answer
    
Are there any others? –  user3503704 Jul 22 at 18:49
1  
@user3503704 Is off-line OK? (I'm pretty sure you won't find anything online) –  Franck Dernoncourt Jul 22 at 20:52

You can try: OpenRefine. Free. Should handle such data-sizes.

share|improve this answer

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.