Excel does not open large file

excel file csv excel-2013
Pepys picture Pepys · Nov 26, 2013 · Viewed 49.5k times · Source

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

Roger Rowland picture Roger Rowland · Nov 26, 2013

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.

Related questions

Python convert csv to xlsx

In this post there is a Python example to convert from csv to xls. However, my file has more than 65536 rows so xls does not work. If I name the file xlsx it doesnt make a difference. Is there a …

Read More
VBA check if file exists

I have this code. It is supposed to check if a file exists and open it if it does. It does work if the file exists, and if it doesn't, however, whenever I leave the textbox blank and click the …

Read More
How do I Replace a String in a Line of a Text File Using FileSystemObject in VBA?

I am trying to use FileSystemObject methods to find a specific line in a text file, and within that line replace a specific string. I am relatively new to this, as my current code has excel open the text file …

Read More