James Allman | JA Technology Solutions LLC
WIC APL File Explorer
Parse a state WIC APL (Approved Product List) file into a readable table of eWIC-authorized items, with a category summary and CSV/Excel export.
WIC APL File Explorer
Open a state-issued WIC Approved Product List (APL) and see which items are authorized for eWIC purchases. The explorer auto-detects the delimiter (CSV, pipe, or tab), maps common column headers (UPC/PLU/GTIN, category, sub-category, description, package size, unit of measure, benefit quantity, indicators, effective dates) case-insensitively, and falls back to raw positional columns when a layout is unfamiliar, so it never fails on an unrecognized state format. UPCs are normalized with leading zeros preserved. Sort or filter the item table, review a count-by-category summary, and export to CSV or Excel. Everything runs in the browser; the APL file never leaves your machine.
Learn more ↓
Loading interactive explorer...
What Is a WIC APL?
A WIC Approved Product List (APL) is the file a state WIC agency issues to tell retailers which specific products may be purchased with eWIC (electronic WIC) benefits. Each row identifies an item, usually by UPC, PLU, or 14-digit GTIN, and carries its WIC category and sub-category, a description, package size and unit of measure, the benefit quantity it satisfies, an indicator, and begin and end dates. When a participant taps their eWIC card at checkout, the POS validates each item against the current APL before approving the sale.
Why WIC APL Files Are Hard to Read
There is no single national APL format. Each state agency publishes its own layout: some comma-delimited, some pipe or tab; column order and header names differ; and UPCs often arrive with leading zeros or a check digit that must be preserved exactly to match. This explorer auto-detects the delimiter, maps common column headers regardless of case or punctuation, normalizes UPC and GTIN values, and falls back to raw positional columns when it meets a layout it does not recognize, so you can still read every field. Because the mapping is format-dependent, confirm it against your state agency's APL specification before relying on it.
Keeping eWIC Items in Sync
Reviewing an APL by hand is fine for a spot check, but APLs change on a schedule and a stale list means declined eWIC transactions at the register. I build integrations that pull each state's APL automatically, normalize it across the formats different agencies use, and keep the eWIC-eligible flags in your POS item file current without manual imports. See integration services or get in touch to discuss automating your APL feed. Have questions? Ask James.
All tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.