Groundwork ← Back AI and Tools   The cluster All guides
Groundwork
AI and Tools

Data Export: Get Your Business Data Out Before You Need To

How to export your data from the tools your business runs on: five steps, a checklist of what to export from each tool and how often, where the files end up, and what goes wrong.

Share
On this page
    Quick answer

    A data export is a copy of your information taken out of an app in a file you can keep, usually CSV, JSON or PDF. To export your data, list every tool your business runs on, find the export option (usually under Settings, Account or Data), choose a format another program can open, download it, open the file to check it is complete, and store it somewhere the original tool does not control. Exporting does not delete or move anything: the data stays in the app and you get a copy. The checklist below shows what to export from each kind of tool and how often, because the time you need an export is usually the time you can no longer get one.

    Every small business now runs on other people's software: an accounting app, an email platform, a store, a CRM, a pile of shared documents. The data in them is yours, but the only copy lives on someone else's servers, under someone else's account rules. A data export is how you get a copy you control.

    Most people only look for the export button when something has already gone wrong: an account is locked, a subscription lapsed, a tool shut down or an accountant needs three years of records by Friday. This guide covers how to export your data from the tools you use, what to export and how often, where the files end up, and what to check before you rely on them.

    How to Export Your Data in Five Steps

    1. List every tool your business runs on. Accounting and invoicing, payments, your store or booking system, email marketing, your CRM or client list, file storage, and any AI tools you have put real work into. If losing it would cost you a day, it goes on the list.
    2. Find the export option in each one. It is usually under Settings, Account, Data, Privacy or Reports, and often labelled Export, Download your data or Backup. If you cannot find it, search the tool's help centre for "export"; most document it.
    3. Choose a format another program can open. CSV for lists and tables, such as customers, invoices and transactions. JSON or a ZIP archive for whole accounts. PDF only for things you need to read or send, such as statements, because a PDF is hard to import anywhere else.
    4. Download it and open it. Check the file has the date range, the columns and the number of records you expected. An export that silently stopped at 1,000 rows or skipped attachments is worse than none, because you think you are covered.
    5. Store it outside the tool and put the next one in the calendar. Keep the copy somewhere the original app does not control, name it with the date, and decide how often to repeat it. The checklist below gives a starting cadence for each kind of tool.

    Aziz's take: The test of an export is not whether you downloaded it, it is whether you could carry on working from it if the tool disappeared tomorrow. Open the file. If you cannot find your customers, your invoices and your last month of work in it within five minutes, you do not have a backup yet, you have a file.

    What Does Export Data Mean?

    Exporting data means taking a copy of information out of the app where it lives and saving it as a file in a standard format. The original stays where it was; you end up with a second copy you control. Importing is the reverse: loading a file into an app.

    For personal data there is a legal angle too. Under UK and EU data protection law, the right to data portability lets people receive their data in a structured, commonly used and machine-readable format, which is part of why so many services now offer a self-service export.

    The Export Checklist: What to Export From Each Tool

    Use this as a starting point and adjust the cadence to how much each tool changes. The rule of thumb: export as often as you could stand to lose.

    ToolWhat to exportFormatHow often
    Accounting and invoicingTransactions, invoices, customer and supplier lists, reports for each tax yearCSV, plus PDF reportsMonthly, and at year end
    PaymentsPayments, payouts, refunds and feesCSVMonthly
    Store or booking systemOrders, customers, products or services, bookingsCSVMonthly
    Email marketingSubscriber list with consent and signup datesCSVMonthly
    CRM or client listContacts, companies, deal history and notesCSVMonthly
    Documents and filesYour working folders and shared documentsZIP archiveQuarterly
    AI toolsChat history, custom instructions and anything you reuseZIP or JSONQuarterly
    WebsiteContent, pages and settingsThe platform's backup or export fileBefore every major change

    Two lines in that table matter more than the rest. Your accounting records are the ones you may be required to produce years later, and the one tool you are most likely to switch is your accounting software, so export before you move, not after. If you are choosing a bookkeeping service, what to check before handing over your books includes asking how you get your data back out. Your email list is the asset that is hardest to rebuild, because the consent records go with it.

    How to Export Data From Common Tools

    The steps differ by tool but follow the same pattern. Two widely used examples, from each provider's own help pages:

    • Google (Gmail, Drive, Calendar and more). Google Takeout at takeout.google.com lets you pick which products to include, then choose a delivery method: a download link by email, or delivery to Google Drive, Dropbox, OneDrive or Box. You can choose a one-time export or scheduled exports every two months for a year. Google's help page says each archive expires in about 7 days and can be downloaded 5 times, so download it promptly.
    • ChatGPT. In ChatGPT, open your profile menu, then Settings, then Data controls, and under Export data select Export, then confirm. OpenAI's help page notes that self-service export is not available in Business, Enterprise or Healthcare workspaces, where the workspace owner controls data access.

    For any other tool, search its help centre for "export". If a tool you depend on has no export at all, treat that as a risk worth writing down, because it means the only copy of that part of your business sits somewhere you cannot reach on your own terms.

    Where Do I Find My Exported Files?

    It depends on how the tool delivers them. Most exports arrive in one of three ways:

    • An immediate download. The file goes to your browser's downloads folder, usually named Downloads on your computer.
    • An email with a link. Larger exports are prepared in the background and emailed when ready. Check spam if nothing arrives, and download promptly, because these links often expire.
    • Delivery to cloud storage. Some tools can save the export straight to a storage service you connect, where it will appear in a new folder.

    Once you have the file, rename it with the tool and the date, and move it to wherever you keep business records. A folder called "exports" with a subfolder per year is enough.

    What Happens When You Export Data?

    Nothing changes in the original tool. Exporting creates a copy; it does not delete, move or lock your account data, and the service carries on as normal. Two things do change, and both are your responsibility:

    • You now hold a second copy. If the export contains customers' personal details, that copy needs the same care as the original: stored securely, kept only as long as you need it, and deleted when you no longer do. A spreadsheet of client data sitting in a downloads folder is a common way that data leaks.
    • It is a snapshot. The file reflects the data on the day you exported it. Anything added afterwards is not in it, which is why the checklist sets a cadence rather than a one-off.

    If you handle personal data on behalf of clients, your data processing agreement may also say how and where copies can be kept, so check it before you start exporting client records.

    What Goes Wrong

    1. Exporting only when there is a problem. By then the account may be locked, the subscription ended or the tool gone. Export on a schedule, while everything works.
    2. Never opening the file. Exports can be capped, filtered to a date range or missing attachments. Open every first export and check it against what you expected.
    3. Choosing PDF for everything. PDFs are fine to read and useless to import. Keep lists and records as CSV so another tool can load them.
    4. Leaving exports in the downloads folder. Unnamed, undated files with personal data in them, on a laptop, are a risk rather than a backup.
    5. Assuming the tool keeps everything forever. Many services delete data some time after an account closes. Get your copy before you cancel, not after.

    Aziz's take: Put one recurring hour in the calendar, first working day of the month, called "exports". Go down the checklist, download, open, file. It is the most boring hour of the month and the only thing standing between you and rebuilding a client list from memory. A runbook is the natural home for the list of what to export and where it goes.

    Frequently Asked Questions

    Exporting data means taking a copy of information out of an app and saving it as a file in a standard format, such as CSV, JSON or PDF. The original data stays in the app; you get a second copy you control, which you can keep as a backup, open in a spreadsheet, or import into another tool.
    Look in the tool's settings for an option labelled Export, Download your data or Backup, usually under Settings, Account, Data or Privacy. Choose a format another program can open, CSV for lists and records, download the file, open it to check it is complete, and store it somewhere the original tool does not control. If you cannot find the option, search the tool's help centre for "export".
    Small exports usually download straight to your browser's downloads folder. Larger ones are often prepared in the background and sent as a link by email, which may expire after a few days, and some tools can deliver the export to a cloud storage service you connect. Once you have the file, rename it with the tool and the date and move it to your business records.
    Nothing changes in the original tool: exporting creates a copy and does not delete or move your data. You become responsible for the copy, so if it contains personal details it needs to be stored securely and deleted when no longer needed. The file is also a snapshot of that day, so anything added later is not in it.
    Monthly for the tools that change every day, such as accounting, payments, your store, your CRM and your email list, and quarterly for documents and AI tools. Always export before switching tools, before cancelling a subscription, and at the end of each financial year.