Avery L7160 labels from Google Sheets: A4 template and steps

The short answer

Avery L7160 and J8160 are compatible with an A4 address-label layout of 21 labels per sheet: three across and seven down. Each label is 63.5 mm wide and 38.1 mm high. If you have an address list in Google Sheets, you can join the address lines, arrange them in a grid and copy them into a Google Docs table. It is a free method, though you need to set up and check the table yourself.

Our LabelRows add-on can read the list and create a Google Doc for the same A4 layout. L7160 and J8160 are on its free plan, with up to 60 labels per document. It produces text-only labels and shortens text that will not fit, so review the result before printing. Word mail merge is another option if you already have desktop Word.

Whichever route you choose, check the measurements on your box and print a test on plain A4 paper first. Hold the test against a label sheet in front of a light. A few minutes spent checking the first page can save a sheet of labels.

The L7160 layout in numbers

These figures come from the standard L7160 template. The label width and height describe the individual stickers; the margins and column gaps describe where those stickers sit on the page. Check your box in case your stock uses a different layout.

Measurement	Standard L7160 layout
Paper	A4, 210 × 297 mm
Label	63.5 mm wide × 38.1 mm high
Labels per sheet	21: three across and seven down
Left and right margins	About 7.2 mm each
Top and bottom margins	About 15.1 mm each
Gap between columns	About 2.5 mm
Gap between rows	None

The more precise figures show how the layout fits A4. Across the page, three 63.5 mm labels, two 2.54 mm gaps and two 7.21 mm margins total 210 mm. Down the page, seven 38.1 mm labels and two 15.15 mm margins total 297 mm. Rounding the figures for display is useful, but use the more precise values when your document editor accepts them.

L7160 and J8160 both use this 21-up A4 layout. Avery 5160 and 8160 are different: they use a Letter-size sheet with 30 labels. If your box says 5160 or 8160, follow our guide to Avery 5160 labels from Google Sheets instead. A sheet with three columns is not enough by itself to identify the right template.

Get the address list ready

Use one row per recipient and give each part of the address its own column. For example, a sheet could have Name, Address 1, Address 2, Town or city, Postcode and Country. The exact columns are up to you. Separate fields make it easier to leave out an empty Address 2 or include a country only when you need it.

For UK and European addresses, look at the layout you intend to use for each destination. A postcode may belong on the town or city line or on its own line, depending on the address. For international mail, include a country line. This is general layout advice, not a substitute for checking the requirements for the destination and postal service you are using.

Read through the list before creating labels. Correct incomplete addresses, check for duplicates and make sure each postcode appears as intended in its cell. If a postcode begins with a zero, check that the zero is still visible. You can keep postcodes as plain text and re-enter any value that has already lost a leading zero.

For the manual method below, suppose columns A to F contain Name, Address 1, Address 2, Town or city, Postcode and Country. Put this in an empty column on row 2 and fill it down:

=IF(A2="", "", TEXTJOIN(CHAR(10), TRUE, A2, B2, C2, D2, E2, F2))

CHAR(10) puts a line break between the parts, and TRUE skips empty cells. An empty Address 2 therefore does not leave an empty line. The first test leaves the result blank when Name is blank; change the column references to suit your own sheet. This example puts the town and postcode on separate lines. If your addresses need a different arrangement, adjust the formula and inspect the result for several recipients.

Long lines may wrap, and a country line adds height. Keep the address complete, but remove unnecessary wording and check that the finished label remains readable. If you are preparing a list for an occasion, our guides to wedding address labels and Christmas card labels cover other ways to organise a list.

Free: make a Google Docs table

This method uses Google Sheets and Google Docs without an add-on. It is practical for a small batch or a template you are willing to adjust. You will build a table with three label columns and two narrow spacer columns, because the standard layout has gaps between labels across the page.

