About Services Tools Blog Contact us

Trade Show Exhibitor Directory

Collects an exhibitor directory spread over many pages into a company spreadsheet, ready for a website lookup afterwards.

  • Web Scraping & Crawling
  • Water utilities
  • Pipeline
  • Productised
  • Local/private
  • 2025

The problem

Sales wanted the full exhibitor list without clicking through a directory one page at a time. The show site showed companies a page at a time, and copying by hand missed stands near the end. The list was only useful as a spreadsheet.

What it does

The tool requests each page of the exhibitor directory and writes the companies into a spreadsheet with the details the show published. A later Serper web search can fill any blank websites. It follows the show site's page layout, so if the site is redesigned the tool needs an update. The spreadsheet from the last run is the deliverable.

Outcomes

  • The full exhibitor list is a spreadsheet and not a directory to click through.
  • Stand and company fields match what the show published.
  • Blank websites are left visibly empty, ready for a follow-on lookup.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Exhibitor directory

North Weir Water Show

Halls A to E. The show publishes company, stand and website. Websites the stand holder left empty stay empty.

Pages
  1. Page 1
  2. Page 2
  3. Page 3
  4. Page 4
  5. Page 5
  6. Page 6
  7. Spreadsheet
Event 1842, six pages

Spreadsheet

Export from Collect writes the file. Blank websites stay empty fields.

Markup changed

Same event, directory redesigned

Page 3 no longer uses the company card the parser knows. Pages already stored are kept. Later pages are not requested.

Event 1842, expecting the old card markup

Blank websites 30 of 142

These stands published a company and a stand, and left the website empty. The spreadsheet keeps the blank so a later lookup can fill it. The name is not guessed.

Ready for website lookup
CompanyStandWebsiteNext
Reed Valve WorksB14Lookup
Quay MeteringA18Lookup
Marsh Pump CoB22Lookup
Calder PipeA04Lookup
Weir Gate ValvesD12Lookup
Silt & SpanC08Lookup
Nene AerationE03Lookup
Holt PenstockA21Lookup

Eight of the 30 blanks. Fen Lock, Pebble, Hale Screen and Bramble already published a site, so they are not in this list.

How it works

  1. Request page one of the exhibitor directory and read how many pages there are.
  2. Request each remaining page.
  3. Read the company name and the published details from each page.
  4. Write one spreadsheet row per exhibitor.
  5. Leave blank websites for the Serper lookup.

Pipeline

flowchart LR
  A[Event id] --> B[Page one]
  B --> C[Remaining pages]
  C --> D[Parse companies]
  D --> E[Spreadsheet]
  E --> F[Blank websites]