Import & Export

Overview

Sutido provides several ways to move data between your MongoDB database and other formats. Export query results for reporting, or copy data to the clipboard for use in other applications.

Exporting Data

Copy to Clipboard

The fastest way to export small amounts of data:

Copy Single Cell

In Table View, click a cell and press Ctrl+C to copy its value. The value is copied in its appropriate format (string, number, JSON for objects/arrays).

Copy Rows

Select one or more rows and press Ctrl+C to copy them as formatted JSON. Use Shift+click for range selection or Ctrl+click for multi-select.

Copy Column

Right-click a column header to copy all values in that column. Values are joined with newlines, making it easy to paste into spreadsheets.

Export Formats

Data is exported in these formats:

Data Type	Export Format
Strings	Plain text
Numbers	Numeric string
Booleans	true or false
ObjectId	ObjectId("...")
Dates	ISO 8601 string
Objects/Arrays	Indented JSON
Null	null

Importing Data

Import via Insert Queries

The most flexible way to import data is using insertMany():

db.users.insertMany([
  { name: "Alice", email: "alice@example.com" },
  { name: "Bob", email: "bob@example.com" },
  { name: "Carol", email: "carol@example.com" }
])

Importing from JSON

If you have JSON data from another source, paste it directly into an insert query:

1. Copy your JSON array of documents
2. Type db.collection.insertMany(
3. Paste your JSON array
4. Add the closing )
5. Execute the query

Snippets and History Export

Exporting Snippets

Your saved query snippets can be copied using the copy button in the Snippets panel. This copies the query text to your clipboard.

Exporting History

Query history entries can also be copied for documentation or sharing. Click the copy button next to any history item.

Connection String Import

Import connection settings from a MongoDB URI:

1. Click "New Connection"
2. Select the "URI" tab
3. Paste your connection string
4. Sutido parses the URI and fills in the connection form

Sutido extracts from the URI:

• Host and port
• Username and password
• Database name
• Authentication database
• Replica set configuration
• Connection options

Bulk Operations

For large imports, use bulkWrite() for better performance:

db.products.bulkWrite([
  { insertOne: { document: { name: "Product A", price: 10 } } },
  { insertOne: { document: { name: "Product B", price: 20 } } },
  { updateOne: {
    filter: { name: "Product C" },
    update: { $set: { price: 30 } },
    upsert: true
  }}
])

Data Persistence

Sutido stores your snippets and query history locally in a SQLite database. This data persists across application restarts but stays on your machine—nothing is synced to the cloud.

Next Steps

Learn about connection string formats.