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:

Paste & choose separator — paste your data and select the delimiter (Tab, Comma, Semicolon, or a custom character). The separator is auto-detected on paste.
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.