What is the most reliable plugin or method for exporting a bunch of data from Grasshopper to a spreadsheet? either as CSV or xls? I have been using the lunchbox ExcelWrite component but its just too buggy. There are many other plugin options but none seem to have been updated for Rhino 6 or 7.
Any suggestions?
1 Like
I made this to read csv/excel files and export data, if i have time i will share it.
And you can try some tools available in food4rhino
Yes please share it! It looks really useful. I am trying to export the volume and dimensions of 60 STL files and and Lunchbox is really letting me down…
Extract the zip file to: C:\Users\........\AppData\Roaming\Grasshopper\UserObjects
Than restart Rhino
ReoGrid Excel.zip (633.1 KB)
Check the example file + the video to understand how to use it, and don’t close the window until you save the file.
excel example.zip (46.6 KB)
5 Likes
Amazing! Thank you this will save me so much time and effort.
The cells are blank when the spreadsheet opens but I realized I just have to click the “data disabled” button on the far right.
Much appreciation! 
1 Like
Yes and you need to disable it again if you don’t want receive new data
Hi,
I’m lost with it, can you explain in detail , every cell is blank, which button to click, where?
Thx
Once the Excel window is open, click on the far right button (the alt text when you hover your mouse over it will say Data Disabled or Data Enabled once you have clicked it)
If the data is not structured correctly, it might not show up properly in the excel window
Many thanks ! I’ll try this
Have a good day
Hi there!
I am trying to use this very helpful tool but when I open it only will put values in the first row, shown in snip. Any idea how to fix?
share your GH file and I will have a look. are your values structured as a tree (list of lists) like in the examples above?
Any chance to see .ODS support in this components? ODS is an open format and in my workflow I use only excel files in ODS format.
Thank you! Attached is the file I downloaded from this thread, using Rhino 8, that is giving me the error.
excel example.gh (46.6 KB)
Thank you for the response, could you expand? Im not sure what you mean
Ah i see - I suspect the plugin is not working as it used to, because it was written for Rhino 7 and not Rhino 8, and i dont think its been updated (the “old” marker on the component shows that its an outdated component)
However, there are other ways of exporting to excel. iv attached a script that exports data to a pre-made .csv file, which opens like an ordinary excel file.
You have to structure your data in a particular way, but i think it works pretty well.
the code was obtained from this youtube video…
Export_to_csv.gh (39.1 KB)
1 Like
Yes this is perfect! Thank you!!!
Did you check up TTToolbox their plugin is working quite well!
”Write to excel classic”