Straight Figures Apply

QuickBooks Desktop, answered

QuickBooks Desktop export to Excel: the row limit, the greyed-out button, and the way around both

The Excel button is greyed out when QuickBooks cannot find a copy of Excel it recognises. An export stops short when the report is longer than the format holds. Both are fixable. Both also mean the same thing: you are exporting the same reports every week by hand.

What we do about it

We take your data out of QuickBooks as reports, put it in a database, and connect it to your Claude or ChatGPT. QuickBooks stays as it is.

The first step is small on purpose. We model one year of your sales data and get on a live call where you ask and your own numbers answer. You give us the three questions you most want answered, and we get you those answers or figure out how we can deliver them. You keep the database, connected to your Claude or ChatGPT.

The first step is $950, credited in full toward your setup if you go ahead. If you don’t, we delete the project and your data doesn’t stay with us. If it earns its place, we keep it current every week and send the reports you pick.

Nothing we build can write to your books.

ApplyEleven quick questions to see if we’re a good fit.

The greyed-out button

QuickBooks needs an installed, supported Excel. Microsoft 365 from the web store, a 32-bit QuickBooks next to a 64-bit Office, or an Office repair after the QuickBooks install can all leave the button grey. Intuit’s help article on the export walks through the fixes and usually works.

The row limit

The older Excel format stops at 65,536 rows, and some reports hit a lower limit. A few years of transaction detail on a mid-sized company runs past it. The workaround is a year at a time, or CSV.

A report that no longer fits in a spreadsheet is a dataset. Datasets belong in a database.

The way around both

Export once. A customer list, an item list, and one sales-by-customer detail report with the dates typed in. In a database the row count stops mattering and every month’s total is checked against QuickBooks’ own summary. From then on the export is the new week, once, on a schedule.

Here is what that history looks like on a fictional company, and one question you cannot ask of an export.

For example

How big is three and a half years of our sales history, line by line?

20232023: 9,1809,18020242024: 10,78910,78920252025: 8,2878,28720262026: 5,2775,277
YearInvoices and credit memosLines
20231,7759,180
20242,07610,789
20251,5578,287
20261,0025,277

6,410 transactions, 33,533 lines. That is more rows than the older Excel export format holds, from a mid-sized company. In a database the row count stops mattering.

How that was computed 
select substr(t.date, 1, 4) as year,
       count(distinct t.id) as transactions,
       count(*) as lines
from txn_lines l
join txns t on t.id = l.txn_id
group by year
order by year

For example

Which customers are slowing down before they stop?

Customers who bought more than $25,000 in the six months to January and are down by 40% or more in the six months since, but are still ordering:

Dunmore ConstructionDunmore Construction: −50%−50%Fenner BuildersFenner Builders: −87%−87%Maddox CarpentryMaddox Carpentry: −90%−90%Wexler Custom DecksWexler Custom Decks: −57%−57%Ellery RenovationsEllery Renovations: −77%−77%Fenner ContractingFenner Contracting: −60%−60%Ellery Home ImprovementEllery Home Improvement: −58%−58%Ruud CarpentryRuud Carpentry: −41%−41%Ecklund ConstructionEcklund Construction: −41%−41%
CustomerSix months to JanuarySix months sinceChange
Dunmore Construction$91,604$45,669−50%
Fenner Builders$45,125$5,696−87%
Maddox Carpentry$35,250$3,638−90%
Wexler Custom Decks$55,029$23,717−57%
Ellery Renovations$39,050$9,121−77%
Fenner Contracting$40,306$16,024−60%
Ellery Home Improvement$40,152$17,032−58%
Ruud Carpentry$35,976$21,336−41%
Ecklund Construction$34,122$20,143−41%

9 accounts, $254,238 less than the previous half-year between them. Every one is still a customer today.

How that was computed 
with recent as (
    select customer, sum(amount) as last_6
    from v_sales_lines
    where date > '2026-01-27'
    group by customer),
before as (
    select customer, sum(amount) as prior_6
    from v_sales_lines
    where date > '2025-07-27' and date <= '2026-01-27'
    group by customer)
select b.customer, round(b.prior_6) as prior_6_months, round(r.last_6) as last_6_months,
       round(100.0 * (r.last_6 - b.prior_6) / b.prior_6) as change_pct
from before b
join recent r on r.customer = b.customer
where b.prior_6 > 25000 and r.last_6 < 0.6 * b.prior_6
order by b.prior_6 - r.last_6 desc

Northgale Building Products is a fictional company. Every name, figure and supplier on this page is made up, built to behave like a real three-and-a-half-year QuickBooks Desktop file so we can show real screens without showing anyone’s real numbers. Data as of the 2026-07-27 refresh; the last invoice in the file is dated 2026-07-24.

Short answers

  • Why is Export to Excel greyed out in QuickBooks Desktop?QuickBooks cannot see a supported Excel. Check that Office is a desktop install, that the 32- or 64-bit version matches, and repair Office.
  • What is the QuickBooks Desktop Excel export limit?It depends on the format and the report. The older format tops out at 65,536 rows. Export a year at a time, or to CSV.
  • Do I still need to export if I use a database?Only the new week, and only the same three reports. The history never has to be exported again.

Related questions