(Thanks to [Henrik Fransas at NetRelations](🔗) for this example.)

In Optimizely you can create custom reports and use the built-in reports in the admin view. The following example shows how to create a custom report of existing pages on a website and how to export the report to Excel using EPPlus.

1. Start by creating a Controller that looks like this:

   Text

   

   This controller is a GuiPlugin which is shown in the report menu and uses the URL _/existingpagesreport_. The controller is protected so you have to be part of the administrator group to use it.

2. For the URL to work, add a route to it in _global.asax.cs_:

   Text

   

   Create a simple view and make sure it shows up in the report center.

3. Add a ViewModel with the necessary properties:

   Text

   

4. Create a helper class to make a request against Optimizely like this:

   Text

   

5. Update your index action to create an instance of the View model and assign all page types to it:

   Text

   

6. Create a view and add Optimizely's CSS and JavaScript to it to have the same look-and-feel as other built-in reports in Optimizely. The complete view looks like this:

   Text

   

   This code has two **Submit** buttons but only one form action; the JavaScript function connected to the click event on the export and search submit buttons updates a hidden value telling the controller to do an export of the data or not.

   The action in the controller that handles this looks like this:

   Text

   

   It returns the view if the export values are not **true**.

7. To export the report to Excel, use **EPPlus** and create a function in the same class like this:

   Text