Data for all recipes?

[ming.yuan]

Do we have a collection of all recipes for data analytic purpose?
I want to identify some more commonly used items for better base layout.
I can see that planning mods like Helmod can extract modded recipes. But I do not know how to get them outside of the game
Any help?

[darkfrei]

Do we have a collection of all recipes for data analytic purpose?
I want to identify some more commonly used items for better base layout.
I can see that planning mods like Helmod can extract modded recipes. But I do not know how to get them outside of the game
Any help?

What format are you need? You can get all recipes (and all prototypes) with this mod: viewtopic.php?t=45107

Json: https://mods.factorio.com/query/json?version=1.0

[ming.yuan]

Thanks! I loaded the recipes into json an then transform from json to Excel. Thank you. New skills learned

[ming.yuan]

I uploaded the file I get from json. Should include recipes for all pymods (raw ore, coal, industry, alienlife, etc), up to the pyalienlife 1.9.3 version. (most recent as at 9 Oct 2020).
There would be some recipes for utilities mods like electric trains, teleporters, and other items. The impact of these recipes should be trivial on the overall statistic.
I include a very brief analysis of most commonly used ingredients, depending on how many recipes in which the ingredient is used.
Feel free to grab.

[Squelch]

Thank you for your efforts.

Just a heads up for anyone without MS Excel. The spreadsheet does not display when imported into Google Sheets. It does however load correctly in LibreOffice, and presumably OpenOffice too.

[Xetrius]

Thanks! I loaded the recipes into json an then transform from json to Excel. Thank you. New skills learned

Care to share?