Collection name can only contain letters, numbers, and underscores
Uploading...
Collections
-
Database
0
Collections
đ Data Preview
Collection:-
Total Records:-
Showing:-
Detecting sheets and analyzing file...
Export Data
Collection:-
Total Records:-
Records to Export:-
Date Range Filter
Filter records by date fields (optional)
Additional Field Filters
?
How to use filters:
Click "Add Field Filter" to create a new filter
Select a field from the dropdown (e.g., "Product Name")
Enter the text to search for (partial matches work)
The filter uses "contains" - it finds all records where the field includes your search text
Multiple filters work with AND logic - all conditions must match
Example: Field: "Customer" + Value: "John" will find all records where Customer contains "John" (matches "John Smith", "Johnson", etc.)
0 / 3
Filter by any field from your collection (max 3 filters)
âšī¸
Export will include all data or filtered by date range if specified.
Confirm Upload
File Name:-
File Size:-
File Type:-
đĄ Tip: "Sheet2" will select the 2nd sheet even if it has a different name
đ Use this when your data has title rows or metadata before headers
Target Collection:-
â ī¸
New records will be added to the collection. Existing data will be preserved.
â
Delete Collection
â
This action is permanent and cannot be undone!
You are about to delete the collection:
All documents and data in this collection will be permanently deleted.
â
Collection name does not match
đ Connect to R Studio
Quick Start Guide
Install the mongolite package in R Studio (one-time setup)
Copy the connection code and replace the collection/database names
Run the code to load your data into a dataframe
Use standard R operations for analysis and visualization
Follow these steps to connect R to your MongoDB collection:
Install Package
install.packages("mongolite")
Connection Code
library(mongolite)
# Connect to MongoDB
collection <- mongo(
collection = "your_collection",
db = "excel_data",
url = "mongodb://34.101.91.132:27017"
)
# Read data
df <- collection$find()
# View data
head(df)
đĄ Pro Tips:
For remote connections, update the URL to: mongodb://username:password@host:port
Use collection$find('{"field": "value"}') to filter data
Export results with write.csv(df, "output.csv")
Common Operations:
âĸ collection$count() - Get total records
âĸ collection$distinct("fieldname") - Get unique values
âĸ collection$aggregate('[{"$group": {...}}]') - Aggregation pipeline