Link to home
Start Free TrialLog in
Avatar of srobtjones
srobtjones

asked on

1.4GB file - how to view as spreadsheet or best viewer for this file

I have a 1.4GB (approx) file which consists of text.  It was originally saved as .xls, but excel cannot open it all. Even as a .csv file, excel pukes when trying to open it. Here is a list of apps and extensions I've tried to open this file but have failed:

App - Extensions

Excel - .xls, .csv
Notepad - .txt

Wordpad opens it, but bogs down and gets very slow.

Can someone recommend a shareware/freeware/MS app or other method of opening, viewing, and manipulating this file? I would love to be able to break it down into smaller files and/or to view it/them in spreadsheet format.

Thanks,

Scott
Avatar of jayca
jayca

PAQ- https://www.experts-exchange.com/questions/20958162/Large-excel-file-won't-fully-open.html
"What I think what happens is that it is still opening the workbook but is also autmatically calculating the formula's in the workbook.
you might try to open it with manual calculation turned on.

tools>>options>>calculations tab : manual calculation

are there also external references to other files in the workbook? And are there some macro's running?"

Avatar of srobtjones

ASKER

this is strictly text - there are NO formulas in the spreadsheet at all. The spreadsheet consists of txt data output from another program.  
1. where did this file orignate from , is it using the same version  , and same
excel program , when it first was created.

2. how much ram do you have. ram can help you if it actually is a excell sheet
and his opened before it got to big. also it its text , that a lot of text to load into ram.
you have to have a lot of ram and add more virtual memory.

3. whats the size of your page file ,or virtual memory. by increasing it
it will help you.

4. what os are you running.

5. i know of file splitters , but not the kind your ask for , if it was
all text maybe , but if it is a excel sheet , it would not understand
what it is when split.

it may have to be a specific excel splitter program , which i dont think exist.

6. heres an excel viewer program from ms
http://support.microsoft.com/default.aspx?scid=kb;en-us;273711

7. have you ever opened the file ,  if you did it was probably when the file
was small.

8. heres a splitter that says it will split files by lines txt.

http://www.clickok.co.uk/filesplit/
1. where did this file orignate from , is it using the same version  , and same
excel program , when it first was created.

The file data was exported from a computer forensics program called EnCase into a .xls format.  I have since renamed it with both .csv and .txt extensions.

2. how much ram do you have. ram can help you if it actually is a excell sheet
and his opened before it got to big. also it its text , that a lot of text to load into ram.
you have to have a lot of ram and add more virtual memory.

1GB DDR RAM

3. whats the size of your page file ,or virtual memory. by increasing it
it will help you.

Not sure - will have to check. How to?

4. what os are you running.

Windows XP pro

5. i know of file splitters , but not the kind your ask for , if it was
all text maybe , but if it is a excel sheet , it would not understand
what it is when split.

it may have to be a specific excel splitter program , which i dont think exist.

6. heres an excel viewer program from ms
http://support.microsoft.com/default.aspx?scid=kb;en-us;273711

7. have you ever opened the file ,  if you did it was probably when the file
was small.

I have opened it in excel, but excel pukes out after 65k rows, so not all data is present. I have tried to bring it into Access, but access loses column header/title info and seems to have layout format problems.

8. heres a splitter that says it will split files by lines txt.

http://www.clickok.co.uk/filesplit/
Hi Scott,

Excel has a 65K row limitation and the max row number cannot be increased. So Excel is not a solution here.
How many rows are you expecting? 100ks, 1Ms, more?

You say you have problems importing in Access. How did you try to import the data?
How is you file organized? data separator? Extra information at top of file before header names?

Regards,
Sebastien
If it is straight text try Ultraedit, we have some programmers using it and it works great on large files.

 http://www.ultraedit.com/
Solutions:


1. Re-export it to the Access as data table as sebastien said. You can also arrange on spreadsheet form as you have told on Access.
To do this,(you can also) in Access, import data table and check spread sheet view  and set tab or any spacing character to set to spreadsheet view.

2. Open and edit on Ultraedit as RDAdams said.

3. Text pad is the best solution since it is the powerful tool/platform for all of size and type of files. In my experience, Text pad is the best solution for you.

http://www.textpad.com/

ASKER CERTIFIED SOLUTION
Avatar of King_Diamond
King_Diamond

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial