Your spreadsheet will have an extra tab for each different content type you’ve used on your website. You can see the content types you’ve used by looking at the ‘Content Type’ column in the Pages tab. If you only use one content type on your website, you will only have one extra individual content type tab. If you use six content types, you will have six extra tabs.

Each individual content type tab uses the naming convention: ‘Content Type Display Name (Content Type Internal Name)’. For example, the individual tab for the Standard page content type is ‘Standard page (page)’. You can find the display names and internal names of content types in the Content Types tab.

Screenshot of two individual content type tabs, Standard page (page) and News Article (news_article).

These individual content type tabs describe how the content of each page is displayed on your website.

Let’s have a look at the tab for the Standard page content type:

Screenshot of the Standard page (page) tab, with 6 columns and 22 rows.

Column A, ‘ID’, lists the ID numbers of the pages on your website that use the Standard page content type. You can find the ID numbers for your pages by looking at the Pages tab.

You can see that there is no ID number listed for page 13 on this worksheet. This is because page 13 uses the News Article content type, so it’s listed on the News Article content type tab.

The other columns on the worksheet represent the fields that are used by the content type.

You can check what fields are used by a content type by looking at the Content Type Fields tab. Here you can see that the ‘page’ content type (column E) has three content type fields: ‘Body’, ‘File’ and ‘Image’ (columns A and B).

Screenshot of the Content Type Fields tab with three rows that have the 'page' content type selected.
The Content Type Fields tab

These three fields correspond with different columns in the Standard page content type tab. The Body field is described by columns B-D, the File field is described by column E, and the Image field is described by column F. These columns use the naming convention ‘Field Display Name (Field Internal Name)’. You can find the display names and internal names of fields in the Content Type Fields tab.

Screenshot showing the first six columns of the Standard page (page) tab. Column A is labelled ID, column B is labelled Body (body), column C is labelled Body Format (body), column D is labelled Body Summary (body), column E is labelled File (field_file, and column F is labelled Image (field_image).
The Standard page (page) tab

Each of these ‘Field’ columns describes the content of each content type field, by page.

The Body field uses three columns because it has two additional attributes: Body Format and Body Summary. These attributes are described by the same internal name as the body field itself: (body).

You’ll need to create the format column for every ‘text_with_summary’ type of field. You can also create a summary column if there’s any page summary required. The column headers should follow these naming conventions: Field Display Name Format (Field Internal Name) and Field Display Name Summary (Field Internal Name). For example, if you need to create the attribute columns for field “Product Description” with the internal name of “field_product_description”, the column headers will be “Product Description Format (field_product_description)” and “Product Description Summary (field_product_description)”.

The values of cells in the ‘Field’ columns are the values for each field of the page’s content type, which can be specified by static values and tokens.