WoWSheet

WoWSheet brings full spreadsheet functionality into World of Warcraft. Create documents, write formulas, pull live game data, and collaborate with other players in real time — all without leaving the game.

Getting Started

Type /ws or /wowsheet to open the document manager. You can also click the minimap button (left-click for document manager, right-click for the function reference).

Spreadsheet Features

WoWSheet supports up to 999 rows and 52 columns (A through AZ) per sheet, with multiple sheets per document and multiple documents. Cells accept numbers, text, booleans, formulas, and even clickable item links with quality coloring.

• Adjustable column widths via drag-resize
• Cell alignment controls (left, center, right)
• Range selection with Shift + Arrow Keys
• Copy, cut, and paste with Ctrl+C, Ctrl+X, Ctrl+V
• Fill drag handle to auto-fill cells with incrementing formulas
• Search across all cells with Ctrl+F
• Right-click context menus on cells, sheet tabs, and documents
• Formula bar with cell name box for quick navigation

40+ Built-In Functions

WoWSheet includes a full formula engine. Start any cell with = to enter a formula. A searchable function reference is built in — access it with the fx button, right-click the minimap icon, or press F1.

Math

SUM AVERAGE MIN MAX COUNT ABS ROUND CEIL FLOOR MOD POWER SQRT

Text

CONCATENATE LEN UPPER LOWER LEFT RIGHT MID TRIM SUBSTITUTE REPT

Logic & Conditional

AND OR NOT IF IFERROR

Lookup

VLOOKUP HLOOKUP INDEX MATCH

Statistics

COUNTA COUNTIF SUMIF AVERAGEIF MEDIAN

Info

ISNUMBER ISTEXT ISBLANK

WoW-Specific Functions

Pull live game data directly into your spreadsheet cells.

Character

HEALTH() HEALTHMAX() MANA() MANAMAX() LEVEL() CLASS() PLAYERNAME() REALM() XP() XPMAX()

Currency & Inventory

GOLD() SILVER() COPPER() TOTALGOLD() BAGFREE() BAGTOTAL()

Equipment

ILEVEL(slot) — returns the item level of an equipped item by slot number

Location & Time

ZONE() SUBZONE() NOW() GAMETIME()

Item Lookup

Pass any item ID to retrieve its information:

ITEMNAME(id) ITEMLEVEL(id) ITEMPRICE(id) ITEMCOUNT(id) ITEMLINK(id) ITEMQUALITY(id) ITEMTYPE(id)

Item functions accept a numeric item ID, a cell reference containing an item link (e.g., =ITEMCOUNT(A2) where A2 has a shift+clicked item), or a direct item ID number. While editing a formula, Shift+Click an item to insert its item ID, or Shift+Click a cell to insert a cell reference at the cursor.

ITEMLINK returns a fully clickable, quality-colored item link with tooltip support.

Raid Icons

RAIDICON(name_or_number) — displays a raid target icon by name (star, circle, diamond, triangle, moon, square, cross, skull) or number (1–8)

Real-Time Collaboration

Share a document with other players and edit together in real time.

• Right-click a document and select Share to start hosting
• The recipient gets a share offer dialog — once accepted, the document syncs automatically
• Host controls permissions: guests can be given write access or kept read-only
• Peer cursors show where each collaborator is editing, with unique colors per player
• Edits sync with delta-based batching for efficient bandwidth usage
• Automatic reconnection if a player reloads
• The addon detects whether the recipient has WoWSheet installed before attempting to share

Import CSV/TSV Data

Bring external spreadsheet data into WoWSheet. Supports comma-separated (CSV), tab-separated (TSV), and semicolon-separated formats.

Direct Paste from Excel / Google Sheets

Copy cells in Excel or Google Sheets, then select a cell in WoWSheet and press Ctrl+V. The data is automatically detected and imported at the cursor position — no extra steps needed.

Import Dialog

For more control, use the import dialog:

• Click the Import button in the spreadsheet header bar
• Type /ws import
• Right-click a cell and select Import CSV/TSV here
• Right-click a document in the document manager and select Import CSV/TSV

The import dialog is a two-step wizard:

1. Paste & choose separator — paste your data and select the delimiter (Tab, Comma, Semicolon, or a custom character). The separator is auto-detected on paste.
2. Preview & import — review parsed rows and columns, then choose where to import: as a new document, a new sheet in the current document, or at the current cell position.

When importing at the current cell, WoWSheet warns if existing cells will be overwritten and if data exceeds the sheet size limits (999 rows, 52 columns).

Document Management

• Create, rename, and delete documents from the document manager
• Each document supports multiple sheets with add, rename, and delete controls
• Documents display relative timestamps (e.g., "2 mins ago")
• All data persists between sessions via SavedVariables

Keyboard Shortcuts

• Arrow Keys — navigate between cells
• Shift + Arrow Keys — extend selection
• Tab / Shift+Tab — move right / left
• Enter or F2 — edit cell
• Shift+Click item (while editing) — insert item ID into formula
• Shift+Click cell (while editing) — insert cell reference into formula
• Escape — cancel edit, collapse selection, or close window
• Delete / Backspace — clear selected cells
• Ctrl+C / Ctrl+X / Ctrl+V — copy / cut / paste (Ctrl+V also pastes from external clipboard)
• Ctrl+F — search
• F1 — function reference

Supported Versions

WoWSheet works across all WoW editions: Retail, Mists of Pandaria, Cataclysm, Wrath of the Lich King, The Burning Crusade, and Classic Era.