Why mylabelmaker is the best way to print many labels from Excel or Google Sheets
If the labels are already sitting in Excel, a CSV, or a Google Sheet, mylabelmaker is the best way to print them. You design the label once. You click the column names onto it. Each row becomes its own label, and you print the ones you checked. It is free, and you do not sign up. Here is how that works for a real list of products.
Saturday morning, forty-eight jars, one sheet
Lena sells jam at a Saturday market. On Thursday night the kitchen table is covered in empty jars and the laptop is open to a Google Sheet called Fall jars. Forty-eight rows. The first row is not jam. It is the names of the columns: Flavor, Size, Price, Lot, SKU. Row 12, if you lean in, says Peach cardamom, 8 oz, $9, LOT-184, JAR-184. Row 13 is Fig vanilla. Row 30 is a small batch she might skip if the lids run out.
Last year she typed those labels one by one in a program that forgot the list every time she closed it. The year before that she tried a Word mail merge and spent the evening nudging text boxes so the flavor name would land on the sticker and not in the margin. The data was never the hard part. She already had the data. The hard part was getting forty-eight different labels out of one design without retyping Peach cardamom by hand.
That is the job mylabelmaker is built for. She designs one label. The sheet fills it. She prints the stack and the jars are labeled.
What the label looks like before any data touches it
She opens https://app.mylabelmaker.com. Nobody asks for an email. She sets the label to the size of the sticker roll, a small jar face, not a guessed rectangle on a letter page. She writes her shop name at the top, leaves a big space for the flavor, a line for the size and the price, and a barcode along the bottom that will carry the SKU. If she wants a starting point, the app already has templates. She does not have to start from a blank square.
Nothing from the sheet is on the label yet. That is on purpose. She is deciding where things go while she can still see the shape. The flavor should be the biggest type. The price should sit where a person at the market can read it without picking the jar up. The barcode needs room, because a tiny barcode is a barcode that will not scan when she is back at the table next month doing inventory.
The column names are the magic, and they are not magic
She publishes the Google Sheet so the app can read it. In Google Sheets that is File, then Share, then Publish to the web, and she picks comma-separated values. A normal share link, the one you send a friend, will not load. The published CSV link will. She pastes that link in. If the list lived in Excel on the laptop instead, she would upload the .xlsx file. If a shop export handed her a .csv, she would upload that. Excel, CSV, and a published Google Sheet all land in the same place. The first row has to be the column names. Flavor, Size, Price, Lot, SKU. Not a jar. The names.
Then she clicks Flavor. The word Flavor drops onto the label where she wanted the big type. She clicks Size, Price, and SKU into their spots. On the screen, row 12 stops being a row and becomes a label: Peach cardamom, 8 oz, $9, and a barcode that says JAR-184. She clicks to the next row and the same design now says Fig vanilla. She did not redesign anything. She did not copy and paste forty-eight times. The columns she clicked are the only connection between the sheet and the sticker.
The Excel file, if she used one, stays in this browser. We do not keep a copy of her flavors, her prices, or her customer list, because there is no account to put them in. The one trip out of the computer is that published Google Sheet, and that request goes to Google.
She does not have to print every row
Row 30 is the small batch with the short lid count. She leaves that row unchecked. The rows she wants get a check. Print this prints the label she is looking at, which is how she checks Peach cardamom on one sticker before she commits the roll. Print prints the rows she checked, one label each. Forty-seven jars, not forty-eight. Next week, when she makes more fig, she opens the same label, loads the sheet again, checks the new rows, and prints those. The design did not have to be rebuilt.
If the sheet forgot a number, she can still number a run 001, 002, 003. If it forgot the date, she can put today's date on the label. Lot codes she already typed stay as she typed them. A barcode drawn by the app will scan. A barcode that is only a fancy font inside Excel often will not, so the SKU belongs in a real barcode on the label, not in a font someone installed in 2014.
The same steps work for other lists
The jam sheet is one example. The app does not care that the rows are flavors. A warehouse lead with a spreadsheet of bin locations does the same thing: Bin, Aisle, SKU. Click the columns. Print the stack to a Zebra printer. A shop packing orders does it with Name, Street, City, Order. The barcode can be the order number. Someone who got a CSV out of their selling tool does not retype it. They upload the file.
If she is printing on a Zebra printer, she prints straight to it. That needs Zebra Browser Print, a free helper from Zebra, installed once, and a browser restart after that install. The long version is why this is the ultimate app for a Zebra printer. If the printer is the inkjet on the counter, she prints from this computer, or she downloads a PDF or a PNG. She can also copy the ZPL if a Zebra printer, or another program, needs the code later. Letter sheet templates are in the app when the job is a page of names or addresses on paper. More Avery, DYMO, and Brother templates are on the way.
Why this beats retyping, and why it beats a viewer
Retyping is how flavor 33 becomes "Peach cardamon" and the barcode no longer matches the SKU in the sheet. A viewer such as Labelary can show you ZPL you already have. It will not read Lena's Google Sheet, and it will not print the forty-seven jars. A heavy Windows label program might merge Excel, on Windows, after you pay for it. She is at a kitchen table. She wants the list she already maintains, on the label she already likes, without making an account and without paying to download the file.
That is why mylabelmaker is the best way to print labels from Excel, from a CSV, or from Google Sheets. The sheet stays the place she edits prices. The app is the place those prices become labels. Change a price in the sheet, load it again, print the rows that changed. The design waits.
How Lena prints the jars
- Open https://app.mylabelmaker.com. No signup.
- Set the label to the sticker size. Add the shop name, a spot for the flavor, the size, the price, and a barcode for the SKU.
- Put Flavor, Size, Price, Lot, and SKU in the first row of the sheet. The jars start on row 2.
- For Google Sheets, use File, Share, Publish to the web, as a CSV, and paste that link. For Excel or a CSV file, upload it.
- Click each column name onto the label. Look at one row. Check the rows you want. Print this for the label on screen. Print for every row you checked.
Peach cardamom comes out as Peach cardamom. Fig vanilla comes out as Fig vanilla. She did not type either one into the label.
What this will not do with your list
We do not sell postage. If the rows are orders, the stamp still comes from USPS, UPS, or the shop. We print the label you designed. We do not turn a private Google share link into data. It has to be published as CSV. And the first row has to be names, or the app will try to print the word Flavor as if it were a jar.
Questions people ask when the sheet is already open
Can I print labels from Excel without retyping the rows?
Yes. Upload the workbook, click the column names onto one label, and print one label per row you checked. CSV works the same way. No signup.
Can I print labels from Google Sheets?
Yes. Publish the sheet to the web as a CSV and paste that link. A normal share link will not load. Then click the column names and print.
Do I have to print every row?
No. Check the rows you want. Print this is only the label on the screen. Print is the rows you checked.
Will the barcode match the SKU in my sheet?
Put the SKU column on a real barcode on the label. Each row fills its own code. A fancy font inside Excel is not the same thing.
When you're ready to print or save
Load the list, look at one row, then print the rows you checked. On a Zebra printer, print from the browser after Browser Print is installed. On a regular printer, choose Print from this computer. You can also download a PNG, a PDF, or the ZPL. Save a JSON file if you want this label, and this spreadsheet, the next time you print.