Skip to content
TextArray1.41.0
100% local

ASIN / SKU extractor

Pull Amazon ASIN and SKU-like product codes out of raw text or data exports.

Input
Output
Related tools
Email extractorDeveloper tools
Phone number extractorText manipulation
Number extractorText manipulation
i18n key diffDeveloper tools
TOML to JSON converterDeveloper tools
SQL to JSONDeveloper tools
ASIN / SKU extractor
Paste a product export, spreadsheet dump or any block of text that mixes prose with identifiers, and this tool pulls out the product codes: Amazon ASINs and generic SKU-like tokens. The result is a clean, deduplicated, alphabetically sorted list, one code per line, ready to paste into a spreadsheet or feed into another lookup.
An ASIN is Amazon's 10-character product identifier, always starting with "B0" and followed by eight more letters or digits (for example B0CJGTZ98X). The extractor recognizes ASINs written in upper or lower case and normalizes matches to upper case, since that is how Amazon itself displays them. A SKU-like token is looser by design: any 5-to-20-character run of letters, digits, hyphens and underscores that mixes at least one letter with at least one digit, such as WIDGET-2024 or PROD_007A. That covers most in-house SKU formats without needing you to describe your exact scheme.
Use the "Extract" option to control what comes out: ASIN only, SKU-like only, or both together. In "both" mode a code that matches the ASIN pattern is listed once, under ASIN, and never duplicated in the SKU count — so the tally under the output tells you exactly how many of each you got, plus the combined total. Because everything is generic, alphanumeric text, the tool is equally useful for scraping product IDs out of scraped listings, support tickets, inventory CSVs pasted as plain text, or old catalog dumps where formatting has fallen apart.
Everything runs locally in your browser — pasted text, whether it is a public listing or an internal, unpublished inventory file, is never uploaded or sent anywhere. Copy the result, download it as a .txt file, or send it straight into another TextArray tool to keep cleaning up your data.
FAQ
What counts as a valid ASIN?
A 10-character code starting with "B0", followed by eight more letters or digits — Amazon's standard product identifier. Matches are recognized in either case and shown in upper case.
What makes a token "SKU-like"?
Any 5 to 20 character sequence of letters, digits, hyphens and underscores that contains at least one letter and at least one digit, such as WIDGET-2024. Pure letters or pure digits are not treated as SKUs.
Can I extract only ASINs or only SKUs?
Yes. Use the "Extract" dropdown to choose ASIN only, SKU-like only, or both. In "both" mode, a code matching the ASIN pattern is never also listed as a SKU.
Does it remove duplicate codes?
Yes. The output is always a unique, alphabetically sorted list, even if the same code appears many times in the input.
Is my product data uploaded anywhere?
No. Extraction runs entirely in your browser — your text and any codes found in it never leave your device.