How-To Guide
7 min read

How to Export Refunds from Shopify (2026 Guide)

Follow these steps to export your Shopify refunds as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.

Export Steps

1

Log in to your Shopify admin

Go to your-store.myshopify.com/admin and sign in with your credentials. You need at least the Orders permission to access the export feature. Shopify does not have a dedicated refunds export, so you will export orders and then filter for refunded ones.

Warning: Shopify does not offer a standalone refunds CSV export. Refund data is embedded in the standard orders export. You must filter the exported data by the Financial Status column.
2

Navigate to the Orders page

Click Orders in the left-hand sidebar of your Shopify admin. This displays all orders in your store. Before exporting, you will apply filters to isolate refunded orders so the exported file is easier to work with.

3

Filter orders by Financial Status

Use the filter bar at the top of the orders list. Click on the Payment Status filter and select 'Refunded' to see only fully refunded orders. If you also need partially refunded orders, you may need to run a second export with the 'Partially refunded' filter, since Shopify's native filter only allows one payment status at a time.

Tip: If you need both fully refunded and partially refunded orders in one file, export all orders and filter the CSV file afterward using the 'Financial Status' column in your spreadsheet.
Shopify admin Orders page with filter options for narrowing orders by payment status
Filter by Payment Status to isolate refunded orders before exporting.
4

Click Export and select your scope

With the refund filter active, click the Export button in the upper-right corner. In the export dialog, choose the option that matches your filtered results, such as 'Orders matching your search' or 'All orders'. If you filtered first, select the matching search option to export only those filtered orders.

5

Select CSV format and export

Choose 'CSV for Excel, Numbers, or other spreadsheet programs' as the file format. Then click 'Export orders' to start the download. For small exports, the file downloads immediately. Larger exports are emailed to the store owner.

6

Open the CSV and locate refund columns

Open the exported CSV in your spreadsheet application. Look for the 'Refunded Amount' column, which shows the dollar amount refunded for each order. The 'Financial Status' column will read 'refunded' or 'partially_refunded' for the relevant rows. If you exported all orders, filter or sort by the Financial Status column to isolate refund records.

Tip: The 'Refunded Amount' column shows the total refund per order. For partial refunds, compare it against the 'Total' column to see how much of the original order was refunded.
7

Note: Refund reason is not in the CSV

The native Shopify CSV export does not include a 'Refund Reason' column. To find refund reasons, click into individual orders in the Shopify admin where the reason is displayed in the refund details section. For bulk access to refund reasons and line-item breakdowns, use the free Shopify Admin API (refunds endpoint).

Warning: The refund date is also not explicitly included in the native CSV. The 'Created at' column shows when the order was placed, not when it was refunded. For exact refund dates, check individual orders in the admin or use the Shopify API.

Required Refunds Fields

Field Type Description Example
Name Text Order name/number #1001
Created at Date/Time Order creation date/time (NOT refund date) 2025-01-20T10:30:00-05:00
Financial Status Choice Payment status - filter for 'refunded' or 'partially_refunded' refunded
Refunded Amount Currency Amount refunded (native CSV column) 149.99

Your Shopify export must include these fields for successful conversion.

Next Step Once you have exported your refunds, use one of the converter tools below to transform your file.

Frequently Asked Questions

Shopify exports refunds as a CSV (Comma Separated Values) file, which can be opened in Excel or Google Sheets.
The file is usually downloaded to your browser's default Downloads folder. Check your Downloads folder or look for the download notification.