Mapping LLMs over excel saved my passion for game dev
10 months ago
- #Game Development
- #Data Management
- #LLM Applications
- The author faced a data entry block in game development, particularly in translating spell and trait descriptions into a complex spell system in Unity3D.
- Initial attempts using Unity's editor and Odin for scriptable objects proved cumbersome due to nested components and nullable references.
- A shift to storing game assets as C# code instead of Unity asset files simplified editing, type-checking, and management.
- The author leveraged LLMs to map Excel data to C# code, overcoming initial hallucinations by refining prompts with structured context and mappings.
- A detailed workflow was established for LLM-assisted code generation, including context setting, input format, column mapping, and analysis steps.
- The solution automated much of the data entry process, allowing the author to focus on problem-solving and coding, thus preventing burnout.