Import

MongoQUI University

Import Section

MongoQUI allows users to import data from CSV, Excel, or JSON files directly into MongoDB collections with full support for mapping, type detection, and previewing before importing.

Import Type Selection

MongoQUI supports three main types of data import:

CSV Import

  • Import data from CSV files.
  • Support for various delimiters: comma, tab, semicolon, pipe, colon, space.
  • Field type detection and custom field mapping.

ImportData

Excel Import

  • Import data from various Excel file formats.
  • Field type detection and custom field mapping.

Excelimport

JSON Import

  • Import data from JSON files.
  • Nested document support.
  • Array handling.
  • EJSON compatibility.

jsonimport

Import Configuration Options

  • Collection Name: Enter the target MongoDB collection.
  • Delimiter: (CSV only) Choose delimiter.
  • Insert Mode: Overwrite existing, skip existing, create new, or merge existing documents.
  • JSON Type: (JSON only) Choose between Document array, Single document, or JSON Lines.
  • File Selection: Upload or drag and drop your file.