)
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 Locations from Square into Excel helps you track each store or online outlet in one place.
This tutorial covers importing your Locations object with Coefficient and setting up auto-refresh.
TLDR
-
Step 1:
Install Coefficient, connect Square.
-
Step 2:
Choose “Import from Objects” → “Locations.”
-
Step 3:
Click “Import,” verify fields.
-
Step 4:
Optionally, enable auto-refresh.
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 Locations from Square?
1. Open Coefficient sidebar → “Import from Objects.”2. Select “Locations” → “Import.”Coefficient loads all locations into Excel.
-
How do I get a list of Locations in Square?
Use “Import from Objects,” choose “Locations.”All storefronts and online endpoints appear.
-
How to export Locations to Excel?
Click “Export to Excel,” map fields, then run.Your sheet updates with live location data.
-
How do I update Locations from Excel to Square?
Choose “Export to Square,” configure mappings, then click “Update.”Spreadsheet edits sync back to Square.
-
How to send email alerts about Locations data?
Create an email automation in Coefficient.Select Locations fields and timing.Get notifications on added or changed locations.
Trusted By Over 50,000 Companies
