I am trying to export data from Salesforce through dataloader command line interface. I have integrated dataloader command line interface with ANT for extracting records. When i try to extract more than 1 million rows, i am unable to view the csv file with more than 1 million records. Kindly suggest an alternative.

Thank you in advance.

  • 1
    what do you mean "unable to open csv" ?
    – kurunve
    Jul 28, 2016 at 14:36
  • would rephrase my question then -- what do you mean by "unable to open"?
    – kurunve
    Jul 28, 2016 at 14:55
  • are you trying to open with Excel? with Notepad++ ? with what?
    – cropredy
    Jul 28, 2016 at 15:00

2 Answers 2


There is a limit in csv to open more than 1 million.

My suggestion would be to split the exporting based on some condition so that you wouldnt cross 1million.


We are using dataloader as well to extract more than one million record reports from sfdc into csv files. We are using MS Access to process the data afterwards without any problem. You just have to import the csv into Access and it will show all the rows.

Cheers, Krisz

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.