Parse the Factorio recipe files to create a CSV of recipes

factorio-recipe-parser.lua

data = {}
data["extend"] = function (data, t)
    for n, recipe in ipairs(t) do
        for i, component in ipairs(recipe["ingredients"]) do
            cname = component[1] or component["name"]
            camt = component[2] or component["amount"]
            print('"' .. recipe["name"] .. '","' .. cname .. '",' .. camt)
        end
    end
end

files = {
    "ammo",
    "capsule",
    "demo-furnace-recipe",
    "demo-recipe",
    "demo-turret",
    "equipment",
    "fluid-recipe",
    "furnace-recipe",
    "inserter",
    "module",
    "recipe",
    "turret",
}

for i, f in ipairs(files) do
    dofile("C:\\Apps\\Factorio\\data\\base\\prototypes\\recipe\\" .. f .. ".lua")
end

recipes.csv

I got this to work on 0.15.23:

NORMAL_OR_EXPENSIVE = "normal"
data = {}
data["extend"] = function (data, t)
    for n, recipe in ipairs(t) do
        if recipe["ingredients"] then
            ingredients = recipe["ingredients"]
        elseif recipe[NORMAL_OR_EXPENSIVE]["ingredients"] then
            ingredients = recipe[NORMAL_OR_EXPENSIVE]["ingredients"]
        end
        for i, component in ipairs(ingredients) do
            cname = component[1] or component["name"]
            camt = component[2] or component["amount"]
            print('"' .. recipe["name"] .. '","' .. cname .. '",' .. camt)
        end
    end
end

files = {
    "ammo",
    "capsule",
    "demo-furnace-recipe",
    "demo-recipe",
    "demo-turret",
    "equipment",
    "fluid-recipe",
    "furnace-recipe",
    "inserter",
    "module",
    "recipe",
    "turret",
}

for i, f in ipairs(files) do
    dofile("C:\\Apps\\Factorio\\data\\base\\prototypes\\recipe\\" .. f .. ".lua")
end

If you want the "expensive" difficulty instead of "normal", change the value of NORMAL_OR_EXPENSIVE.

Here is a version that simply exports al the data to a json file. I found it easier to process the json in a different language because I'm not comfortable with lua. Depends on a json encoding library that you can easily save to a file in the same directory as this script.

-- https://raw.githubusercontent.com/rxi/json.lua/cc9833592eb4d90cb5beb29982cf5ac9eedff027/json.lua
local json = require("json")

local FACTORIO_PATH = "C:\\Program Files (x86)\\Steam\\steamapps\\common\\Factorio\\"

local aggregator = {}

data = {}
data["extend"] = function (data, list_of_things)
    for key, thing in ipairs(list_of_things) do
        table.insert(aggregator, thing)
    end
end

files = {
    "ammo",
    "capsule",
    "demo-furnace-recipe",
    "demo-recipe",
    "demo-turret",
    "equipment",
    "fluid-recipe",
    "furnace-recipe",
    "inserter",
    "module",
    "recipe",
    "turret",
}

for i, f in ipairs(files) do
    dofile(FACTORIO_PATH .. "data\\base\\prototypes\\recipe\\" .. f .. ".lua")
end

local output = io.open("output.json", "w")
output:write(json.encode(aggregator))
output:close()

Has anyone bothered to write a version that also loads mods in the right order and everything? I was initially looking to export the data after all the mods have done their thing but I could not find a way to write to stdout/a file during the data collection stage.

I have a mod that will produce a delimited file with one recipe per line https://mods.factorio.com/mod/RecipeDump