What "free" gets you, and what it does not
Searches such as "litbuy spreadsheet free", "litbuy google sheet", "litbuy spreadsheet excel" and "litbuy spreadsheet docs" all ask for the same thing: a list of products they can open without paying anyone. That is easy to find. What free does not include is a promise that the rows are current, that the weights are real or that the links carry no strings. The table sorts the free options by what you can do with them.
| Free option | Open | Edit your own copy | Works offline | Watch for |
|---|---|---|---|---|
| Public Google Sheet | Any browser or the Sheets app | Yes, after Make a copy | Only if you enable it | Invite tails, no date |
| Website or hub | Any browser | No | No | Cannot see edit history |
| Excel file (.xlsx) | Excel, Numbers, Sheets | Yes | Yes | Does not refresh |
| CSV file | Any spreadsheet app | Yes | Yes | Semicolon versus comma |
| Google Doc with links | Any browser | Yes, after copy | Only if you enable it | No columns, no filters |
A Google Doc is not a spreadsheet, but "litbuy spreadsheet docs" searches usually mean one: a document with items listed down the page. It works as a reading list. Once you need a total, move the rows into a sheet.
Free means free to read and copy; it does not mean current or checked.
Copying a public sheet into your own Google Drive
Do this before you change anything. A copy is yours; the original stays as the maker left it, so you can still compare against it.
- Sign in to Google in the same browser or app that opens the sheet.
- File, then Make a copy. Name it with the date, for example "litbuy-list-2026-10-27".
- Pick a folder in My Drive. The copy appears there and is private to you.
- Check the tabs. Hidden tabs copy too. Right-click a tab bar and choose Show sheet to see them.
- Note the original's link in a cell, so you can re-check the source later.
If File does not offer a copy, the owner has turned it off. In that case choose File, then Download, then CSV or XLSX, and open that. Read the sheet directory first if you are unsure what kind of list you hold, and score it with the scorecard before you spend an evening editing it.
Make a copy, date its name and note where it came from.
Removing inviteCode tails from links
Many links in free sheets end with a parameter such as inviteCode=, ref= or affcode=. It belongs to whoever made the sheet, and removing it does not break the link: the product is identified by the path, litbuy.com/product/<code>/<item id>, where the code is 0 for 1688, 1 for Taobao, 2 for Weidian and 3 for JD. We never print any code on this site and we ask you not to paste one into your own copy.
To clean a column in Google Sheets, select the links, then Edit, then Find and replace. Tick "Search using regular expressions" and replace \?.*$ with nothing, to drop everything from the question mark to the end. Check one link afterwards. Or paste a link into our link converter, which pulls out the item ID and rebuilds a clean LitBuy address. Whether you keep the tail is your choice; just know what it does.
Strip everything after the question mark, then test one link.
What a free sheet earns its maker (rules only)
Sheets cost time to build, and the people who make them are usually paid through invitation codes. LitBuy's interface says an invitation code mainly earns the code's owner a share of the shipping fee you pay; the welcome offer for new users, advertised as a 40% shipping coupon on 27 October 2026, goes to all new users whichever route they arrive by. One shipping coupon applies per parcel, coupons are tied to one account and shipping discounts cannot be combined. LitBuy does not publish the share a code earns, so we do not give a figure.
That arrangement is ordinary, and it explains why free lists exist. It also explains why some are padded with rows nobody checked. The honest ones say so on the first tab, and they keep a date on every row so you can tell a living list from one that was pasted once and abandoned. Ask the same of any free sheet you copy: who made it, when it was last checked and how its links earn. The about page explains how this library is built. For the rest of the coupon rules, see what changed in 2026.
A free sheet is paid for through its links; the good ones tell you that.
Our free template: Excel, CSV and what is in it
The CSV template on this site has thirteen columns in this order: Category, Item name, Marketplace, Item ID, LitBuy link, Price CNY, Est. weight kg, Item EUR (price × 0.158), Size / colour, Seller photos, QC column, Date checked and Notes. The XLSX Rows sheet swaps the QC column for Qty and Line kg (fourteen columns) and adds a Germany shipping step. The euro column is a formula, so typing a price updates it. The spreadsheet is free in two forms: an XLSX file for Excel and Google Sheets, and a semicolon CSV that opens correctly in German Excel. Two smaller files go with it: a haul list with quantity and line weight, and a QC checklist.
The template page explains each column. The fastest route into Google Sheets is File, then Import, then Upload, with the separator set to semicolon. Then add a date to every row you check, because the free sheet only helps if it stays dated.
A euro formula and a date column make a free sheet useful.
Filling the template: two sample rows to a parcel total
The template's sample rows are a ¥270 wide-leg denim item (estimated 0.70 kg) and a ¥110 boxy tee (estimated 0.25 kg). Prices are examples, weights are our planning estimates, and the euro column uses LitBuy's own display rate of ¥1 ≈ €0.158 (27 October 2026), higher than typical bank rates. Shipping is LitBuy's all-in estimator price to Germany on LIT-Economy-DHL-DE, read the same day.
Two template rows, alone and in one parcel (Germany)
Denim: ¥270 × 0.158 = €42.66, plus 1,000 g band €30.42€73.08
Tee: ¥110 × 0.158 = €17.38, plus 500 g band €23.08€40.46
Two parcels: €73.08 + €40.46€113.54
One parcel, est. 0.95 kg: ¥380 × 0.158 = €60.04, plus €30.42€90.46
Saved by combining€23.08
The haul list file does the same sum with a quantity column, which is handy when you add a second tee. Weights are estimates until LitBuy weighs the parcel, and the combine-parcels guide explains how to see the real figure first. The landed price calculator covers the other lines.
Fill the weight column and the saving from one parcel shows itself.
Excel, Google Docs and offline use
Excel is the choice when you want the file on your own machine. Download the XLSX, open it and the euro column keeps working because it is a formula, not a pasted number. German, French and Dutch Excel installs read a semicolon as the column break, which is why our CSV uses semicolons; an English install may show everything in column A, and Data, then Text to Columns, with the semicolon ticked fixes it. Numbers on a Mac and LibreOffice open both files too.
For a Google Doc, treat it as a note page: paste the item name, the clean LitBuy link and a line for the price and date. Docs cannot sum a column, so move to a sheet once you have more than ten rows. To use a sheet offline, open it in the Google Sheets app, tap the three-dot menu and switch on "Available offline"; edits sync when you reconnect. Whichever you use, keep the original link in a notes column, since the copy cannot tell you if the maker has fixed a row.
Excel for a local file, a Doc for notes, a Google Sheet when you need sums on the move.
Keeping a free sheet honest
Date every row you check, mark estimated weights as estimates and re-open ten links a month. When LitBuy changes a rule, redo the shipping column from the estimator. If you would rather browse than build, the LitBuy spreadsheet library on the home page does the euro maths for you. No LitBuy account? Send the row to us via the WhatsApp QR on the contact page: one delivered price, photos before dispatch, pay per order.
Free sheets stay useful only if somebody keeps dating them; make it you.
Questions about free LitBuy spreadsheets, Google Sheets and Excel
Is there really a free LitBuy spreadsheet?
Yes. Public Google Sheets, hub websites and this site's template cost nothing, and you do not need a LitBuy account to read them. The CSV template has thirteen columns and the XLSX fourteen, including CNY price, estimated weight and a euro formula at ¥1 ≈ €0.158. LitBuy itself charges only when you place an order or ship a parcel.
How do I copy a public Google Sheet into my own Drive?
Open the sheet while signed in to Google, then choose File, then Make a copy. Name it, pick a folder and tick 'Copy comments' only if you want them. The copy is yours to edit and will not update when the original changes. If File shows no copy option, the owner has disabled it, so download as CSV instead.
How do I get a LitBuy spreadsheet into Excel?
In Google Sheets choose File, then Download, then Microsoft Excel (.xlsx), or open our template at /files/litbuy-row-sheet.xlsx. In Germany, Excel splits columns at semicolons, so use the semicolon CSV we provide rather than a comma one. If everything lands in one column, use Data, then Text to Columns, and pick the semicolon.
Do I have to remove the inviteCode part of a link?
No, but you may. A tail such as inviteCode= belongs to whoever made the sheet, and removing it does not break the link, because the item ID in the path is what identifies the product. Keeping it means the maker may earn from your shipping. LitBuy offers its welcome coupon to all new users either way.
How do free sheets make money?
Mostly through invitation codes. LitBuy's interface says a code mainly earns its owner a share of the shipping you pay, while the new-user shipping coupon (a 40% banner on 27 October 2026) goes to everyone. We print no codes. A sheet that explains this on its first tab is more trustworthy than one that hides the tails in every link.
Can I keep a free sheet current without redoing it?
Add a 'date checked' column and re-open ten links every month; the product page shows a CNY price or says the item has been removed from the shelves. Shipping notes age faster than rows, so redo them from LitBuy's estimator after each rule change. The 1 kg all-in price to Germany was €30.42 on 27 October 2026.