Exporting from ConnectWise Automate

By the Helios team · Last checked 28 September 2026

To export computers from ConnectWise Automate, open a Dataview (Automation, Dataview), then choose Options, Export all to Excel, and resave the .xml file it produces as CSV. Opened from Operations it covers every client, location and group; right-click a client to export just that part. Whether you are leaving Automate or just want a copy of your estate, here is what it hands over and what no export will ever carry.

We have used these products ourselves, and we respect them. Most migration guides are published by the product you are moving to; we make an RMM too, so we have kept this one to the facts: what each product hands over, and what it does not.

The short answer

Computer lists come out of Dataviews: Automation, Dataview, open the view, then Options, Export all to Excel (ConnectWise documentation, checked 28 September 2026).
That export saves as an .xml file, not a CSV. Open it in Excel and save it as CSV before any other tool can read it.
Open a Dataview from Operations in the navigation tree and it covers your whole system: every client, location and group.
Right-click a client, location or group and choose Dataviews to export just that part.
The Report Designer can export to CSV directly, among other formats, if you would rather build a report.
Scripts, monitors and device history do not transfer anywhere. Budget to rebuild them.

Computers: Dataviews, then Excel

In the Control Center, expand Automation, Dataview, and open the view you want. Options, Export all to Excel saves everything in the current view.

The file is Excel XML. Open it in Excel, check the columns, then save a copy as CSV. That CSV is the file you take anywhere else.

Choose where the Dataview starts. From Operations it covers the whole system. From a right-click on a client or group it covers only that.

Reports

The Report Designer exports to CSV, PDF, Excel and more. It takes longer to set up, but it gives you a CSV straight away and a layout you control.

What never transfers, whatever anyone tells you

Scripts and automation. Every platform models these differently. They are rewritten, not imported, and this is usually the biggest job.
Policies and alert thresholds. The thresholds you tuned over years will not match the defaults at the other end.
Device history. Performance trends and patch history start again at zero. Export the reports clients will ask for before you switch off.
Ticket history, in practice. Decide early whether you need old tickets live in the new system or archived and searchable. The second is far cheaper.

Loading the export into Helios

If Helios is where you are going, this is all you need to bring your clients across.

In Automate, open a Dataview from Operations, use Options, Export all to Excel, then open the file in Excel and save it as CSV.
In Helios, open Clients and choose Import from another RMM, then drop the file in.
Helios shows you what it found before anything is written: how many companies, how many machines, and anything it could not read. Nothing changes until you press Import.
Each client becomes a client, with its machines listed under it. Run it again with a fuller file and it updates rather than duplicates.

Helios needs one column that names each machine's client. It reads Company, Customer, Client, Organization or Site. If your file calls it something else, rename that heading before you import, and the preview will tell you if it still cannot find one.

Imported machines are listed, not managed. ConnectWise Automate's agent is ConnectWise Automate's software, so each machine starts reporting to Helios when our agent is installed on it. The dashboard counts your progress, for example 12 of 40 imported machines now reporting, so the rollout has a finish line.

Where you are going is your call. If you want the honest comparison first, the Helios and ConnectWise Automate comparison is the page for that.

The sequence that works

Export everything read-only first, while you still have full access.
Rebuild scripts and alert thresholds on the new platform against a handful of your own machines. This sets your real timeline.
Run both platforms side by side across one complete patch cycle. A patch cycle is when an RMM tells you the truth about itself.
Move clients in batches, quietest first. Keep the old agent until the new one has reported healthy for that batch.
Only then cancel, and check your notice period before you pick the date.

And if you ever leave Helios

The same courtesy runs the other way. Any admin can export devices or clients to CSV from the report builder, with the columns they choose. No API key, no support ticket, no exit fee.

What we could not verify

Which default Dataview holds client name, computer name, OS and serial together. That depends on your version and your own views.
Whether a ConnectWise contract can end mid-term. Ask before you plan the date.

Common questions

How do I export a computer list from ConnectWise Automate?

Open a Dataview, from Operations for the whole system or by right-clicking a client for one client. Then use Options, Export all to Excel, open the .xml file in Excel and save it as CSV.

Why is my Automate export an XML file?

Export all to Excel saves Excel XML rather than CSV. Open it in Excel and save a copy as CSV. The Report Designer can export CSV directly if you prefer.

Can I import a ConnectWise Automate export into Helios?

Yes, once it is saved as CSV with a column naming the client. Drop it into Import from another RMM in Helios. It previews everything before anything is written.

Sources

Checked against these pages on 28 September 2026. If something has changed since, tell us and we will correct it.

Why MSPs choose Helios

One platform that does the work, at a price that stays put

Helio fixes, not just flags

When an alert fires, Helio, the AI technician built into Helios, investigates it, writes the fix and runs it once you approve. It keeps what works, so the next one is quicker.

Everything in one product

RMM, a service desk with SLAs, patching including third-party apps, remote access, Microsoft 365 and Defender checks, backup monitoring, a client portal and billing into Xero or QuickBooks.

Priced by fleet, not by people

£3 a device on Launch up to 25 devices, from £15 a month, then £79, £159 or £319 a month by fleet size, with any number of technicians and every feature on every plan.

A price that stays put

Your price is locked for as long as you stay subscribed, and that is written into our terms. Monthly billing, cancel any time.

Bring your clients across

Import your clients and machines from another RMM's CSV export, then roll the Helios agent out at your own pace, with a count of how many have arrived.

14 days free, no card to start

The full platform from the first minute, on your own machines. No sales call. Remote control asks for one card check, and nothing is charged.

See it on your own fleet

Helios is the AI-native platform for MSPs: monitoring, patching, security, Microsoft 365, backup monitoring, remote access, client billing and an AI service desk in one product, at one flat price per MSP. Contracts and logged time become invoices in Xero or QuickBooks without leaving the platform. Every feature is on every plan. 14-day free trial, card-free, set up in minutes, cancel any time.

Start free

Details of other products on this page were checked on 28 September 2026 against their public documentation, and may have changed since. All trademarks belong to their respective owners. Spotted something out of date? Email hello@heliosmsp.io and we will fix it.