Open a large csv file
Solved
Hello,
I would like to know if it is possible to open a 1 GB csv file?? Or is it impossible to open??
If I manage to open it, will the software be able to display everything??
Thank you in advance.
I would like to know if it is possible to open a 1 GB csv file?? Or is it impossible to open??
If I manage to open it, will the software be able to display everything??
Thank you in advance.
6 answers
-
Security ContributorHello,
I confirm, no problem displaying everything in this type of file.
However, be careful if there are macros or nested calculations. In case of modifications, processing can be very slow; you need to remember to temporarily turn off Excel's automatic calculation:
Office button/Excel options/formula tab/uncheck automatic for manual
Best regards
I sent an angel to protect you but... he came back to tell me he couldn't watch over another. -
ContributorHello,
1GB is not too much, so you can try it, and normally the file will display everything.
Have a nice day
MrIstar -
And which software can I use to open it? Thank you.
-
ContributorIn Excel, you will be limited by the number of rows and columns depending on your version.
65,536 rows and 256 columns in Excel 2003, much more in 2007 and later versions.
You have the Libre Office suite for free.
Eric
You will never respond to an unsolicited private message...
Well, that's done. -
Security ContributorOr just simply a NotePad:
https://www.commentcamarche.net/telecharger/developpement/16295-notepad/#q=Notepad%2B%2B&cur=1&url=%2F
In my opinion, it's simpler and more readable for searching for information.
--
I sent an angel to protect you but ... he came back to tell me he couldn't watch over another. -
Perfect, thank you :) Notepad is great!