How to Export Ticket Lists/Info into MS Excel

[Nintendo]

For those of you familiar with creating VBA macros in Excel, you should have no problem figuring out how to automate this. If I get ambitious enough I will post a how-to on the VBA, but for now here is how it can be done manually:

1. In eSupport, view the ticket list you wish to export.
2. On the IE menu go to View->Source
3. Save the source file as a .txt file (ANSI encoding)
4. Open MS Excel
5. File->Open the .txt file you saved (for file types, select All or you will not be able to select it)
6. Find the ticket table information (for me it starts on cell H32)
7. Select the cells that contain the table information and Copy it.
8. Create a new worksheet or workbook, then click on cell A1
9. Edit->Paste Special->paste Values

Abra-Cadabra

[Nintendo]

Another method of doing this:

With the ticket list open, save the web page as a html document.
Open Excel, create a new worksheet.
Go to Data->Get External Data->New Web Query.
For the address use the path to the file you saved the .html as
For the options chose 'Tables Only,' and keep the format options set to 'None.'

This one is a little easier to format.

[supportskins]

Interesting! Thanks for sharing.

[fivestarhost]

Thank you