View original (French)

Open a large csv file

Solved
thetcha -  
eriiic Posted messages 24581 Registration date   Status Contributor 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.

6 answers

  1.
    dyllan Posted messages 5577 Status Security Contributor 918
     
    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.
    1
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      it's difficult to put formulas or macros in a CSV....
      eric
      0
    2. dyllan Posted messages 5577 Status Security Contributor 918
       
      Exactly :D well spotted! I went straight to Excel... why..? :/!?
      0
  2. MrIstar Posted messages 281 Registration date   Status Contributor Last intervention   42
     
    Hello,

    1GB is not too much, so you can try it, and normally the file will display everything.

    Have a nice day

    MrIstar
    0
    1. thetcha
       
      And with what software can I open it? Thank you.
      0
  3. thetcha
     
    And which software can I use to open it? Thank you.
    0
  4. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    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.
    0
  7. thetcha
     
    Perfect, thank you :) Notepad is great!
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      A .csv is a data file.
      It will be much more readable and will allow for much more manipulation (filters, sorting, ...) in a spreadsheet.
      eric
      0