Guide · Cronos

Eisenhower matrix in Excel: build it in 10 minutes

Quick answer

To make an Eisenhower matrix in Excel, build a task table with Urgent and Important columns as Yes/No dropdowns, add one IF formula that returns the quadrant, then show each quadrant's tasks in a 2×2 grid with the FILTER function. It takes about 10 minutes and needs no template.

Updated 2 min readGambit Studio

Use without installing →Free in your browser, no sign-up

Step by step

  1. In row 1, type the headers: Task (A), Urgent (B), Important (C), Quadrant (D).
  2. Select B2:C100, go to Data > Data Validation > List, and enter Yes,No.
  3. In D2, enter =IF(AND(B2="Yes",C2="Yes"),"1 Do",IF(C2="Yes","2 Schedule",IF(B2="Yes","3 Delegate","4 Drop"))) and fill it down.
  4. On a second sheet, draw a 2×2 grid and label the quadrants.
  5. In each box, use FILTER to list that quadrant's tasks, e.g. =FILTER(Sheet1!A2:A100,Sheet1!D2:D100="1 Do","").
  6. Add conditional formatting to color column D by quadrant.

The quadrant formula, explained

UrgentImportantResult
YesYes1 Do
NoYes2 Schedule
YesNo3 Delegate
NoNo4 Drop

If you don't have FILTER

FILTER needs Excel for Microsoft 365 or Excel 2021 and later. In older versions, sort the table by column D, or use an AutoFilter on the Quadrant column and copy the results into the grid. ExcelDemy shows a version built with helper formulas (ExcelDemy).

Tips

  • Add a Deadline column and sort quadrant 1 by it.
  • Add a Done checkbox and exclude done rows from FILTER with a second condition.
  • Same formulas work in Google Sheets: Eisenhower matrix in Google Sheets.

Prefer not to build anything? The free online Eisenhower matrix runs in the browser.

Cronos, by Gambit Studio, is the phone version of this sheet: on iPhone or iPad you drop each task into one of four quadrants by urgency and importance, no formulas needed.

Sources

  1. ExcelDemy: How to make an Eisenhower matrix template in Excel
  2. The American Presidency Project: Eisenhower's address in Evanston, Illinois, August 19, 1954

Free in your browser

Use it free now, nothing to install

The core of the app works right in your phone or computer browser.

Frequently asked questions

What people ask most about this, answered with the source.

Is there an Eisenhower matrix template in Excel?
Excel has no built-in one, but you can build it in minutes with two Yes/No columns, an IF formula and FILTER.
What formula do I use for an Eisenhower matrix in Excel?
=IF(AND(B2="Yes",C2="Yes"),"1 Do",IF(C2="Yes","2 Schedule",IF(B2="Yes","3 Delegate","4 Drop")))
Does FILTER work in all Excel versions?
No, it needs Microsoft 365 or Excel 2021 and later. Use sort or AutoFilter in older versions.
Can I use a score instead of Yes/No?
Yes: rate urgency and importance 1 to 5 and treat 4 or more as Yes in the formula.
CronosPriority control Eisenhower
Use without installingGet