WikilyWIKILY
All games11 Wikis · pick your game
11
Menu

Documentation

Item pages from a spreadsheet

Updated 2026-09-27

You have a spreadsheet of items, a folder of icons, and you want a page for every item. This guide goes from that spreadsheet to finished, linked pages in seven steps. Nothing here needs code.

What you end up with

One row of your spreadsheet becomes one page at its own address, built from the page layout you design once. A list block on any page shows every item and links to its page.
One shared layout, every pageYou design the item page once, as the dataset's shared layout. Every item page uses it, and a change to it updates all of them at once.
Your data stays in one placeNumbers live in the spreadsheet you upload. Upload a new version after a patch and every page shows the new values.
A page you can still write onEach item page also has room for its own text, such as where to find the item.

1. Prepare your spreadsheet

One row per item, one column per fact. Save it as CSV or JSON.

Your spreadsheet: one row per item, one column per fact. The Name column becomes each page's address. The Icon column holds the name of that item's picture - whatever the file is called.
Name columnBecomes the page address. Adept Ward turns into items/adept-ward, so keep every name different. Two items with the same name, or want other addresses? Add a column called slug and write each address there.
Icon columnThe name of the item's picture. Any file name works - step 2 shows how the two connect.
Every other columnAnything you want to show: category, price, stats, where it drops.

2. Upload and connect the icons

  1. Open your wiki and click Manage, then Media & Datasets.
  2. On the Images tab, click Upload files.
  3. Select all your icons at once. They upload one after another.
Media > Images. The name under each tile is what an Icon cell uses; Copy URL gives the picture's address, which works in an Icon cell too. The last one was uploaded while its uploader's changes still needed review, so a tag was added to its name.

Each row's Icon property is what connects it to its picture. Fill it one of two ways:

The Icon property is the connection. A row's Icon holds a picture's name from Media > Images (or its Copy URL address), and every page and list showing that row shows that picture. Nothing needs renaming; to change a picture, change one cell.
Write each picture's namePut the name shown under the picture in Images into the item's Icon cell, such as T_Icon_Scales.png. Files keep their names; to swap a picture, change one cell. The address from Copy URL works too.Best when your pictures already have names, like a game's own icon files.
Name the pictures after the itemsRename each file to match its item, then fill the Icon column with a formula: =SUBSTITUTE(A2," ","_")&".png" turns Fish Scales into Fish_Scales.png.Best when you name the files yourself anyway.

Either way the name must match, ending included. Capital letters do not matter; spaces and underscores do.

To change one item's picture later:

  1. In Media & Datasets → Data, open the dataset, go to its Rows tab and click the item's row.
  2. Next to Icon, click Edit value, write the picture's name, and click Save.

The change sits on top of your uploaded data, so it survives the next upload and can be undone.

A name like T_Icon_FishOil-4f9d5946.png got its tag because your changes still needed review when you uploaded it. Write that exact name in the Icon cell and it works. For the clean name, get Skip review (an owner sets it under Manage → Moderation → Members) and upload the same file again: it takes its real name back.

Plenty of roomOwners can upload up to 2,000 files every 10 minutes. Each file can be up to 25 MB, and a wiki holds 2 GB in total.
Clean up in bulkOwners see a tick box on every image. Tick the ones you do not want, or Select all images, then Delete selected. Deleting cannot be undone.
Watch for copiesA browser saves a second download as Fish_Scales (1).png. Rename or skip those before uploading.

3. Create the dataset

A dataset is your spreadsheet, stored in the wiki. More about them in Tables and rows.

  1. In Media & Datasets, open the Data tab.
  2. Drop your file on New dataset from a file.
  3. In Review the detected schema, type a name such as Items. The Slug next to it becomes the start of every item's address.
  4. Set the Type of your Icon column to Media & Datasets. Untick any column you do not need.
  5. Click Create dataset.
Review the detected schema. Every column of your file is listed with the type it was read as. Set the Icon column's Type to Media, give the dataset a name, then click Create dataset. Nothing is saved before that.

