Export ConnectWise Automate data: inventory, Excel and reports

At a glance

Use ConnectWise Automate's built-in tools to preserve selected inventory and report results before a migration, major change, or audit. This guide explains the available export choices and how to verify what each file contains.

Export selected ConnectWise Automate inventory and reports, choose a useful file format, and verify what each export contains.

Published Updated

On this page

Export device and asset information from a Dataview

  1. In the Control Center, open Automation > Dataviews and select the view for the inventory you need.
  2. Check the client/location scope and active filters before exporting.
  3. Choose Options > Export all to Excel, then select the destination and filename.
  4. Keep the original .xml file; open a copy in Excel for analysis.

The Dataview guide specifies XML output despite the Excel command name. Starting from a specific client, location or computer limits the view. Do not label this as a native XLSX or CSV download; a spreadsheet conversion is a separate step.

Export a report in the format you need

Open the report in Report Designer, select Print Preview, then Export > Export To. The documented choices include PDF, XLS, XLSX and CSV, along with HTML, MHT, RTF, text and image formats. See Report Designer.

Use PDF when the rendered presentation matters and a tabular format when you need to inspect rows. Check totals and filters in either case. An exported report result is distinct from the reusable report definition.

Can you collect everything through the API?

Consult the official Automate developer documentation for your account and version. Confirm specific API resources, pagination, permissions, and JSON response shapes before building a collector; do not substitute ConnectWise RMM, PSA, or ScreenConnect endpoints.

The official sources cited here do not describe a one-click complete-account export. Our suggested coverage worksheet lists inventory, custom-field values, script definitions, configuration, and histories separately, with the exact export or documented API method for each.

Check a useful sample before a bulk export

For example, select one client's device inventory, note its filters and capture time, and compare several device identifiers with the console. Then inspect whether extra data fields and the required detail columns actually appear. Save the source XML alongside any derived CSV so later analysis can be repeated.

ConnectWise documentation links may require a partner sign-in. These instructions concern Automate, formerly LabTech; ConnectWise RMM is a separate product.

Official source

Using Dataviews in the Control Center