Skip to content

A checklist for exporting your data before you switch software

Last checked November 14, 2026

Export first, cancel last. Once your access ends, a missing export usually can't be fixed. This checklist is for the days before that.

1. List what the system holds

Write down every kind of record the old system keeps. Typical groups are customers, suppliers, products or services, invoices, payments, notes and files. Don't trust memory here. Click through the menus and note each section.

Some of it you'll move to the new system. Some you'll only keep as a record. Mark each group as one or the other.

2. Export each group on its own

Systems often export one kind of record per file. Run each export separately and name the files so you can tell them apart later. Put the date and the record type in the name, such as customers-export.

Look for these options on the export screen:

  • All records, not only the ones on the current page or filter.
  • Archived, inactive or deleted records, if you want them.
  • A choice of file type. CSV is the usual one; see what a CSV file is.
  • Which columns to include.

3. Check each file right away

Open every file. Don't wait until the import. Use this order:

  1. Count the records in the old system and in the file. They should match.
  2. Look at the header line. Column names should be clear and unique.
  3. Scan a few lines from the start, the middle and the end.
  4. Look for blank columns that should hold data.
  5. Check accents and symbols in names. If they look wrong, note it for later.

An import tool will often expect a header row. One vendor's import page lists a header row among its file requirements.1 It also asks for UTF-8 encoding when a file includes foreign language characters.1 A bad header or encoding is far easier to catch in the old file than after loading.

4. Know what a CSV can't carry

A CSV file is limited to representing a simple tabular structure.2 It doesn't hold attached documents, scanned receipts, email history or the way records link together. If those matter, save them another way, such as a bulk download or the system's own backup option. Not every system offers one, so ask the vendor's support team before access ends.

The format also does not support strong data typing.2 So write down how the old system showed dates, currency and phone numbers. You'll want that when you read about how dates, phones and amounts are written.

5. Keep records the law may require

Some data isn't only convenient. Tax and employment records may need to be kept for a set period, and the period depends on your country and your situation.

In the United States, the IRS says to keep records for 3 years in the basic case, and lists longer periods for other situations.3 It also says to keep employment tax records for at least 4 years after the tax becomes due or is paid, whichever is later.3 Other countries have their own rules, so check your national tax agency or ask your accountant.

Don't assume a vendor will keep your data once you leave. Ask what happens to it after cancellation.

6. Store copies safely

Export files often hold names, emails, phone numbers and payment details. Treat them as private.

  • Keep one copy that you never edit. Work on a duplicate.
  • Store files somewhere with limited access.
  • Don't send them as plain email attachments.
  • Delete working copies when the move is done.
From old system to a safe copyList what the old system holdsExport each list as its own fileOpen each file and check itKeep one untouched copy and store it securelyCancel only after the import works
Export, check, store, and only then cancel.

7. Before you cancel

Wait until the new system holds your data and you've checked it. Testing an import with a small batch shows a safe way to do that. If the old plan allows a short overlap, use it.

If you're not sure whether an export is complete, ask the old vendor in writing. Keep the reply with your files.

Notes and sources

  1. Format import files, HubSpot Knowledge Base
  2. CSV, Comma Separated Values (RFC 4180), Library of Congress
  3. How long should I keep records?, Internal Revenue Service (United States)