Importing and exporting MongoDB data can be a tedious task, especially when done from a standard command line interface. Studio 3T is a MongoDB GUI that boasts time-saving import and export features – which our users love – and supports various file formats, so you never have to type a single command line to get the job done.

In this post, we’ll walk you through the MongoDB import and export features of Studio 3T Core.

Supported Import Formats

Studio 3T supports the following formats:

The first step, of course, is to download the latest version of Studio 3T, and prepare your files for import. Looking to export MongoDB data? Jump ahead to the Export chapter.

Import JSON to MongoDB

  1. Right-click on any server, database, or collection and choose Import Data.
    Alternatively, click on the Import button on the toolbar.
    Two ways to import data in Studio 3T
  2. Choose JSON.
  3. Click on to upload documents, – to remove them, and the clipboard icon to paste data from the clipboard.
    You can also Validate JSON before import, but note that clipboard data cannot be validated before import.
    JSON import options on Studio 3T
  4. Click Next.
  5. You’ll then see a preview of what your server will look like after the import. Click Next.Preview of your server after the JSON import
  6. This is your last chance to make edits! Review the import summary and if everything looks good, click Start Import.Summary of JSON import on Studio 3T
  7. You can always monitor the status of your import in the Operations window on the bottom-left corner.Check the status of your Studio 3T JSON import

Import CSV (e.g. Excel) to MongoDB

  1. Right-click on any server, database, or collection and choose Import Data.
    Alternatively, click on the Import button on the toolbar.
  2. Choose CSV.
  3. Choose your CSV file location and edit the settings the needed. Click Next.
    Edit the CSV import settings
  4. Choose your desired delimiters and text qualifiers and click Next.Choose the correct delimiters and other settings
  5. Choose the right CSV options and click Next. (Hint: If you’re unsure about an option, click on the handy info button.)Choose the appropriate CSV options
  6. Review the summary of what your server will look like after the import.Summary of what your server will look like after the CSV import
  7. Review the CSV import summary. Once done, click Start Import.

Import to BSON/mongodump

  1. Right-click on any server, database, or collection. Alternatively, click on the Import button on the toolbar.
  2. Choose between BSON – mongodump folder or BSON – mongodump archive and click Next.Studio 3T has two BSON import options to MongoDB
  3. Choose the mongodump folder or archive file to import and click Next.
    (Hint: Make sure your mongodump folder doesn’t have any compressed files.)
  4. If importing a folder, choose the databases and collections to import, if applicable.
    If importing an archive file, jump to Step 6.
    Choose the databases and collections from the mongodump folder
  5. You will then see a preview of what your server will look like after the import. Click Next.
  6. Choose the mongorestore options and click Next.Choose your BSON import mongorestore options
  7. Review the import summary and click Start Import.

Supported Export Formats

Studio 3T supports the following formats:

Export MongoDB to JSON

  1. Right-click on any server, database, or collection and choose Export (Data, Collection, etc.).
    Alternatively, click on the Export button on the toolbar.
    Export to JSON options on Studio 3T
  2. Choose JSON and click Next.
  3. Choose between two JSON export options. JSON – mongo shell / Studio 3T exports a collection to a rich, type-conserving collection.json file. JSON – mongoexport produces a JSON format that the mongoexport tool generates. Click Next.Choose between two JSON export options
  4. Choose the export target file destination and click Next.
  5. Review the export summary and click Start Export.

Export MongoDB to CSV (e.g. Excel)

  1. Right-click on any server, database, or collection and choose Export (Data, Collection, etc.).
    Alternatively, click on the Export button on the toolbar.
  2. Choose CSV.
  3. Choose your CSV format options and click Next.
    Choose your CSV format options for export
  4. Choose the fields you want to export and click Next.Choose the MongoDB fields you want to export to CSV
  5. Choose the target file destination for the export and click Next.
  6. Review the Export Summary and click Start Export.

Export MongoDB to BSON/mongodump

  1. Right-click on any server, database, or collection and choose Export (Data, Collection, etc.).
    Alternatively, click on the Export button on the toolbar.
  2. Choose between two export options: BSON – mongodump folder or BSON – mongodump archive.Choose between two BSON/mongodump export options
  3. Select the export target folder or archive file.
  4. Review the Export Summary and click Start Export.

In addition to these import and export features, Studio 3T also supports import from and export to SQL, a popular Studio 3T Pro feature. Check out how easy it is to export MongoDB data to SQL and learn more about other time-saving Pro features here.