Skip to main content

How do I export data from Subi?

Easily export and analyze your subscription, customer, order, or billing data with Subi’s Export Builder.

If you need to export critical data from Subi for analysis, reporting, or operational purposes, the Export Builder is designed for you. With the Export Builder, you can export key subscription, customer, order, and billing details as CSV files that can be opened in spreadsheet tools like Excel or Google Sheets.

This article walks you through every step, from accessing the Export Builder to downloading your data.


Accessing the Export Builder

To get started:

  1. Go to your Subi panel.

  2. In the left-hand navigation menu, click on Settings, then select Data export.

You’ll now see the Export Builder interface, where you can choose which type of data you’d like to export.

Subi logo

Selecting the Data to Export

The Export Builder lets you export several types of data:

  • Subscription contracts (.csv): Includes active, canceled, expired, paused subscriptions, or a changes log.

  • Customers (.csv): Includes customer information and contact details.

  • Orders (.csv): Contains order details linked to subscriptions.

  • Billing attempts (.csv): Includes processed, failed, or retried billing attempts.

Subi logo

Step-by-Step Guide to Exporting Data

1. Choose the Data Type

  • Under the section labeled Which data are you looking for?, select the type of data you wish to export.

  • For example, to export subscription contracts, select Subscription contracts (.csv) and choose your desired filters (such as All, Active, or Canceled).

2. Set the Date Range

  • Use the Date range section to define the time period for your export. For Subscription contracts (.csv), Export entire data history is checked by default, so the export includes every subscription in the status you chose, whenever it was created. For the changes log, Orders (.csv) and Billing attempts (.csv), the last 30 days is selected by default.

  • To change the date range, click Change date range and select your preferred start and end dates.

Subi logo

Subi logo
  • To export only subscriptions created in a date range, uncheck Export entire data history, then click Change date range. For the other data types, check Export entire data history to export all historical data.

Subi logo

3. Export the Data

  • Once you’ve selected the data type and date range, click the Export button.

  • The system will generate a CSV file and automatically download it to your computer.

Subi logo

Keeping a Google Sheet up to date

Want a Google Sheet that always shows your latest subscription data, without exporting a new CSV every time? Use Sync to Google Sheets on the Data export page. It gives you a private link to the export you chose, and your sheet reads that link on its own.

  1. In Settings › Data export, choose the data type, its status and the date range, the same way as for a CSV export.

  2. Click Sync to Google Sheets, next to Export. A window opens with your Sync link and a Google Sheets formula, each with a copy button.

  3. In Google Sheets, paste the formula into one cell, for example A1 of an empty tab. The first time, Google Sheets shows a yellow bar saying some formulas are trying to send and receive data from external parties. Click Allow access, and your data appears. Until you do, the cell shows #REF!.

  4. In Excel, go to Data › Get Data › From Web and paste the link instead.

Good to know about synced sheets:

  • Google Sheets checks the link for new data about once an hour while the sheet is open. You never need to export that data again.

  • The sheet holds exactly what the Export button would download with the same choices. A date range such as the last 30 days moves forward each day, so the sheet always shows the most recent 30 days. A custom range keeps its two dates.

  • Clicking Sync to Google Sheets again with the same data type, status and date range shows the same link, so you do not end up with duplicates.

  • Every link you make is listed in the Synced sheets card under the export options, with its Filters, the day it Started on and when a sheet Last updated from it.

  • Anyone with the link can read the data, just like a password. Keep it private, and share your sheet as Viewer only.

  • To stop a link, click Stop syncing on its row in Synced sheets (or in the link window) and confirm. A stopped link cannot be turned back on. Your sheet keeps the data it already has until Google Sheets next checks the link, and then shows an error instead of the data. To sync again, click Sync to Google Sheets for a new link.

  • Sync to Google Sheets needs a plan that includes the Subi API. On a plan without it, the button shows a lock with the plan you need. If your store moves to a plan without the API, or you uninstall Subi, every link stops for good.


Building a list of only some subscribers

Need a list of only some of your subscribers, for example everyone on one plan who was charged last week, with their phone number and shipping address for an SMS campaign or a courier sheet? You can build that list yourself in Analytics instead of exporting every contract.

  1. In Settings › Data export, select Subscription contracts (.csv).

  2. Under the export details, click Build the list in Analytics. The Contracts Overview report opens as a subscriber list covering every contract from your first one to today, with the columns Full Name, Email, Phone, Subscription Plan, Delivery Frequency, Product Title, Last Charged On and Status.

  3. Add filters to narrow the list. Subscription Plan, Product Title and Delivery Frequency let you pick from your own plan, product and frequency names. Date columns such as Last Charged On offer is between, which includes both the start and end dates.

  4. To add address details, use Dimensions to add Shipping Address, City, Province / State, Zip / Postal Code or Country.

  5. Click Export CSV. In the window that opens, choose which records to export (those matching your filters, or all records in the date range) and which columns (those on screen, or every column), then click Export N records.

Good to know about this list:

  • A subscription with two products appears as two rows, one per product.

  • Phone and address come from the subscription's shipping address.

  • Analytics data refreshes every 4 hours, so a subscription created in the last few hours may not appear yet. For a complete up-to-the-minute file, use the Export button in Data export.

  • Phone numbers are exported exactly as entered, for example +1 503-555-0142. If Excel or Google Sheets shows a number starting with + as an error, format that column as text before opening the file; the file itself is correct.


Available Exports

To view a complete list of export options and data fields, see our detailed guide:
​Available exports in the Subi Export Builder


Tips for Using the Export Builder

  • Filter by Data Type: Use filters such as subscription status or billing attempt type to narrow your exports and avoid unnecessary data.

  • Large Exports: For large data sets, set a specific date range to keep loading times manageable.

  • File Format: All exports are in CSV format, ready for use in Microsoft Excel, Google Sheets, or similar tools.


FAQs

Q: How often can I export data?
A: You can export data as often as needed. There are no limits on the number of exports.
​

Q: Can I automate exports?
A: Yes, into a spreadsheet. In Settings › Data export, choose your data and click Sync to Google Sheets, then paste the formula it gives you into Google Sheets. The sheet then updates on its own, about once an hour while it is open. A CSV download from the Export button is still started by hand each time.
​

Q: How do I export only the subscribers on one plan, with their phone numbers?
A: In Settings › Data export, select Subscription contracts (.csv) and click Build the list in Analytics. Add a Subscription Plan filter, pick your plan, then click Export CSV. The list includes each subscriber's name, email, phone, plan, delivery frequency, product, last charge date and status.
​

Q: Can I access my data if I no longer have access to my subscriptions?
A: Yes, even if you don’t have access to your subscriptions, you can still request your subscription data by contacting our customer care team. They will assist you in retrieving your information.


Next Steps

For more on managing and analyzing your subscription data, check out these related resources:


Need Help?

Feel free to contact our support team. We're here for you anytime:

  • Live Chat: Message us from within the Subi app or your Shopify Admin.

  • Email: Reach us at [email protected].

Did this answer your question?