The columns a LitBuy sheet needs
Community sheets give you a title, a price and a link. They leave out what decides the bill: weight, the freight share and the date your free storage ends. A sheet that answers those questions needs about sixteen columns, each doing one job. This is the layout we recommend and the one our downloads are built around. If you open a download and a header differs slightly, adjust the column letters in the formulas below to match. The LitBuy spreadsheet overview explains where rows come from.
| Col. | Header | What goes in |
|---|---|---|
| A | Row | Number, for sorting back |
| B | Item | Short name, such as "denim jacket" |
| C | Category | Jeans, shoes, jackets, caps |
| D | Platform | Taobao, Weidian, 1688 or JD |
| E | Item ID | The number from the marketplace link |
| F | Original link | The marketplace URL, kept as the master |
| G | LitBuy link | Built by formula from D and E |
| H | Price ¥ | Item price in yuan |
| I | Seller shipping ¥ | Domestic shipping to the warehouse |
| J | Assumed weight kg | Your estimate, later replaced by LitBuy's recorded weight |
| K | QC status | Waiting, photos seen, approved, returned |
| L | Stored on | Date the item was stocked |
| M | Free storage ends | L plus 90 days |
| N | Item € | (H + I) × rate |
| O | Shipping share € | Parcel cost × J ÷ total weight |
| P | Landed € | N + O |
Put the settings on the side, in columns S and T: the yuan-to-euro rate in T1, the EU handling fee in T2, total weight in T3 and parcel cost in T4. Keeping them in cells means one change updates every row.
Keep the original marketplace link as the master, because every other link is built from it.
The link-format column: rebuild LitBuy URLs from an item ID
The marketplace item ID is the real identifier of a row; an agent link is a wrapper around it. LitBuy's product pages use https://www.litbuy.com/product/code/item-id, in which 1688 is code 0, Taobao 1, Weidian 2 and JD 3. We loaded a Taobao item through that format on 19 October 2026 and it showed price, stock and an estimated arrival date. A Weidian test returned an empty frame because that item was delisted, so the format works and a dead item simply looks blank. Yupoo, Xianyu and similar sources are not covered by this pattern and go through LitBuy's Fill & Buy page.
Sheet links may also carry &inviteCode=…, which pays whoever made the sheet and which you can delete without breaking the link. Our Reddit sheets page explains why, and the link converter does the rebuild for you if you prefer not to use a formula. For column G, use one of these:
| Program | Formula |
|---|---|
| English Excel, Google Sheets (US locale) | ="https://www.litbuy.com/product/"&IF(D2="1688",0,IF(D2="Taobao",1,IF(D2="Weidian",2,3)))&"/"&E2 |
| German Excel, Sheets with German locale | ="https://www.litbuy.com/product/"&WENN(D2="1688";0;WENN(D2="Taobao";1;WENN(D2="Weidian";2;3)))&"/"&E2 |
One formula turns any item ID into a LitBuy link you can test.
Euro landed-cost formulas for Excel and Google Sheets
Three formulas do the work. The first converts yuan to euros using the rate in T1; we use ¥1 ≈ €0.12 as a round planning rate, while LitBuy converts at its own rate, which it says follows Bank of China. The second picks a parcel quote from the total weight. The third shares that quote among rows by weight. The quote steps below are LitBuy's list prices for LIT-Economy-DHL-DE to Germany on 19 October 2026, before the new-user promotion, and need updating when LitBuy changes them.
| Cell | English (comma) | German (semicolon) |
|---|---|---|
| M2 free storage ends | =L2+90 | =L2+90 |
| N2 item € | =ROUND((H2+I2)*$T$1,2) | =RUNDEN((H2+I2)*$T$1;2) |
| T3 total weight | =SUM(J2:J50) | =SUMME(J2:J50) |
| T4 parcel cost | =IF(T3<=0.5,16.81,IF(T3<=1,24.12,IF(T3<=2,38.75,"use estimator")))+$T$2 | =WENN(T3<=0,5;16,81;WENN(T3<=1;24,12;WENN(T3<=2;38,75;"use estimator")))+$T$2 |
| O2 shipping share € | =ROUND($T$4*J2/$T$3,2) | =RUNDEN($T$4*J2/$T$3;2) |
| P2 landed € | =N2+O2 | =N2+O2 |
The downloadable template does not use that step formula: its parcel-cost cell T4 is the 2,000 g quote of €38.75 plus the fee, so overwrite it with the quote for your own weight. In the German version, decimals are commas, so 0,5 and 38,75 are numbers while 0.5 would be read as a date or text. The quote steps do not cover weights above 2 kg, so the formula returns a prompt to use LitBuy's estimator or our shipping calculator. If your chargeable weight is volumetric, add a parcel-size row: length × width × height ÷ 8,000, then use the larger of that and T3. For EMS lines the divisor is 6,000.
Keep the rate, fee and quote steps in cells, so a price change is one edit.
Semicolon CSV for German Excel, and the Google Sheets import
German Excel treats a comma as the decimal mark, so a file with comma-separated fields opens as a single column. The downloads on this page therefore use semicolons between fields and carry a byte-order mark, so umlauts and the yen sign survive. In German Excel, double-click the file or choose Daten, Aus Text/CSV. If numbers appear as text, replace the decimal point with a comma in those cells.
In Google Sheets, choose File, Import, Upload, then select Custom separator and type a semicolon. Setting the spreadsheet locale to Germany under File, Settings makes the formulas above work with semicolons and decimal commas. The phone app can display the sheet but is awkward for editing formulas, so edit on a computer and view on the phone.
Pick the separator for your locale, and the file opens correctly first time.
Worked example: three rows through the formulas
Take three hypothetical rows: jeans at ¥159 plus ¥8 seller shipping (assumed 0.9 kg), a tee at ¥59 plus ¥6 (0.25 kg) and trainers at ¥329 plus ¥10 (0.75 kg in the box). Total assumed weight is 1.9 kg, which falls on the 2,000 g quote of €38.75. The €2 handling fee is added once LitBuy's 25 October 2026 cut-off of 14:00 Beijing time has passed, and the €3 prepayment is already inside the quote.
| Item | H + I (¥) | Item € | Weight | Shipping share € | Landed € |
|---|---|---|---|---|---|
| Jeans | 167 | 20.04 | 0.9 kg | 19.30 | 39.34 |
| Tee | 65 | 7.80 | 0.25 kg | 5.36 | 13.16 |
| Trainers | 339 | 40.68 | 0.75 kg | 16.09 | 56.77 |
Parcel total, Germany (hypothetical)
Items, ¥571 at ¥1 ≈ €0.12€68.52
Shipping, 2,000 g quote (list)€38.75 ($43.53)
EU handling fee€2.00
Total delivered€109.27
The three rows add up to (167 + 65 + 339) = ¥571, with rounded item values of €20.04, €7.80 and €40.68 (€68.52 together) and shipping shares of €19.30, €5.36 and €16.09, which add back to €40.75. The trainers carry €16.09 of freight because they weigh most, which is why a weight column belongs in the sheet. Compare the trainers' landed €56.77 with the sheet's €40.68 and you see why a sheet price is not a landed price.
Three rows at €68.52 become €109.27 once weight and fee are shared in.
Storage dates, coupons and a rehearsal check
Three guards keep the sheet honest. First, storage: LitBuy gives 90 days free per item from the day it is stocked and charges 0.2% of the price paid per day after that, with a ¥1 minimum, so highlight any row where M is within 14 days. Second, coupons: LitBuy allows one shipping coupon per parcel, applied on the parcel page, and the 40% new-user banner appears to discount only part of the fee, so keep a separate "coupon" cell you fill in after checkout rather than baking a percentage into the quote. Our coupon page works through the maths.
Third, weight: your assumed column is a guess until LitBuy records each item on arrival. Replace the guesses as soon as the parcel page shows the estimated weight, or pay ¥20 (about €2.40) for a rehearsal parcel when the box sits near a quote step. The QC page has a checklist you can add as column K, and the clothes page shows a box-or-two comparison using the same formulas. Pay per order: settle each order and parcel at the time you place it. Not keen on a LitBuy account? The WhatsApp QR on our contact page brings a delivered quote and dispatch photos, paid per order.
A sheet that tracks dates, weights and coupons separately stays accurate longer.
Questions buyers ask
Is there a free LitBuy spreadsheet template for Excel and Google Sheets?
Yes. This page links two CSV downloads, a row tracker and a haul planner, and explains the columns and formulas so you can rebuild them yourself. Both open in Excel and Google Sheets. A CSV keeps values, headers and formulas but no colours or conditional formatting, so add those yourself after importing. The formulas in the table above are the ones inside the downloads, apart from the parcel-cost cell, which starts at the 2 kg quote.
Why does my LitBuy CSV look like one column in German Excel?
German Excel expects a semicolon between fields, because the comma is the decimal mark. Our downloads use semicolons. If you build your own file with commas, use Data, From Text/CSV and pick the comma delimiter, or change the file. In Google Sheets, import with a custom separator or set the sheet locale to Germany.
What is the formula for LitBuy's product link from an item ID?
LitBuy's product pages follow litbuy.com/product/code/item-id, where code 0 is 1688, 1 is Taobao, 2 is Weidian and 3 is JD, as read from its site code on 19 October 2026. In a sheet, join the pieces with the ampersand and choose the code with an IF on the platform column. Yupoo and Xianyu go through Fill & Buy instead.
How do I turn yuan into euros in the sheet?
Put the rate in one cell and refer to it. LitBuy converts at its own rate, so we use a round planning rate of ¥1 ≈ €0.12 and say about. A ¥159 item plus ¥8 seller shipping is ¥167, which is €20.04. Update the rate cell when you see a different figure at checkout; LitBuy's PayPal rate follows Bank of China.
How should the sheet handle LitBuy's shipping quote and coupons?
Use the list price, not the promotion price, for planning. On 19 October 2026 LitBuy listed €24.12 for 1,000 g to Germany and showed €18.29 with the new-user promotion. The discount appears to cover only part of the fee, and LitBuy allows one shipping coupon per parcel, so keep coupons in a separate line you confirm at checkout.
Can the sheet warn me before free storage ends?
Yes. LitBuy gives 90 days of free storage per item from the day it is stocked, so a formula adding 90 to the stored date gives the last free day. Add conditional formatting for the next 14 days. After day 90 the overdue fee is 0.2% of the price paid per day, minimum ¥1 per item.