US layoff notices, live in your spreadsheet

Paste one formula into a Google Sheets cell. You get every US WARN Act layoff notice in the window you picked, and it refreshes itself when you reopen the file. No signup, no API key, no download, no macro.

Counts measured when this page was built, from the same files the formulas fetch. Built 2026-09-19; newest notice date in the archive is 2026-11-01.

Three formulas

Everything from the last 90 days

Every US WARN notice with a notice date in the last 90 days — 753 rows, 74 KB.

=IMPORTDATA("https://cdn.jsdelivr.net/gh/APVentureEngine/warn-act-notices@main/data/sheets/us-last-90-days.csv")

download this CSV directly

Everything from the last 12 months

Every US WARN notice with a notice date in the last 12 months — 3,836 rows, 381 KB.

=IMPORTDATA("https://cdn.jsdelivr.net/gh/APVentureEngine/warn-act-notices@main/data/sheets/us-last-365-days.csv")

download this CSV directly

Just the biggest layoffs of the last 12 months

The biggest layoffs of the last 12 months, by employees affected — 200 rows, 20 KB.

=IMPORTDATA("https://cdn.jsdelivr.net/gh/APVentureEngine/warn-act-notices@main/data/sheets/largest-last-365-days.csv")

download this CSV directly

One state only

Pick your state and paste its formula. Each file holds the last 12 months for that state. 45 states and territories filed at least one notice in the window.

What lands in the sheet

Eight columns, one row per notice: notice_date, state, company, location, employees_affected, effective_date, notice_type, id. Company names are as filed by the state agency. id is stable across days, so you can VLOOKUP against yesterday's copy to see what is new.

How fresh it is

These files are rebuilt every morning from the state agency sources and pushed to the public GitHub repo. The formula URL is the jsDelivr CDN copy of that repo; the same run purges the CDN cache right after the push, so the URL your sheet already points at serves the new rows within minutes of the rebuild. Google decides when to refetch an IMPORTDATA URL — reopening the file or editing the cell forces it.

Why a CDN URL: jsDelivr publishes an anonymous request count per file, so we can tell whether anyone actually uses these formulas — no cookies, nothing identifies you or your sheet, and the totals are public. Prefer the origin? Every "download this CSV directly" link below a formula is the same file on this host.

Excel and LibreOffice

Same URLs. In Excel: Data → From Web, paste the URL, then Refresh All. In LibreOffice Calc: Sheet → Link to External Data. Every file is a plain public CSV over HTTPS with no key and no cookie.

The whole archive

The full history is 61,345 notices and about 9 MB — too much to want inside a spreadsheet. Take it as a direct CSV download, as JSON over HTTP, or from the GitHub repo. All of it is CC BY 4.0.