Air Coalesce Workspace q3_customer_review new project

Drop your spreadsheets

CSV and Excel files · up to 12 at a time

X Customers_Q3.xlsx 12,481 rows
ABCD
CustomerIDCompanyCityPlan
2C-10241Northwind CoffeeAustinPro
3C-10242Bluefin LogisticsSeattleTeam
4C-10243Acme StationersBoiseStarter
5C-10244Harbor & PineAustinPro
6C-10245Sundial StudiosDenverTeam
7C-10246Foxglove Co.AustinPro
X Orders_2026.xlsx 48,920 rows
ABCD
OrderIDCustomerIDAmountDate
2O-88401C-10241$420Jul 02
3O-88402C-10244$1,180Jul 02
4O-88403C-10241$95Jul 03
5O-88404C-10246$2,640Jul 03
6O-88405C-10242$310Jul 04
7O-88406C-10244$760Jul 04
matched on CustomerID
2 files imported · scanning for shared keys primary key auto-detected

Customers_Q3 + Orders_2026

61,401 rows · joined on CustomerID · 1 derived view
Merge complete
X customers_q3_review.xlsx 8 columns · mapping saved
ABCDEFG
CustomerIDCompanyCityPlanOrderIDAmountDate
2C-10241Northwind CoffeeAustinProO-88401$420Jul 02
3C-10241Northwind CoffeeAustinProO-88403$95Jul 03
4C-10242Bluefin LogisticsSeattleTeamO-88405$310Jul 04
5C-10244Harbor & PineAustinProO-88402$1,180Jul 02
6C-10244Harbor & PineAustinProO-88406$760Jul 04
7C-10246Foxglove Co.AustinProO-88404$2,640Jul 03
8C-10243Acme StationersBoiseStarter
61,401 of 61,401 rows matched · 1,080 customers with no orders kept
X customers_q3_review.xlsx ask about this data
I joined Customers_Q3 with Orders_2026 on CustomerID. Ask anything about the merged view.
Which city brought in the most revenue this quarter?
And how is monthly revenue trending?
Ask about this data…
from chat · “which city brought in the most revenue this quarter?”

Revenue by city

customers_q3_review.xlsx · Q3 2026 · 4 cities
Austin
$48,210
Seattle
$31,640
Denver
$22,180
Boise
$9,470
$111,500 total · top city: Austin · SUMIFS(Amount, City)
from chat · “and how is monthly revenue trending?”

Monthly revenue, Q3 2026

customers_q3_review.xlsx · Jul – Dec · +38% growth
$90k $60k $30k $0 Jul Aug Sep Oct Nov Dec $84.2k
total Q3–Q4: $407k · every month higher than the last
coalescing 61,401 rows