Prepare the label text. Use the formula above, adjusted to your columns, and fill it down. Check a few results, including one with no Address 2 and one with a country line.
Arrange up to 21 labels. If your finished text is in column G, put =WRAPROWS(FILTER(G2:G, G2:G<>""), 3, "") in an empty area. This groups non-empty labels into three columns and pads an incomplete final row with blanks. Copy only the first seven rows of the resulting grid for the first page.
Set up an A4 document. In a blank Google Doc, open File → Page setup, choose A4 and portrait, and set the left and right margins to approximately 7.21 mm and the top and bottom margins to approximately 15.15 mm. If the controls use another unit or round your entry, check the resulting measurements in your account.
Build the table. Insert a table with five columns and seven rows. In table properties, aim for label columns 1, 3 and 5 to be 63.5 mm wide, and spacer columns 2 and 4 to be 2.54 mm wide. Set each row’s minimum height to 38.1 mm. Use no visible borders and as little cell padding as the editor permits while keeping the text clear of the label edges.
Add the addresses. Copy or paste the first three-column block into the corresponding label cells, leaving the spacer columns empty. Check the position of every address; pasting a three-column block directly into a five-column table may put text into spacer cells. Repeat for a new page and the next group of up to 21 addresses.
Inspect and test. Check that the table stays on one A4 page, that no address has made a row taller, and that no extra page will print. Print on plain paper at 100% or Actual size, with A4 selected and no extra print margins. Compare the test with your label sheet.

Table controls and the smallest widths or padding they accept can vary; check in your account. If you cannot enter the required spacer widths or keep the table within the page, use the closest settings available and measure the printed result. Do not assume an on-screen table is aligned merely because it looks close. A template that cannot be adjusted to match the stock is not ready for the label sheet.

There is also a limit to what a minimum row height can do. A long address or generous paragraph spacing can make a row taller than 38.1 mm, shifting everything below it. Shorten the text where appropriate, reduce the font size or padding, and check the whole page again. Keep each page as a separate group of seven rows so you can inspect it before printing. For another batch, update the sheet and copy the changed text into the document.

Use Word mail merge

If you have desktop Word, download the sheet as an Excel file, start a labels mail merge and select the matching Avery product number, then connect the downloaded list and place the address fields. Finish the merge and inspect the result before printing a plain-paper test. Word works from the downloaded copy, so download the list again if you change addresses in Google Sheets.

Make labels with LabelRows

LabelRows is our Google Sheets add-on for creating a Google Doc from rows in a spreadsheet. Its free A4 sizes include the 38.1 × 63.5 mm, 21-up layout compatible with L7160 and J8160, and the 38.1 × 99.1 mm, 14-up layout compatible with L7163 and J8163. The other A4 sizes in the documentation are Pro. Pro is coming soon and is not on sale yet; Pro sizes cannot create label Docs yet, although their test pages work.

Install LabelRows. On its Google Workspace Marketplace page, click Install and choose your Google account. Open the spreadsheet containing your addresses.
Open the side panel. Click the LabelRows icon, an orange tag, in the panel on the right. If the panel is hidden, use the small arrow at the bottom right of the window to show it.
Authorise access. Click Authorize access and allow the two permissions requested. You only do this once.
Choose the label size. Select the A4 address labels measuring 38.1 × 63.5 mm, with 21 per sheet. Check the size and code printed on your box.
Set the text and rows. Use Suggest from headers for a starting layout or write the label text using the column names listed under the text box. Use Update preview after editing. Choose all rows, a range, or selected rows; you can also choose a checkbox or TRUE/FALSE column so unticked rows are skipped.
Create and open the document. Check the label text, click Create labels at the bottom of the panel, then use Open label Doc. Inspect the document and print it from Docs.

LabelRows replaces each field with the value as shown in its sheet cell and leaves empty lines out. Preview addresses with and without Address 2, and check the order of postcode and country lines. You can choose a font and size, left or centre alignment, top or middle placement, and an optional bold first line.

There are useful limits to know. LabelRows makes text-only labels, so it does not add images. If text has more lines than fit, it shortens the text and tells you how many labels were affected. Reduce the font size or revise the affected addresses, create the document again and check it. The output is a Google Doc in your Drive, not a directly printed sheet.

The free plan allows up to 60 labels per document. For a longer list, make separate documents with row ranges: for example, rows 2 to 61 and then rows 62 to 121. Those ranges assume row 1 contains headers and the rows you want are consecutive. Check your own row numbers and print each document in turn. Sixty is a document limit, not the number of labels on an A4 sheet.

Test and print on A4

Printer feeds differ, so a correctly sized document still deserves a physical test. LabelRows has a Test page with numbered, outlined labels in the chosen size. It is free for every size and plan. Print it on plain A4 paper, hold it against your label stock in front of a light and look at the top, bottom and both sides.

Print from the label Doc with File → Print. Choose A4 paper and 100% or Actual size, rather than Fit to page, and use no extra print margins. Check both the document and print settings. The page margins that position the label grid are part of the layout; an additional margin or a scaling option in the print dialog can change where the grid lands.

