Quickly export page names to Excel from Episerver

PLACE FOR BLOG

Quickly export page names to Excel from Episerver

Quickly export page names to Excel from Episerver

marija

I've seen quite a few requests from customers to export Episerver content to Excel. While there is an API to subscribe to for a custom export, still very often one only needs a full list of articles/employee pages or similar without doing an extra deploy.

Here is a short guide on how to do it:

  1. Export part of the tree structure from admin mode
  2. Extract the zip file (usually named ExportedFile.episerverdata) to a folder
  3. Delete everything but a file named epix.xml
  4. Create a new file in Excel, click Data -> Get data -> From File -> From XML
  5. Select the file, wait a bit for a window to load and then click Transform Data in the bottom right part of it
  6. Delete all columns except pages and then keep expanding the remaining column in the order below.
  7. In the end click Close & Load. You will get Name and Value columns which you can filter out on ex. Page name.
  • The following fields should be expanded:
  1. Table
  2. TransferContentData
  3. RawContentData
  4. Property
  5. RawProperty
  6. Name and Value

See the quick solution in action in a gif here.

Comments

no avatar

M SAYS:

Jan 09, 2019 at 04.19 pm

Hi Marija - I'm looking to keep an offline copy of our Episerver site content. I followed your instructions above but one thing I didn't see on Excel 365 is the Transform Data button when using Data > Get Data. I only get Load. Do i need to explicitly rename the extension on the file as .xml?

The other question i have is -- what selections on the Episerver Admin side are you selecting (Content Items, Content Types, Categories, Tabs, Visitor Groups)? I'd like to understand this part of the process better and can't find documentation anywhere.

LEAVE A COMMENT