download free 30 days trial version buy bucket explorer
Documentation  Download  Purchase  Support  FAQs   Forum   ScreenShots & Demos

How to Export details of Amazon S3 Objects to CSV

You can export whole bucket or selected object details from the bucket at your local system in CSV format. This feature includes object details as “Size of File, Last Modification date of file, ETAG of file and Name of file” to export. This feature also provides the facility to distinguish all exported fields by enclosing them with desired character or by selecting the terminate character(separator) for particular field.

Follow the steps below to export details of entire objects within a bucket using Export to CSV

  1. Run Bucket Explorer.
  2. Select a bucket from bucket table.
  3. Right click on bucket and select "Export to CSV" or select “Advanced” -> "Export to CSV" option from Bucket tool bar.
  4. This will open “Export to CSV” window. Set the fields as per your requirement.
    • Give any character/string in "Terminated By" text field by which you want to terminate (separate) the selected fields.
    • Enter a sequence of characters or single character in "Enclosed By" text field with which each field value will be enclosed.
    • Select Fields which you want to export from File Name, File Size, Etag and Last Modified Date .
    • Select a path where you want to save the exported CSV file and give the desired name for the file.
    • Now click on Export button.
  5. Selected fields of all the objects in your bucket have been exported at local machine.

Follow the steps below to export specific object(s) details Using Export to CSV

  1. Run Bucket Explorer.
  2. Select a bucket from bucket table.
  3. Select some object(s) from object table.
  4. Do Right click on the selected objects and select "Export to CSV" OR select “Advanced” -> "Export to CSV" option from object tool bar.
  5. This will open “Export to CSV” window. Set the fields as per your requirement
    • Give any character/string in "Terminated By" text field by which you want to terminate (separate) the selected fields.
    • Enter a sequence of characters or single character in "Enclosed By" text field with which each field value will be enclosed.
    • Select fields which you want to export from File Name, File Size, Etag and Last Modified Date .
    • Select a path where you want to save the exported CSV file and give the desired name for the file.
    • Now click on “Export” button.
  6. Selected fields of object(s) have been exported at your local machine.


 

Give us your feedback