Home > General Administration > Cross-Platform Content > Using Exported Client XML Data

Using Exported Client XML Data

Table of contents
No headers

Dashboard gives users the ability to download and export several types of data including Client data. When viewing this exported data, you may run into difficulties deciphering the time and date values as they are exported in the EPOCH time standard. The following steps explain how to export your client usage data, and convert that data into a more recognizable format:

  1. Export the XML Data
    1. On Dashboard, navigate to Network-wide > Monitor > Clients and select Download as > XML.
    2. Save the file on your computer.
    3. Open the file in a Spreadsheet editor (ie. Excel, Google Docs)
  2. Manipulate the Spreadsheet
    1. Add an additional column next to each of the columns that contain EPOCH time values
    2. Choose one of the following formulas into the first cell in your new column based on your time zone:
  • GMT – Greenwich Mean Time: =(A1/86400)+25569
  • EST – Eastern Standard Time (GMT – 5:00): =((A1-18000)/86400)+25569
  • CST – Central Standard Time (GMT – 6:00): =((A1-21600)/86400)+25569
  • MST – Mountain Standard Time (GMT – 7:00): =((A1-25200)/86400)+25569
  • PST – Pacific Standard Time (GMT – 8:00): =((A1-28800)/86400)+25569
  1. Drag the formula composed in step b so that it is copied to each of the corresponding cells below. This is done by placing your cursor on the bottom right of the cell containing the data you want to copy and then dragging it down:

  2. Change the cell formatting for the column(s) so it displays in a mm/dd/yyyy tt:tt format:
Last modified



This page has no classifications.

Explore the Product

Click to Learn More

Article ID

ID: 1668

Explore Meraki

You can find out more about Cisco Meraki on our main site, including information on products, contacting sales and finding a vendor.

Explore Meraki

Contact Support

Most questions can be answered by reviewing our documentation, but if you need more help, Cisco Meraki Support is ready to work with you.

Open a Case

Ask the Community

In the Meraki Community, you can keep track of the latest announcements, find answers provided by fellow Meraki users and ask questions of your own.

Visit the Community