ExtractFoxThe ExtractFox blog
Notes from the team — how AI extraction works, workflow guides, and product decisions.
Passport MRZ format explained: fields, check digits, and parser code
How to parse passport MRZ data under ICAO 9303: TD3 field positions, check digits, example MRZ lines, Python parser code, and when to extract the full passport instead.
Read post →How to bulk-clean LinkedIn 'Location' fields into city/country pairs
Recruiters and sales ops teams inherit LinkedIn exports full of "Greater London," "Bay Area," and "remote." A practical workflow to turn those into a clean city/country/region columns — at any scale.
How to remove metadata from a PDF (for privacy)
Author, software, GPS, edit history — every PDF leaks more than you think. The reliable ways to strip metadata before sharing, in any tool you already have.
Public Suffix List: get the registrable domain from a URL
How to get the registrable domain from a URL with the Public Suffix List, including vercel.app, github.io, co.uk, and copy-paste Python, JavaScript, and Go examples.
How to extract data from a chart in Excel
Get the underlying numbers back out of an Excel chart — even if the source range was deleted, the workbook is locked, or you only have the chart as an image.
How to extract metadata from a PDF (Python, C#, online tools)
How to read PDF metadata — author, creation date, producer software, custom XMP fields — in Python, C#, or with free online tools. Step-by-step guide with copy-paste code examples.
How to extract images from a PDF
From a one-off Preview save to batch extraction with pdfimages, pypdf, or iText — every realistic way to pull every embedded image out of a PDF at full quality.
How to extract links from HTML or plain text
BeautifulSoup, Cheerio, PHP DOMDocument, and the regex you should and shouldn't use — every reliable way to pull URLs out of a string of HTML or text.
How to extract a zip file (Mac, Windows, Linux, Android)
What "extracting a file" actually means, the one-click way to do it on every major OS, and how to handle the file that won't open.
How to extract keywords from text, a website, or a job description
RAKE, YAKE, KeyBERT, TextRank, and the LLM era — the four open-source keyword-extraction algorithms that still matter, plus when to use each.
How to extract sentiment from text
VADER, TextBlob, fine-tuned transformers, and the LLM-with-typed-schema pattern — four sentiment-extraction methods, what each one is best at, and the few lines of code to start.
How to extract a chart of accounts from QuickBooks
Three reliable ways to get your full chart of accounts out of QuickBooks Online or Desktop — built-in export, IIF, and the API route — plus how to clean it up before re-importing somewhere else.
How to extract data from a website to Excel automatically
Power Query, Make/Zapier, and a no-code AI route — three ways to set up an automated pipeline from a website to an Excel file that updates on its own.
Extract data from a pivot table in Excel
How to extract data from an Excel pivot table with Paste Values, GETPIVOTDATA, Show Details drill-down, or by returning to the source table.
How to extract RAR, tar.gz, jar, and other archive formats
Beyond zip — every other archive format you'll meet (RAR, 7z, tar.gz, gz, jar, war, ear) and the right tool for each on every OS.
How to extract topics from text or interview transcripts
BERTopic, LDA, and the LLM-with-clustering pattern that's quietly taken over qualitative research. What each one is best at, and the few lines of code to start.
How to extract data from Zillow listings
Zillow doesn't offer a public scraping API and actively blocks bots. Here's how to get listing data into a spreadsheet without getting your IP banned — and the legal lines to stay behind.
How to extract all links from a website
Crawling a whole site for every internal and external URL — the right way with a sitemap, the brute-force way with Scrapy, and what to do when neither works.
How to extract photos and frames from a video
Pull a still from a video — on iPhone, Android, in DaVinci Resolve, with FFmpeg, or from a YouTube URL. The right tool depends on whether you want one frame or every frame.
Extract text from PowerPoint files (.pptx): 3 reliable methods
How to extract text from PowerPoint files with Outline View, python-pptx, unzip/XML parsing, and OCR for slides where text is baked into images.
How to extract EXIF and GPS metadata from a photo
Where the photo was taken, what camera made it, when it was shot, even the focal length — every JPEG carries it. Here's how to read EXIF from a photo and the privacy lines you should know about.
How to extract a table from a PDF using Python
pdfplumber, Camelot, Tabula, and the API-based fallback — what each library handles well, what it breaks on, and the code you actually need.
How to extract images from a website (or a URL)
Browser tools, wget, gallery-dl, and the legal lines around scraping images from sites like Instagram, Pinterest, and stock photography. What's safe, what's gray, and what to skip.
Extract metadata from a video file with FFprobe, MediaInfo, or yt-dlp
How to extract video metadata as JSON: duration, codecs, bitrate, resolution, framerate, chapters, stream tags, and YouTube metadata with FFprobe, MediaInfo, and yt-dlp.
The end of templates: how AI extraction actually works
Per-supplier templates were the only way to extract structured data from PDFs for two decades. Multimodal models change the shape of the problem.
Extract hyperlinks from Excel and Google Sheets
How to extract actual URLs from Excel and Google Sheets hyperlinks, including VBA, Office Scripts, Google Apps Script, formulas, and no-macro workarounds.
How to extract images from Google Docs and Google Slides
Three reliable ways to get every image out of a Google Doc or Slides deck — with or without losing resolution — including the publish-to-web trick that beats every other method.
How to extract a signature from a PDF or an image
Whether you need to verify a signature exists, lift it as a transparent PNG for reuse, or pull every signed name as text — here are the right tools for each version of the question.
How to extract images from a Word document
The fastest way to pull every image out of a .docx file at original resolution — using nothing more than the file extension trick that works in any unzip tool.
How to extract numbers from a cell in Excel
Whether you need digits out of a product code, an order ID, or a free-text field, here are the formulas (old and new), the Power Query route, and what to do when the data isn't actually in Excel yet.
How to extract metadata from a website
Title tags, Open Graph, Twitter cards, JSON-LD structured data — what every page exposes and how to pull it out cleanly for SEO audits, link previews, or content indexing.
Built-in image-to-text features in Mac, OneNote, and Excel
Live Text on macOS, OneNote's Copy Text from Picture, and Excel's Data from Picture — the OCR features already on your machine that most people don't know exist.
How to extract a table from a Word document
Native Word-to-Excel paste, python-docx for scripting, and what to do when the table is actually a screenshot inside the document.
Extract embedded files and attachments from a PDF
How to extract embedded files and attachments from a PDF with Acrobat, pdfdetach, qpdf, and Python. Works for Excel sheets, source data, and supporting documents.
How to extract zip and postal codes from addresses (Excel, Sheets, Python)
Three reliable patterns for pulling postal codes out of free-text addresses — Excel formulas for clean US data, regex for international, libpostal when nothing else works.
Extract video links from a YouTube playlist
How to extract every video URL from a YouTube playlist into a flat list with yt-dlp, the YouTube Data API, or a browser-console one-off.
How to extract phone numbers from text
A regex that handles most cases, the libphonenumber library that handles the rest, and what to do when the phone numbers are trapped inside PDFs, screenshots, or messaging exports.
How to extract key-value pairs from documents
"Name: John Smith. Date: 2024-04-12. Total: $1,420." — every form, invoice, and structured PDF is full of key-value pairs. Here's how to pull them out reliably across formats.
How to extract files from a Docker image or container
docker cp from a running container, dive for digging into image layers, and the few tricks for getting files out of an image you can't run.
How to extract the host or domain from a URL (with code examples)
URL parsing in Python, JavaScript, Bash, and SQL — and the public-suffix-list trick that makes "co.uk" come out right. Code examples for every approach.
How to extract text from a YouTube video
Three reliable ways to turn a YouTube video into searchable, citable text — using the built-in transcript, yt-dlp + Whisper, or browser tools — and when each one is the right call.
Extract city and country from a location string: Python, JS, and LLM fallback
How to identify city, region, and country from location strings like Leiston, Greater London, NYC, or San Francisco Bay Area with Python, JavaScript, geocoding, and schema-based AI fallback.
How to extract schema from SQL Server, MongoDB, JSON, XML, or Parquet
Information_schema, sp_help, mongoexport, jsonschema, parquet-tools — the right command for every common data store, in two lines or fewer per format.
How to extract formulas from an Excel file or PDF
Showing all formulas in a sheet, exporting them programmatically with openpyxl, and pulling math from a PDF where the formulas are rendered images, not LaTeX.
How to extract key information from emails
Sender, dates, attachments, action items, deal numbers — emails are unstructured text wrapping structured data. Here's how to pull the structure out reliably for CRM, support, or finance workflows.
How to extract a Gantt chart from MS Project
Get a Project file's tasks and timeline out into Excel, image, or a presentation-friendly format — without buying a copy of MS Project if you don't already have one.
How to extract code from a video tutorial
Three workflows for getting the source code out of a programming tutorial video — from manual frame capture to a full transcript-plus-screenshot pipeline.
How to extract an organization chart from Microsoft Teams
Teams shows you reporting lines but doesn't give you a clean export. Here's how to get the org structure out via Microsoft Graph, the People app, or as a fallback, from screenshots.
How to extract a summary from a PDF, video, or article
Three classes of summarization tools (extractive, abstractive, hybrid), how each one fails, and the practical setup for getting a useful 10-line summary out of a 90-minute talk or 300-page report.
How to extract data from Amazon product pages
Title, price, ASIN, ratings, variations — Amazon makes it hard to scrape and easy to misuse APIs. Here are the legitimate options, the gray ones, and the screenshot-based fallback.
Slack's auto-extract links setting (and what it actually does)
Slack quietly fetches link previews for every URL pasted in a channel. Here's how the setting works, why teams turn it off, and how to control it per-channel or per-message.
How to extract a chart of accounts from SAP
SAP exposes the chart of accounts through a few transactions and a few APIs — here's the practical map for finance teams who need a clean export, not a consultant's project.
How to extract facts from text (Python NLP tutorial)
How to extract named entities, claims, and relations from text using Python NLP libraries. What fact extraction means, which tools to use, and how LLMs changed the game. Free tutorial with copy-paste code.
Closing the month without re-keying invoices
A practical workflow for accountants and bookkeepers: take a folder of supplier PDFs, get a clean Excel sheet, and reconcile in one sitting.
How to extract LinkedIn profile data with Python (legally)
How to extract LinkedIn profile data with Python — official APIs, unofficial libraries, headless browsers, and the legal boundaries. Plus a free no-code alternative that exports to Excel/JSON. Free guide with code examples.
How to extract text from an image using Python
Tesseract via pytesseract, EasyOCR, PaddleOCR, and the API-based path — what each one is best at, what they break on, and the few lines of code to get started.
What "unstructured data" actually means — and how to extract from it
Unstructured data isn't disorganized data — it's data without a schema. Here's the practical taxonomy, why it became extractable in the last few years, and the patterns that work.
Extract questions and responses from Google Forms
How to extract Google Forms questions, options, settings, and responses with Sheets export, the Google Forms API, Apps Script, or a screenshot fallback.
How to extract data from a PDF in C#
A working engineer's tour of the PDF extraction libraries in the .NET ecosystem — iText, PdfPig, Azure Document Intelligence, and the API-first alternative when you don't want to ship a parser at all.
How to extract data and metadata from PDFs with Power Automate
The built-in actions for PDF text extraction, the AI Builder model for invoices and receipts, and how to wire either one into a flow that drops structured data into Excel or Dataverse.
Why we don't store your documents
A short note on how ExtractFox processes files in-flight, what we keep, and what we throw away — and why that's a deliberate product decision.
Try it on a real document
The free tier is genuine. Upload a PDF or image and see what comes out.
Try a free extraction →