Already created the dataset without an Icon column? Add the column to your file, open the dataset's Updates tab, and drop the file on Update this dataset from a file. The new column shows as new. Set its type to Media and click Apply update. Your pages keep working throughout.

4. Design the shared layout

The item page is designed once, as the dataset's shared layout. Open the dataset and click its Shared layout tab. It says what the layout does and walks you through steps 4 to 6. A shared layout is optional: a dataset that only feeds a list or a table does not need pages.

A dataset with pages opens on its Shared layout tab; any other dataset opens on Rows, and this tab reads Off until you set it up. The card shows where the dataset stands and, until everything is done, the three steps with the button for the next one.
Search titles for every pageOne Page SEO template gives each item page its own title and description from its row.
Translated onceThe layout's labels are translated one time and show in every page's language.
  1. Click Set up pages (it reads Edit the shared layout once one exists). The same editor is under Manage → Detail pages. The editor fills the layout with one of your rows, so you see real values while you design.
  2. In Blocks, search for Entry header and click it to add it. Click Move up until it sits on top.
  3. In its All settings, type the column names: Small label field Category, Title field Name, Tagline field Type, Description field Description and Image field Icon. Set Picture size to Large (192px).
  4. Click the Infobox the layout starts with. Give it the title Details and remove the rows the header already shows with ✕.
  5. Click Save. Every item page changes at once.
The item page in the shared layout editor: an Entry header on top shows the item's picture, category, name and description, and an Infobox titled Details holds its facts. The inspector on the right is the Entry header's All settings, with Image field set to Icon.

The dashed page content area is where each page's own text appears. More on that in One layout for every entry.

5. Create a page for every item

  1. On the Shared layout tab, click Create the pages (step 2).
  2. Leave the URL pattern as items/<rowKey>, or change the first part.
  3. Keep Shared layout selected, then click Create.
Create the pages opens this dialog. The URL pattern decides the addresses: items/<rowKey> gives items/fish-scales. Keep Shared layout selected so every page uses the layout you designed, then click Create.

Added rows later? Step 2 then offers to add the missing pages. Pages that already exist stay as they are.

6. Publish the pages

If your changes need review, your new pages start as drafts. Readers see page not found until someone accepts them. The Shared layout tab shows how many pages are live and links to the changes waiting for review.

Moderation. New pages from an account that needs review wait under Pending changes until an admin accepts them - Accept all takes the whole queue at once. Under Members, an owner can set owners and admins to Skip review, themselves included, so their next changes go live straight away.
  1. Go to Manage → Moderation.
  2. Under Pending changes, check a few pages, then click Accept all.

A page with more than one change waiting is skipped by Accept all. Look at those one at a time, so no change overwrites another. The whole queue is explained in Reviewing edits.

Owners: set yourself to Skip review under Members before step 5, and your pages go live the moment you create them.

7. List and link your items

  1. Create a page called Items, with the address items.
  2. Add a Catalog block and pick your dataset. Its cards link to each item's page.
  3. Leave Image field on Auto: it uses the column you typed Media. Or pick Icon.
  4. On the inspector's Layout tab, set Show more rows to Infinite scroll, then save.
A Catalog block on your Items page. Each card shows the item's icon and links to its page; with Infinite scroll, more cards load as readers scroll.

If something looks wrong

Some pages don't change when I edit the shared layoutThey have their own copy of a design. The dataset's Shared layout tab lists them at the top, with a button that moves them onto the shared layout.
An item link says page not foundThe page is waiting for review (step 6), or was never created (step 5).
An icon does not showThe Icon cell does not match a name in Images. Compare them, ending included, or put the picture's Copy URL address in the cell (step 2).
A new item has no pageStep 2 on the dataset's Shared layout tab offers to add the missing pages.
Old /browse/ linksAutomatic /browse/ pages no longer exist. Old links go to the item's own page when it has one.