How to get UK Gazette Corporate Insolvency Notices

Official The Gazette corporate insolvency notices: administrations, liquidations, winding-up petitions and related company notices. thegazette.co.uk is one page of it. A run reads that public list and saves one row per result.

One row per result

A row has Company Name, Notice Code, Notice Type, Published. The columns are listed in the schema on this page.

New rows from that site

Each run reads thegazette.co.uk again. Put it on a schedule and the next file is the latest rows from that site.

UK Gazette Corporate Insolvency Notices in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`companyName`	Company Name	`INDIAN ACE BARNET LIMITED`
`noticeCode`	Notice Code	`2441`
`noticeType`	Notice Type	`Appointment of Liquidators`
`published`	Published	`2026-09-22T12:10:16`
`updated`	Updated	`2026-09-22T12:10:16+01:00`
`noticeUrl`	Notice Url	`https://www.thegazette.co.uk/notice/5215326`
`contentSnippet`	Content Snippet	`INDIAN ACE BARNET LIMITED (Company Number: 13967648 )…`
`sourceUrl`	Source Url	`https://www.thegazette.co.uk/insolvency/notice/data.json?...`
`scrapedAt`	Scraped At	`2026-09-22T12:00:00+00:00`

companyNameCompany NameINDIAN ACE BARNET LIMITED
noticeCodeNotice Code2441
noticeTypeNotice TypeAppointment of Liquidators
publishedPublished2026-09-22T12:10:16
updatedUpdated2026-09-22T12:10:16+01:00
noticeUrlNotice Urlhttps://www.thegazette.co.uk/notice/5215326
contentSnippetContent SnippetINDIAN ACE BARNET LIMITED (Company Number: 13967648 )…
sourceUrlSource Urlhttps://www.thegazette.co.uk/insolvency/notice/data.json?...
scrapedAtScraped At2026-09-22T12:00:00+00:00