How do you Generate Data Files w/ Excel?

[PvK]

Manually. I have used Excel, but mainly to figure out formulas, make balance and other calculations, and see my data side by side. Then I manually put the data into the mod files.

In other game projects I have used Excel as a template for game data, saving it as .CSV files and then programming the game to interpret the .CSV files. But I don't know how, or even if it's possible without coding a plugin, to get Excel to output in the correct format for SE4 to read.

Some other modders may have come up with clever labor-saving techniques using Excel which I don't know about. I try to use Excel only to the point where it starts becoming more work than it's worth, which for me is pretty quickly. Since Excel puts data in cells where it is annoying to see and edit, I find it to be extremely error prone and aggravating to try to do anything too complex with it. I do find it useful though for quickly doing calculations and stuff.

PvK