Exporting an Asset Listing Page to Excel

(Leon Prenter) #1

I have created an Asset listing page to display data on records in our website (names and email addresses). Can someone tell me how I would export the data into an Excel spreadsheet so names go in one cell and email addresses in the next.

(Anthony Barnes) #2

I have used javascript in the past when activeX support is available (browser specific), or alternately you could re-write the listing to appear in csv format and either copy and paste, or provide headers (via design) to get the browser to download it as a csv.


Here's an article related to the activeX method (which is particularly useful if you have a page that is display in one format, but you want to provide a quick link to download it in excel format).

(Anton Babushkin) #3

Another thing that you can do (although I have only done this for exporting to CSV) is to use the Downloadify jQuery plugin.


However, since you’re using an Asset Listing I would do what Anthony recommended (which is using a custom header in a Design Asset).

(Nic Hubbard) #4

Here is what I currently use to allow an asset listing to download into CVS format.


Parse File:


Then, in your asset listing just make sure everything is comma separated and it will show up perfectly in Excel.

Good luck.