MetaSheets: Convert spreadsheets into type safe C#

I have submitted today MetaSheets Pro and MetaSheets Free to the Unity Asset Store. Currently it is still in review by the Unity Asset Store team.

What is MetaSheets
MetaSheets is an editor addon for Unity that converts Google spreadsheets into robust and type safe C# code. Setting up a spreadsheet is easy, optional annotations are intuitive and enable some seriously powerful features.

It turns this



Into this


MetaSheets is great for teams that want to collaborate or bigger projects that require type safety with data. The generated C# code can be used at runtime or with Unity Editor scripts.

Pro and Free Version
That's right there is a Free version and Pro version of MetaSheets. The Free version supports only 6 data types and does not have all of the advanced features of the Pro version. But at its core offers the same principles and mechanics. If you want to give Meta Sheets a try then the Free version is a great start.

Features
• Generate C# code from your spreadsheet.
• Type safe code: NO string references.
• Full code completion in your editor.
• Detect types automatically, enforce them or inherit from classes.
• Reload at runtime from your spreadsheet.
• 18 supported data types.
• Extend your data with base classes.
• 5 documented examples included.


What can you do with MetaSheets?
MetaSheets has been used in a wide range of games and scenarios. Here are some examples:
• Localize user interfaces.
• Store game economics.
• Design and tweak variables..
• Manage and trigger analytics.
• Create an achievement manager.
• Tag audio and create audio pools.
• Integrate MetaSheets into Unity Editor scripts.

Additional examples will be covered on the MetaSheets Blog.


Production Ready
MetaSheets has powered many successful and big projects such as:
• Hasbro RISK Global Domination
• SMG Studio Death Squared
• SMG Studio Thumbdrift
• SMG Studio One More Line
• SMG Studio One More Dash
• SMG Studio One More Bounce
• ABC Gallipoli: the first day
• ABC Battle of Fromelles and Poziers
• Good Knight Story
• Letter Bounce


Highlights
These slides are from the Asset store with some additional notes.


Easy to use: Copy and paste document URL, enter class name and generate the class file. It's that easy.

This is a Pro version only feature: MetaSheets allows you to compile additional reload code into the class file. Currently all 18 data types support reloading at runtime, including eNums, arrays, colors, dates or sheet references etc. More info here


One of the core principles of MetaSheets: No string look-ups or references = No surprises. If you enter wrong values in your spreadsheet your compiler in Unity will tell you where the issue is and usually what is wrong.


Both the Pro and Free version include 5 examples (they are library / MetaSheets independent). All of them have fully documented code, screenshots in the scenes and links to the original spreadsheet documents.


At SMG Studio MetaSheets has been used extensively for each major project. From analytics, game economy, achievements, audio management, translations to compression rules and much more. MetaSheets changed how the studio worked as a team.


A great way of using Google Sheets for games is it's build in Google Translate functionality. With MetaSheets this can be automated and integrated into UI systems. By separating content from design it becomes easier to iterate and update the copy.


MetaSheets Pro supports 18 data types whereas MetaSheets Free supports 6 data types. All types can either be automatically detected, enforced with optional annotation in the sheets or extend from base classes.


The website always contains the latest documentation. In depth steps and with screenshots illustrate how to use MetaSheets, setup up spreadsheets and use all of the advanced features. For example the data type reference shows with screenshots how to write specific values including allowed variations.

Visit the MetaSheets website for a detailed feature list and the manual. The MetaSheets Blog will share techniques and recipes. For additional questions you can send an email to: support@metasheets.com or ask here on the forums.

 

Hi,
My gametable was attached.
And I would like to get result like below :
- List<int> listPig = new List<int>() {0, 3};
- List<int> listCat = new List<int>() {0, 2};
- List<int> listSheep = new List<int>() {1, 3};
- List<int> listTiger = new List<int>() {0, 2, 4};

How should I do?

 

Appreciate this was gonna happen sooner or later, but has the endpoint MetaSheets relies on just stopped working for anyone else? i.e., this url - https://spreadsheets.google.com/feeds/worksheets/SHEET_ID/public/basic?alt=json-in-script

Seems to have stopped working sometime in the last couple of weeks for spreadsheets that were working fine previously, and can't get it to work with any new sheets either

 

Ah k, this would explain things - https://developers.google.com/sheets/api/guides/migration

Anyone still using MetaSheets and migrated it to use the v4 API?

 

Hello, I just ran into this problem, did you have any solution to this?

 

Wondering the same. It seems like Metasheets support itself is unreachable. So wondering if anybody found a solution for this.