Skip to content

Turn any agent spreadsheet link into a clean link you can paste into Usfans

Last updated .

Quick answer: Paste a link from any spreadsheet, whether it was built for Kakobuy, CNFans, Oopbuy, CSSBuy or straight from Taobao, Weidian or 1688, and the helper finds the marketplace item number and gives you the original product link. Paste that link into the search box on usfans.com to open the item. Nothing you paste leaves your browser.

Paste a link

Why a clean link works everywhere

Spreadsheets are built for whichever agent their author used, so the links inside them look very different: some wrap the original address in a long parameter, some put a platform name and an item number in the query, others hide the number in the path. Underneath, each link points to one listing on Taobao, Weidian or 1688, identified by that platform's own item number. Agents don't own those numbers, which is why an item found in a Kakobuy sheet can be bought through Usfans.

Usfans advertises ordering by pasting a product link. The most reliable link to paste is the original marketplace address, so that's what this helper gives you. It doesn't try to imitate a usfans.com address, which could break whenever Usfans changes its site.

The item number is the product; the clean marketplace link is the safest thing to paste.

What the helper recognises

Link typeExample sourceWhat it extracts
Marketplace linksTaobao, Tmall, Weidian, 1688 (desktop and mobile)The item or offer number
Wrapped linksKakobuy, Superbuy and others with a url= parameterThe original address inside
Platform plus IDCNFans, ACBuy and similar shop_type linksPlatform and number
Path formatsCSSBuy, Oopbuy and other agentsNumber from the path
Text with a linkA pasted message or commentThe first link it finds

Most agent links convert in one paste; type the number yourself for anything unusual.

After converting

  1. Copy the clean link and open usfans.com, typed into your browser or through the official app.
  2. Paste it into the search box and open the product.
  3. Compare photos, price and variants with the spreadsheet row; listings change.
  4. Check the size chart in centimetres before adding to your cart.
  5. Look up recent warehouse photos from other buyers, if available, to judge the seller.

A converted link opens the same listing; whether it's still worth buying is your call.

Converting a whole sheet

For long spreadsheets, extract numbers in bulk first: in Google Sheets, a formula such as =REGEXEXTRACT(A2,"\d{8,}") pulls the long number from a link in cell A2. Then build marketplace links in a new column using the three formats in the table below, and spot-check a few rows, since some links contain other long numbers such as shop IDs.

PlatformClean link format
Taobao / Tmallhttps://item.taobao.com/item.htm?id=<number>
Weidianhttps://weidian.com/item.html?itemID=<number>
1688https://detail.1688.com/offer/<number>.html

This matters most for sheets built for agents that have closed, such as CNFans and ACBuy in August 2026; see moving from CNFans to Usfans.

Formula for bulk, helper for single rows, spot-checks for both.

Privacy and limits

The helper runs entirely in your browser; nothing you paste is sent to us or stored. It only rebuilds links: it can't tell you whether an item is still for sale, what it costs today or whether the seller is reliable. For those, open the listing and check recent QC photos. Spanish readers will find the same advice in Usfans links y enlaces. To estimate shipping once you've picked your items, use the shipping estimator.

FAQ

Why doesn't this tool make a usfans.com link directly?

Usfans opens items when you paste the original Taobao, Weidian or 1688 link into its search box, which is the method it advertises. Building that clean link avoids guessing at Usfans' internal link format.

Which links does it understand?

Taobao and Tmall item links, Weidian item links, 1688 offer links, and agent links that contain the original URL or a platform plus item number, including Kakobuy, CNFans, ACBuy, CSSBuy, Oopbuy and Superbuy formats.

Does it work with CNFans links after CNFans closed?

Yes. The links still contain the marketplace item number, so the helper can rebuild the original product link.

Is my link sent anywhere?

No. The conversion happens in your browser.

What if my link isn't recognised?

Choose the platform and type the long item number from the link yourself; the helper builds the product link from it.