If the whole LabelRows test is slightly out of position, use Printer alignment. Nudge right and Nudge down are measured in inches, from −0.5 to 0.5; negative values move the layout left or up. Make a small adjustment, print the test again and compare it with the stock. A nudge moves the layout as a whole, so it cannot correct a grid that becomes progressively wider or taller because of scaling or an oversized table row.

Once the plain-paper test lines up, check the printer’s feed direction and use label stock suitable for your printer. Print a sheet and inspect it before committing the rest of the batch. Keep the finished Google Doc until you have checked all pages, particularly when your list needs several documents.

Common problems

Every label is shifted in the same direction. Compare a plain-paper test against the stock and measure the shift. In LabelRows, adjust Nudge right or Nudge down and test again. For a manual table, adjust its position through the page setup or table settings, then recheck all four edges.

The top row is close, but lower rows drift. Check A4 and 100% or Actual size first. In a manual Docs table, inspect each row for a long address or paragraph spacing that has increased its height. One tall row can move every row below it. Shorten the text or reduce its size, then print another test.

The first column lines up but the others do not. Check the two spacer columns in the manual table. The standard gaps are approximately 2.54 mm, and each label column should be 63.5 mm wide. Also check for print scaling. Compare the left and right edges on a plain-paper test instead of judging only the first label.

An address is missing its last line. In LabelRows, look for the notice that text was shortened and reduce the font size or revise the address. In a manual table, look for wrapping and excess padding. Do not remove a necessary part of an address simply to make it fit; check that the final text is complete and readable.

There is an empty line in the address. Check whether the source cell contains spaces rather than being empty, and inspect the line breaks in your label text. LabelRows leaves empty lines out. In the manual formula, TEXTJOIN skips empty cells when its second argument is TRUE; review the output for addresses with a blank Address 2.

The wrong addresses appear or some labels are blank. Check the selected row range and the sheet’s row numbers. If using LabelRows selected rows, select them on the sheet before clicking Create labels. If using a checkbox column, make sure the intended rows are ticked. In the manual grid, check the formula’s source range and the cells you copied.

The document has an extra page. In a manual table, check whether a row expanded or content after the table pushed onto a second page. Reduce excess spacing and inspect the result. Do not print the label stock until the seven-row grid fits and the test page matches it.

Frequently asked questions

Is there an Avery L7160 template for Google Docs?

You can make a reusable Google Docs table using the L7160 measurements in this guide. Set the page to A4, allow for the gaps between the three label columns and test the table on plain paper. LabelRows can also create a Google Doc for the L7160 layout from your sheet.

Are Avery L7160 and J8160 the same layout?

Both codes are listed as compatible with the 38.1 × 63.5 mm, 21-per-sheet A4 layout in the LabelRows documentation. Check the code and measurements on your box, then test on plain paper before using your label stock.

Is Avery 5160 the same as L7160?

No. L7160 is an A4 sheet with 21 labels, while 5160 is a Letter-size sheet with 30 labels. Use the template and paper size for the code on your box.

Can I make more than 60 labels with LabelRows Free?

The free plan creates up to 60 labels per Google Doc. For a longer list, create separate documents using different row ranges, such as rows 2 to 61 and then 62 to 121, and print each document.

What happens if Address 2 is empty?

LabelRows leaves empty lines out of the label text. In the manual method, TEXTJOIN with its ignore-empty argument set to TRUE can omit an empty Address 2 cell too. Preview a few addresses with and without that line.

Can I add a logo or image to the labels with LabelRows?

No. LabelRows makes text-only labels. If you need an image or a design, use another method that supports it and check the resulting layout against your label sheet.

Why do the labels drift farther out of line down the page?

First check that the document and printer are using A4 and that the print scale is 100% or Actual size. In a manually made Docs table, a long address can make a row taller and shift the rows below it. Shorten the text or reduce its size, then print another plain-paper test.

Disclosure: we make LabelRows, the Google Sheets add-on mentioned in this guide. The Google Docs table method works without it, using your address list from Google Sheets.

Google Sheets and Google Docs are trademarks of Google LLC. Avery is a registered trademark of Avery Products Corporation. Microsoft and Word are trademarks of the Microsoft group of companies. LabelRows and Cellbrook are not affiliated with or endorsed by Google, Avery or Microsoft.