How to retrieve 5 million documents from SharePoint site with metadata and export it to csv using PowerShell?

Question

I have SharePoint site where almost 200000 documents are there and I want retrieve all of the files from that particular SharePoint Site along with metadata. And after getting the data I need to export the files into csv.

Answer 1

Hi Sayantan,
  I am a bit confused. Do you need to export 200k documents or 5 M?
  What metadata do you need? only system metadata like modified, modifiedby, size etc.. or also custom metadata like projectID?
  Do you need versions or only the last version?
  Why do you need to export the files into csv? or do you need  a csv file with a list with all files?

Do you also need to cater for very large files? e.g. 10's of GB's