Open a large csv file
Solved
thetcha
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
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 réponses
Hello,
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.
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.
In 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.
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.
Or 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.
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.
it's difficult to put formulas or macros in a CSV....
eric