2

I have a complex aggregation query in robomongo and I wanna export the results of the query to csv file. Is this doable? How can I do it?

I know that this other software Studio3T have that function but it's not free. It has a community version and it warns you about not using it for commercial use. and my project enables me to make some money so I thought I can't use the community version. I'm trying to find a way to export that results from robomongo. Does anyone know how to do this?

Any thoughts?

thor
  • 21,418
  • 31
  • 87
  • 173
Can Gokalp
  • 115
  • 1
  • 14

2 Answers2

1

I have found a free solution in Robo 3T.

  1. Take the raw JSON output.
  2. Use any online JSON to CSV converter

I took the first link in Google and it worked on this website

Seagull
  • 3,319
  • 2
  • 31
  • 37
  • 1
    It works fine, but Robo 3T limits the result to 50 documents – Troglo Oct 21 '19 at 14:07
  • You will be able to see more than 50 documents if you use the 'DBQuery.shellBatchSize = 500;' command as described in the answer here: https://stackoverflow.com/a/47459320/934383 – Rob Hinchliff Feb 01 '22 at 16:22
-4

This is the best you can do..

Screen shot - Robomongo

The panel on the right hand corner - shift it to "view results in text mode", then select all and copy .. you will have to paste it in a new .csv file.

This is the best you can do for there is no export csv in robomongo

Mario
  • 35
  • 5
  • 1
    Does copying and pasting the JSON record to a CSV file will help converting the file to CSV ? – Arun Nov 19 '18 at 10:29