How to Make Bulk FNSKU Labels from a CSV File
Typing FNSKUs one by one is fine for a handful of products. For a full shipment, it is faster and far less error-prone to put them in a spreadsheet and generate every label at once.
Step 1: Build the spreadsheet
Create a sheet with one row per product and a header row. Only two columns are required:
fnsku— the Amazon FNSKU, for exampleX001AB12CDname— the product name to print on the label
Optional columns add details to 3×5 and 4×6 labels:
| Column | Example | Notes |
|---|---|---|
sku | EB-BT53 | Your own SKU |
weight | 45g | Net weight as you want it printed |
mrp | 1499 | Maximum retail price, numbers only |
soldby | Your Store Name | Seller name |
website | yourstore.com | Optional footer line |
size | 4x6 | 4x6, 3x5, or 1x2 for the 2×1 inch barcode-only label |
Step 2: Example file
Your finished file should look like this when opened in a text editor:
fnsku,name,sku,weight,mrp,soldby,size
X001AB12CD,Wireless Earbuds Bluetooth 5.3,EB-BT53,45g,1499,Your Store Name,4x6
X002EF34GH,USB-C Fast Charger 65W,CH-65W,135g,1899,Your Store Name,3x5
X003IJ56KL,Power Bank 20000mAh,PB-20000,420g,2299,Your Store Name,1x2
FNSKU Label Generator can download this sample for you from its Bulk / CSV page.
Step 3: Get FNSKUs out of Seller Central
Rather than copying codes by hand, download an inventory report from Seller Central. It includes FNSKU, SKU, ASIN
and product name columns. Copy the FNSKU column into fnsku and the title column into name,
then delete anything you don’t need. Shortening long Amazon titles to something readable makes the label
easier for your team to check.
Step 4: Save as CSV
- Excel: File → Save As → CSV UTF-8 (Comma delimited).
- Google Sheets: File → Download → Comma-separated values (.csv).
- Avoid commas inside a field. Write “Charger 65W USB-C” rather than “Charger, 65W”, because a comma starts a new column.
Step 5: Generate and print
Open FNSKU Label Generator, go to Bulk / CSV and drop the file in. Each row becomes a label you can check on screen, then print all of them, export them as PDF, or save them to your label library for next time. A PDF has a single page size, so a file that mixes sizes comes out as one PDF per size.
Printing more than one copy of each
Each row prints one label. If you are sending 20 units of a product, either duplicate its row 20 times in the spreadsheet, or save the products to your library and print each with the quantity you need.
Checks before a big print run
- Spot-check that each FNSKU matches the right product — similar variations (colours, sizes) are the usual mix-up.
- Print one label of each size and scan it with your phone.
- Keep the CSV: next shipment, you only add new rows.
Make FNSKU labels in seconds
Type an FNSKU, get a scannable Code 128 label at 2×1, 3×5 or 4×6 inches, then print or export a PDF. Works offline, no account.