Processors

How to export your data from Square before you switch

Square says reports export as CSV files from the Dashboard, customers export from the Customer directory, and card-on-file data goes to a new processor by request, which Square says takes up to two weeks on average.

By Mike Akop, founderChecked 4 min read

On this page
  1. Reports and sales history
  2. Your customer list
  3. Saved cards
  4. What to do tonight
  5. Example: a boutique moving over a month
  6. How a second way to take cards helps
  7. Common questions
  8. Sources

In short

  • Reports export as CSV from the Dashboard, though some reports can be printed but not exported.
  • Customers export from Customers, Customer directory, Import / Export, then Export customers.
  • Square exports saved cards only to a PCI DSS Level 1 compliant processor, after the owner calls to verify.
  • Square says the card-on-file export takes up to two weeks on average.

Reports and sales history

Square's help page says report exports are CSV files you can open in a spreadsheet. In the Dashboard, go to Reports, choose a report, set its filters, click the export icon, choose all columns or selected columns through the gear icon, and click Start export. The page lists limits: cash drawer reports cannot be printed or exported, custom reports can be exported but not printed, and reports from the Transaction status pages can be printed but not exported. It does not mention date range limits, so export in smaller slices and check the totals.

Square's deactivation page also tells you to export payment history, the Item Library and the Customer Directory, and to download any Forms 1099-K, before closing an account. After deactivation Square says you lose access to payment history and tax forms.

DataHow Square says to export itCatch
Sales reportsReports, set filters, export icon, Start export (CSV)Cash drawer reports cannot be exported
Customer listCustomers, Customer directory, Import / Export, Export customersChoose all customers or groups
Cards on fileOwner calls support, Square sends encrypted file to new processorUp to two weeks; owner only
Item Library and payment historySquare says to export them before deactivatingSteps not covered here

Your customer list

Square's card-on-file page gives the customer steps: in the Dashboard go to Customers, then Customer directory, then Import / Export, then Export customers. Choose All Customers or Specific Groups, click Export, and download the CSV when it is ready. Open the file and spot check names, emails and phone numbers before you rely on it.

Compare the number of rows in the file with the customer count you see in the Dashboard, and look for blank email or phone columns. If you also have guest checkouts that never became profiles, pull a transactions report as well, so you can match those sales by hand later. A clean check now costs minutes. Finding a gap after the account is closed can cost you months of client history.

Saved cards

Moving saved cards is a different process. Square says only the account owner can request it, that the owner must call Square Support at 855-700-6000 (Monday to Friday, 6:00 AM to 6:00 PM PDT) so a representative can verify ownership, and that the new processor must be PCI DSS Level 1 compliant, because Square transfers data only to such providers. The file is an encrypted CSV with card_id, pan, expiration, postal_code and customer_id. Square says the average export takes up to two weeks and sends the file to your new processor. Bulk eCommerce migrations are not supported by this process, and the new processor can alternatively use Square's public APIs. The article mentions no fee.

What to do tonight

  1. Export the last 12 months of sales reports in monthly slices and save them in one folder.
  2. Export all customers, then open the CSV and check a sample.
  3. Export the Item Library and note which fields (price, SKU, stock) it carries.
  4. Decide whether you need saved cards moved. If so, call support early, since it can take two weeks.
  5. Keep the old account open until the new setup has run a full week.

Example: a boutique moving over a month

Example (round numbers, not from Square): a boutique with 3,000 customers and 800 items starts the card-on-file request on day one because of the two-week window. On day three it exports customers and items. On day ten it exports a full year of reports by month and checks that totals match the Dashboard. On day twenty the cards arrive at the new processor. Nothing is closed until the new system has taken real sales for a week.

How a second way to take cards helps

The data move from your old POS to MazalPOS is a free data move, and setup takes one day. Bring the CSV exports above, and the old account stays open while you test. Saved cards are a separate Stripe matter, so confirm with Stripe and Square support what can move. There is a 14-day trial with no card. See how to switch without losing data and switching.

Common questions

Square's report export page says CSV files, which open in a spreadsheet program.

Square says yes, only to a PCI DSS Level 1 compliant processor, after the owner calls support. It states an average of up to two weeks.

Square says only the account owner can request the card-on-file export. Report access depends on the reports permission.

Square lists cash drawer reports as not exportable and some status-page reports as print only.

Sources

Checked on 2026-11-08. Rules and prices change, so confirm on the official page before you act.

How to cancel Square: contract, closing steps and what to do firstSquare hardware: returns, warranty and what happens if you leaveMy Square account was deactivated: what to do next

Written by Mike Akop, founder of MazalPOS. We build and support the register, online store and staff app that stores from Las Vegas to Honolulu run on. Questions? Talk to a real person.

Not sure where to start?

Talk to a real
person today.

Tell us how your store works and we will show you MazalPOS with your own products.

14 days free. No card. Cancel anytime.

More like this

How to cancel Square: contract, closing steps and what to do firstSquare

Square's Payment Terms do not state a contract length or an early termination fee. To leave, an account owner deactivates from the Dashboard, but Square says you cannot reactivate that account afterward, so export your data first.

Square hardware: returns, warranty and what happens if you leaveSquare

Square's hardware policy says products bought directly from Square can be returned within thirty days of delivery in original condition, with a full refund and return shipping covered. After that, the policy lists warranty terms, not a buyback.

My Square account was deactivated: what to do nextSquare

If Square sent a deactivation notice that says you can appeal, the email has a link to start. Square says it typically reviews appeals within 48 hours, and an approval releases held funds and restores processing.

Square chargebacks: what happens and what to doSquare

Square says it holds the disputed amount right away, gives you seven days to answer, and the bank can take up to 90 days to decide. Square says there are no fees for its dispute management, but a lost dispute means the money goes to the customer.

Square card declined: what the message means and what to doSquare

Square says it is not told the exact reason a card was declined, and the issuer makes that call. Check the card details, have the customer call their bank, and if every card fails, check Square's status page before blaming the customer.

Square transaction fees: what each sale actually costsSquare

Square's fee page, checked 2026-11-08, lists in-person card payments at 2.6% + 15 cents on its entry plan, 3.5% + 15 cents for keyed cards and 3.3% + 30 cents online. The flat cents hurt small sales most.