Excel does not open large file

Question

I am trying to open a CSV file in Excel 2013 but nothing really happens. Excel is just opening without anything visible (just the gray background as you have just closed a workbook).

The CSV file is 2.7GB. I have no idea how many rows that could be, the columns are 30.

I have seen similar problems with quite smaller files which still doesn't open. No solutions so far...

Thanks :)

Answer 1

For info, these are the limits for Excel 2013, so it looks like you will need to split your input file and examine it in sections - that's especially true if you are on 32-bit because Excel expects to have only 500 - 700 Mb free for data in a 2GB address space.

If it helps, Google found the Large Text File Viewer, which may be a useful alternative.