I presume that some/many/most players use a spreadsheet to help calculating the data they need for the game.
At least that's what I do.
But it is quite a hassle to input all the data, especially when there's an big change eg mineproduction changes for all 65 mines. So I would like to know if it is possible to retrieve a snapshot of the game data to a csv file or something similar that I can pull in to my spreadsheet?

As far is I know, there isn’t an API to extract your Idle progress.

This isn't some export option, but the data for mine production is publicly available on the wiki: https://www.warzone.com/wiki/Mines
Import this to your spreadsheet app as a basis, and add some dials to adjust mine level, ore production advancements, artifact effects and mine boosting techs and you are done. If you upgrade a mine, you only have to adjust one parameter, if you unlocked a tech, it's just another parameter.

And for army camps you can do something similar. There is no such list for the army camps, but they adhere to a simple formula that you can find in the wiki, too. Add similar dials and you can exactly determine your army income.

I admit, this are only two of the interesting pieces of information, but this should cover most use cases already. For other data you might have to be a little creative ;)

EDIT: This doc from Master Jz should have the same mine data but already formatted: https://docs.google.com/spreadsheets/d/1F5ejYV2bYeaP6yTH683A27iTY8ulDFxGXjwh0zXB82s/edit#gid=1248843523

Edited 4/14/2021 16:26:50

This would be a really nice feature. I'd fork out some AP if I could get the current recipes, recipe ingredients, recipe times, alloy and item sell values, and market purchase values as an export. We could then design our own stats.