Import Wizard

With Studio 3T, carry out your MongoDB import tasks without having to type a single command line in the following formats: JSON, CSV, BSON/mongodump, SQL, and another collection.

Looking to export, not import? View the Export Wizard documentation.

Supported import formats

Studio 3T supports the following import file types:

  • JSON
  • CSV
  • BSON/mongodump

Additionally, data can be imported from:

  • A SQL database
  • Another collection

Ready to start your MongoDB import? Download Studio 3T here

Open the Import Wizard

After successfully connecting to a MongoDB database, there are two ways to open the Import Wizard:

  • Click on Import in the Global Toolbar or
  • Right-click on any server, database, or collection and choose Import

Are you also looking for an easier way to export data from MongoDB? Try Studio 3T’s Export Wizard which supports the same formats: CSV, JSON, BSON/mongodump, SQL, and another collection.

Import JSON to MongoDB

  1.  With the import wizard open, tick the JSON box as the chosen import format.
  2.  The next screen allows for one or multiple JSON files to be imported. Click on to upload documents, – to remove them, and the clipboard icon to paste data from the clipboard. Studio 3T can validate JSON before import, but note that clipboard data cannot be validated before import.
  3. Under the Target Database, Target Collection, and Insertion Mode columns, double-click on a cell to select the appropriate database or collection, and define the insertion settings for the documents.
  4. Click Next. Studio 3T will show a preview of what the server will look like after import.
  5. The last screen will show an Import Summary and is the last chance to make edits.
  6. Once everything looks good, click Start import.

Import CSV to MongoDB (e.g. Excel)

  1. Choose CSV in the import wizard and click next.
  2. Here, specify the file to be imported as well as the import specifications.
  3. The next step is to choose desired delimiters and text qualifiers, then click Next.
  4. Choose the right CSV options and click Next

    If you’re unsure about an option, click on the handy Info button next to each option.

  5. All that is left now is to review the summary of what the new server will look like after the import is complete.
  6. Finally, begin the import.

Supported date formats

CSV import supports eight date formats:

  • ISO
  • Locale
  • MDY
  • DMY
  • YMD
  • MYD
  • DYM
  • YDM

The date format XXX supports all order variations of the year, month, and day fields, as well as three separators: “-“, “/” and “.”

Both ISO and Locale formats accept their respective variations like date only, date with short or long time, etc.

Upon CSV import, Studio 3T will try to detect a suitable date format for all the values of a column and will automatically use one based on the following criteria:

  • The above date formats are tested in the given order with all the values of a column/field
  • The first format to match all values is selected as suggested date type for the field or column

But of course, as with all data types, the selection can always be overriden.

Download Studio 3T to start your CSV import to MongoDB.

Import BSON/mongodump to MongoDB

  1. Open the import wizard and choose between BSON – mongodump folder or BSON – mongodump archive and click Next.

    Regardless of the option chosen, a ‘mongorestore’ executable will have to be accessible for this type of import to operate.

  2. Choose the mongodump folder or archive file to import and click Next. Make sure sure the mongodump folder doesn’t have any compressed files.
  3. If importing a folder: Choose the databases and collections to import, if applicable. If importing an archive file, jump to Step 5.
  4. A preview of what your server will look like after the import will appear. Click Next.
  5. Choose the mongorestore options and click Next.
  6. Review the import summary and click Start Import.

Import SQL to MongoDB

 

  1. Choose SQL Database in the import wizard.
  2. Here, connect to the SQL server, choose the SQL table and the target database, target collection, and import mode. Then, click Next.
  3. Define the import settings as needed in the Configure SQL Columns Import screen, then click Next.
  4. Preview the import, then click Next.
  5. Click Start Import.

SQL Import to MongoDB is a Pro and Enterprise feature. Learn more about the different Studio 3T editions.

Studio 3T supports all the major SQL databases: Oracle (Enterprise version only), Microsoft SQL Server, MySQL, and PostgreSQL.

Import another collection

  1. Open the import wizard and choose Another Collection.
  2. Then choose the location of the desired collection.
  3. Choose the target database and collection and decide how Studio 3T should deal with duplicate documents.
  4. Preview the server and read the import summary.
  5. Once everything looks good, start the import!

Want other time-saving features? Make sure to check these out:

  • Export Wizard – Export entire MongoDB collections and views, query results, or specific documents to CSV, JSON, BSON/mongodump, SQL or another collection
  • Aggregation Editor – Build MongoDB aggregation queries stage by stage
  • Query Code – Generate driver code in Java, JavaScript (Node.js), PHP, C#, and Python from MongoDB and SQL queries
  • IntelliShell – Studio 3T’s built-in mongo shell with robust autocompletion

Updated on February 11, 2019

Was this article helpful?

Related Articles