DataForge | ScriptableObject Spreadsheet Editor – Unity Tool

    Version 1.0.0

    1/8

    Compatibility

    Unity version
    6000.0 or newer

    Description

    Edit ScriptableObjects in a spreadsheet grid — bulk-edit, validate, save, and sync with Google Sheets, Excel, CSV & JSON. A Unity Editor data table for your scriptable objects, game data, balancing, and serialized fields.

    No more clicking through scriptable objects one at a time. No more Inspector tedium. No export-to-Excel-and-reimport dance. Just every ScriptableObject in your project, in one editable table.

    DataForge is a Unity Editor extension that turns your ScriptableObjects into a live spreadsheet. Pick a ScriptableObject type — WeaponData, EnemyData, ItemData, anything — and every asset becomes a row, every serialized field a column.

    Unlike editing scriptable objects one-by-one in the Inspector, DataForge shows your whole dataset at once — so you can sort, compare, bulk-edit, validate, save, and color-code hundreds of ScriptableObjects without ever leaving Unity. Every change saves straight to the real .asset file with full Undo support.

    |


    📊 SPREADSHEET EDITING
    Open a dockable, resizable table where rows are your scriptable objects and columns are their serialized fields. Click a cell and type — edits use Unity's own property drawers, so colors, curves, gradients, enums, and object references all behave exactly as they do in the Inspector. Features include a frozen header, live search, show/hide columns, pagination, and recent-type quick access.

    🔁 BULK & MULTI-EDIT
    The reason DataForge exists. Drag-select a column, a block, or multiple rows, type one value, and set them all at once — or fill an incrementing numeric series for IDs and tiers. Edit hundreds of ScriptableObjects in a single Undo step and a single revertible batch.

    🧮 FORMULAS
    Compute numeric cells from other fields in the same row with a spreadsheet-style = syntax and {field} references — e.g., ={damage} * {attackSpeed}.
    Built-in functions: ABS, MIN, MAX, CLAMP, ROUND, FLOOR, CEIL, LERP, IF, LEN, UPPER, LOWER, CONCAT.

    ✅ DATA VALIDATION
    Attach per-field rules — Required, Range, Unique, Regex, and Not-Null Reference — and catch bad data before it ships. Failures surface live in the table with a toolbar issue count; one click filters it to just the offending rows.

    🎨 CONDITIONAL FORMATTING
    Color cells by value so outliers and balance problems jump out at a glance — tint a rarity column by tier, flag a price of 0 in red, highlight a damage value far above the rest. Purely cosmetic; never touches your data.

    ☁️ GOOGLE SHEETS & EXCEL SYNC
    Two-way sync any ScriptableObject type with a Google Sheet — push your table up, pull designer edits back down. Bind a project spreadsheet through the Google Picker, or round-trip through Excel via CSV. Fully optional; everything else works with no account and no internet.

    🕓 CHANGE HISTORY & PERSISTENCE
    Every edit is logged with its asset, field, old → new value, and timestamp — and saved between sessions. Revert a single change or roll back an entire bulk edit or import in one click. Your data and history persist across Unity restarts.

    🧰 MORE TOOLS
    ➕ Batch Create: Generate dozens of new scriptable objects at once with prefix/suffix, zero-padding, and smart numbering.
    📦 Import & Export: Load and save the table through CSV, TSV, and JSON files, or in and out of Excel and Google Sheets.
    📋 Scratch Pad: A lightweight text pad for staging tabular data copied from Excel or Google Sheets.
    🎮 Sample data included: Ready-to-explore RPG-style ScriptableObjects (weapons, enemies, items) to learn the tool fast.

    💡 WHY DATAFORGE
    ✅ BUILT FOR SCRIPTABLEOBJECTS: Purpose-made to manage, edit, save, and organize your scriptable objects at scale.
    ✅ EDIT IN BULK: Change hundreds of ScriptableObjects in a single action instead of hundreds of clicks.
    ✅ BUY ONCE: No subscription, no per-edit fees, no credits. One purchase, yours forever.
    ✅ FULL UNDO: Every edit, bulk change, and import goes through Unity's Undo system.
    ✅ WORKS OFFLINE: The entire tool runs locally; Google Sheets sync is the only optional online feature.
    ✅ ZERO RUNTIME OVERHEAD: All scripts are Editor-only and stripped from your player builds automatically.
    ✅ FULL C# SOURCE: Every script is included and readable; extend or customize as you need.

    🚀 HOW IT WORKS
    1. Open Window → DataForge → Open DataForge.
    2. Pick a ScriptableObject type from the toolbar dropdown — every scriptable object of that type loads as a row.
    3. Click any cell and edit — or drag-select a range and bulk-edit it all at once.
    Add formulas, validation rules, and conditional formatting to keep your data correct and readable.
    4. Save and export to CSV/JSON, or sync the whole table straight to Google Sheets and Excel and back.

    🖥️ CORE

    • Spreadsheet editor window: Dockable, resizable, paginated; one row per asset, one column per serialized field.
    • Easy Access: Opens via Window → DataForge → Open DataForge (Shortcut: Ctrl+Alt+Shift+D).
    • Unity Integration: Edits write through Unity serialization with full Undo support — identical behavior to the Inspector.
    • Grid Navigation: Frozen header row, live search/filter, per-column show/hide, and a recent-types quick list (last 5).
    • Session restore: Last type, search, page, scroll position, and active cell are automatically remembered.

    🔁 BULK & MULTI-EDIT

    • Flexible Selection: Range, column, and multi-row selection with click-drag, Shift+click, and Ctrl+click.
    • Smart Fill: Set a whole selection to one value, or fill an incrementing numeric series.
    • Safe Operations: Each bulk edit is grouped as one Undo step and one revertible history batch.

    🧮 FORMULAS

    • Syntax: = prefix syntax with {fieldName} references to other fields in the same row.
    • Functions: ABS, MIN, MAX, CLAMP, ROUND, FLOOR, CEIL, LERP, IF, LEN, UPPER, LOWER, CONCAT.
    • Data Types: Supports arithmetic operators and parentheses; formula columns target int or float fields.

    ✅ VALIDATION (5 RULE TYPES)

    • Rules: Features Required, Range, Unique, Regex, and Not-Null Reference rules.
    • Profiles: Per-type validation profiles stored as version-controllable assets.
    • Workflow: Auto-validate on edit and on window focus; toolbar issue count with a one-click filter to affected rows.

    🎨 CONDITIONAL FORMATTING

    • Visual Alerts: Per-type rules paint cell background/text by value condition.
    • Performance: Evaluated live as the grid draws; purely cosmetic only, never modifies assets.

    📦 DATA IN & OUT

    • File Formats: CSV, TSV, and JSON import and export; columns matched by header.
    • Batch Create: Customize count, prefix/suffix, start index, zero-padding, append-after-max / fill-first-gap numbering, target folder, and view a live name preview.
    • Scratch Pad: Lightweight staging editor accessible via Window → DataForge → Scratch Pad.

    ☁️ GOOGLE SHEETS SYNC

    • Two-Way Sync: Optional two-way Push/Pull between a ScriptableObject type and a bound Google Sheet.
    • Integration: Spreadsheet binding via Google Picker; uses your own Google Cloud OAuth credentials.

    🕓 CHANGE HISTORY

    • Audit Log: Per-edit log detailing asset, field, old → new value, and timestamp.
    • Rollbacks: Single and batch revert functionality; data persists between sessions.

    🗂️ SUPPORTED FIELD TYPES

    DataForge seamlessly handles the following serialized field types:

    • int, float, string, bool, enum
    • LayerMask
    • Vector2, Vector3, Vector4
    • Color, Gradient
    • AnimationCurve
    • Any UnityEngine.Object reference

    ⚙️ REQUIREMENTS & COMPATIBILITY

    • Unity Version: Unity 2021.3 LTS or newer (including Unity 6).
    • Render Pipelines: Compatible with all pipelines — Built-in RP, URP, and HDRP.
    • Performance: Editor-only execution — zero impact on player build size or runtime performance.
    • Dependencies: Newtonsoft.Json (com.unity.nuget.newtonsoft-json) is the only dependency — auto-installed via a one-click setup popup.
    • Source Access: Full C# source included; welcome guide shown on first open.

    DataForge | ScriptableObject Spreadsheet Editor

    Version 1.0.0

    $22.99

    More by Ragendom

    Guides