)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Importing Merchants from Square into Excel gives you centralized insight into each seller’s profile and status.
This guide shows you how to import your Merchants object with Coefficient and keep it updated automatically.
TLDR
-
Step 1:
Install Coefficient and connect to Square.
-
Step 2:
Select “Import from Objects” → “Merchants.”
-
Step 3:
Click “Import” and verify columns.
-
Step 4:
Enable auto-refresh if needed.
Step-by-Step Guide
What Square Data is Imported?
- Disputes
- Bank Accounts
- Gift Cards
- Merchants
- Locations
- Payments
- Invoices
- Payouts
- Customers
- Refunds
Related Square Use Cases
How to Import Payouts Data from Square into Google Sheets
Learn how to easily import live Square Payouts data into Google Sheets using Coefficient for streamlined payout analysis and reporting.
How to Import Customers Data from Square into Google Sheets
Learn how to easily import live Square Customers data into Google Sheets using Coefficient for streamlined customer analysis and reporting.
How to Import Disputes Data from Square into Google Sheets
Learn how to easily import live Square Disputes data into Google Sheets using Coefficient for streamlined analysis and reporting.
Frequently Asked Questions
-
How to get Merchants from Square?
1. Open Coefficient sidebar → “Import from Objects.”2. Select “Merchants” → “Import.”Coefficient pulls all merchant profiles into Excel.
-
How do I get a list of Merchants in Square?
Use “Import from Objects,” choose “Merchants.”You’ll see every registered seller.
-
How to export Merchants to Excel?
In Coefficient, click “Export to Excel,” map fields, then run.Your sheet updates with live merchant data.
-
How do I update Merchants from Excel to Square?
Choose “Export to Square,” set mappings, then click “Update.”Excel edits sync back to Square.
-
How to send email alerts about Merchants data?
Configure an email automation in Coefficient.Select Merchants fields and schedule.Receive alerts on profile changes.
Trusted By Over 50,000 Companies
