--- title: Export orders to a CSV file (Export Orders To CSV) description: "The Export Orders To CSV add-on of Ultimate Membership Pro downloads your orders as a CSV file, filtered by order status and date, for your spreadsheet or accounting tool." url: "https://ultimatemembershippro.com/docs/export-orders-to-csv/" updated: "2026-10-19" category: "Pro Add-ons" --- # Export orders to a CSV file (Export Orders To CSV) 5 minBeginnerExport Orders To CSV add-onUltimate Membership Pro 14.2+ In Ultimate Membership Pro, the Export Orders To CSV add-on turns your orders into a CSV file that you download and open in a spreadsheet. It is handy for bookkeeping, for sending a month of sales to your accountant, or for building your own reports. This guide covers how to open the add-on, how to pick the orders to export, what each column of the file contains, and how to download it. Before you start - The **Export Orders To CSV** add-on is installed and active. It's a Pro add-on, included in the Full Package and Agency plans. See [Install a Pro add-on](https://ultimatemembershippro.com/docs/install-pro-add-ons/). - Your license is active. See [Find and activate your license key](https://ultimatemembershippro.com/docs/where-to-find-your-license-key/). - Your site has orders to export. They are listed under Ultimate Membership Pro*›*Payment History. See [Manage payments and orders](https://ultimatemembershippro.com/docs/manage-payments-and-orders/). ## Open the add-on 1. Go to Ultimate Membership Pro*›*Modules. The card is in the **Payments & Billing** group; you can also type its name in the **Search modules…** box. 2. Click the **Export Orders to CSV** card to open its screen. [![Modules screen: the Export Orders to CSV card with the Active label, highlighted](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-01-card.png)](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-01-card.png) The Export Orders to CSV card in Modules. The screen starts with the switch **Activate/Hold Export Orders To CSV Integration**. It is on by default. If you turn it off, switch it on again and click Save Changes before you export: exports run only while it is on. ## Choose which orders to export [![Export Orders To CSV screen: the switch on, Export by Order Status set to Completed Orders, Start date 01-10-2026, End date 01-11-2026 and the Run Export button, numbered 1 to 5](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-02-settings.png)](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-02-settings.png) The export screen, filled in for October. 1Activate/Hold Export Orders To CSV Integration Lets the screen export orders. Save Changes keeps this switch. Default: **On** 2Export by Order Status: Which orders go into the file. - **All Orders**: every order, whatever its status (completed, pending, failed, refunded and so on). - **Completed Orders**: paid orders only. - **Pending Orders**: orders still waiting for payment, such as bank transfers you haven't confirmed. Default: **All Orders** 3Start date Optional. The first day to include, written day-month-year, for example `01-10-2026`. Click the field to pick the day from a calendar. Leave it empty to start from your oldest order. 4End date Optional. Orders are included up to, but not including, this day. To export all of October, enter `01-11-2026`. Leave it empty to include everything up to today. 5Run Export Builds the file with the choices above. Leave both dates empty to export every order of the chosen status. ## Run the export and download the file 1. Click Run Export. The screen reloads. 2. Click Download, which now appears next to Run Export. The CSV file opens or downloads in your browser. [![The Run Export button with the new Download button next to it, highlighted](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-03-download.png)](https://ultimatemembershippro.com/wp-content/uploads/2026/10/ump-ao-export-orders-03-download.png) The Download button appears after an export. Orders are listed from the oldest to the newest. The file is temporary: the next export creates a new file and removes the previous one, so download it straight away. ## What the file contains The first row holds the column names. Each following row is one order: Columns, in order ``` ID, Code, Customer Email, Customer ID, First Name, Last Name, Membership, Membership ID, Amount, Taxes, Total Amount, Currency, Payment Method, Coupon, Transaction ID, Date, Status ``` ID and Code The order number, and the order code that is also the invoice number, for example `IUMP000004`. See [Send invoices](https://ultimatemembershippro.com/docs/order-invoices/). Customer Email, Customer ID, First Name, Last Name Who placed the order. Customer ID is the member's WordPress user ID. Membership and Membership ID The Membership that was bought. Amount, Taxes and Total Amount The price before taxes, the taxes, and the total the member was charged. Amount equals Total Amount when no taxes apply. Currency The currency code of the order, for example USD. Payment Method, Coupon, Transaction ID The gateway used, the coupon code if one was applied, and the gateway's transaction reference. Date and Status When the order was created, written in your site's date and time format, and its status, for example Completed or Pending. Tip - Values are separated by commas, so the file opens directly in Excel, Numbers or Google Sheets. - For a monthly routine, export Completed Orders with the first day of the month as Start date and the first day of the next month as End date. ## Example: October sales for the accountant **Coaching Club**A file of October's paid orders for the accountant. **Export by Order Status:** : Completed Orders **Start date** : 01-10-2026 **End date** : 01-11-2026 **Result** : One row per paid order, for example Pro Monthly at $19 and Annual Pass at $149 ## Learn more about Export Orders To CSV - [Export Orders To CSV add-on page](https://ultimatemembershippro.com/addon/export-orders-to-csv/): what it does, at a glance. - [All Pro add-ons for Ultimate Membership Pro](https://ultimatemembershippro.com/pro-addons/). - [Ultimate Membership Pro plans](https://ultimatemembershippro.com/pricing/): Pro add-ons come with the Full Package and Agency plans. - [Importing CSV files into Google Sheets](https://support.google.com/docs/answer/40608). - [Opening CSV files in Excel](https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba). ## Troubleshooting Why doesn't a Download button appear after Run Export? Either the Activate/Hold switch is off, or no order matches your choices. Switch it on and save, then widen the status or the dates. Remember that orders on the End date itself are not included. Why is the Payment Method column empty for some orders? The column shows the name of the gateway recorded for the order. When the order has no gateway recorded, the cell is empty. Can I export orders by Membership or by customer in Ultimate Membership Pro? The add-on filters by order status and date only. Export the file, then filter the Membership or Customer Email columns in your spreadsheet. Which date format should I type? Day-month-year with dashes, for example 01-10-2026. Clicking the field opens a calendar that fills it in for you. ## What's next [**Manage payments and orders**Payment History and order statuses.](https://ultimatemembershippro.com/docs/manage-payments-and-orders/)[**Read your membership reports**Sales and member numbers in the admin.](https://ultimatemembershippro.com/docs/read-your-membership-reports/)[**Send invoices**Where the order code comes from.](https://ultimatemembershippro.com/docs/order-invoices/)[**Restart invoice numbering (Reset Invoice ID)**Start the order count again from 1.](https://ultimatemembershippro.com/docs/reset-invoice-id/)