Swim Drink Fish geodata demo

This repository is a small Power Automate Desktop proof of concept for extracting structured tabular text from a Swim Guide PDF page and moving it into Excel. The original demo video is available on YouTube: https://youtu.be/kTekcBdiy30.

Repository map

• geodata.pdf is the source PDF used by the recorded desktop automation.
• geodata PAD Flow as text.txt is the exported Power Automate Desktop flow in plain-text form so the extraction logic can be reviewed without opening PAD.
• geodata.xlsx is the raw workbook output from the PDF text extraction flow.
• geodata - Copy.xlsx is the human-formatted workbook copy produced after a macro cleanup pass.

Flow behavior

The flow reads page 13 of geodata.pdf, splits the extracted text into rows, splits each row on whitespace, writes the cells into Excel, adds an attribution cell, autofits the workbook, and saves the result as geodata.xlsx.

The text export preserves the original absolute Windows paths from the machine where the demo was recorded. When recreating or rerunning the flow, replace those paths with the local paths for the checked-out geodata.pdf source file and the desired output workbook location. The repository keeps the original export text unchanged so reviewers can see the exact recorded flow inputs and outputs.

Validation notes

This archive does not contain a buildable application or automated test suite. The practical review checks are:

1. Confirm the four demo artifacts listed above are present.
2. Open geodata PAD Flow as text.txt and verify the PDF extraction, row split, column split, Excel write, and save steps are all represented.
3. Open the workbooks only when binary artifact review is needed; otherwise use this README and the plain-text flow export as the lightweight handoff surface.