Connections Manager 
Import Wizard 
Collections Tab 
Visual Query Builder 
SQL Query 
SQL Connection Manager 
Team Sharing 
LDAP/ Kerberos
Export Wizard .svg){kind=icon}
SQL to MongoDB.svg){kind=icon}
MongoDB to SQL
Data Compare & Sync 
Task Scheduler 
Intellishell 
Schema Explorer 
AI Helper 
Aggregration Editor 
Query Code 
Query Profiler 
Index Manager 
Visual Explain 
Reschema 
Users and Roles Manager 
Data Masking 
Here’s the fastest way to copy query results from MongoDB to CSV, Excel – even Google Sheets.
Please note that this functionality fully supports pasting in Microsoft Excel, but might not work with other third-party spreadsheet software.
1. Run a query in Studio 3T. I’ve used the Visual Query Builder below, but you can also write queries in IntelliShell, Aggregation Editor or SQL Query.
I’ve built the query in the Query section so that my results only contain customers who (1) live in Chicago, (2) have opted for priority support, and (3) have ordered more than 50 times.
I’ve also applied a projection and sort in the Projection and Sort sections to clean up a bit, as this is how I’d like to paste the data in Google Sheets.
2. Choose Table View in the drop-down.
3. Right-click on the query results you want to copy from MongoDB to CSV or Excel. Choose whether to include the headers or not.
If you’re exporting MongoDB query results to Google Sheets, choose Copy Selected Documents for Excel
4. Paste the results directly in Excel or Google Sheets, or as CSV.
And there you have it: the quickest way to export MongoDB query results to Excel, Google Sheets, and CSV.
Download Studio 3T for free to try it out for yourself, along with these other handy copy-paste features:
