Avery L7163 labels from Google Sheets: A4 template and steps

The short answer

Avery L7163 and J8163 are compatible with an A4 layout of 14 labels per sheet, arranged two across and seven down. Each label is 99.1 mm wide and 38.1 mm high. If you are looking for A4 address labels measuring 99.1 × 38.1 mm, check those dimensions and the product code on your box before choosing a template.

For a free manual method, join the address fields in Google Sheets and copy the finished addresses into a Google Docs table. You will need to check the table against your own label stock. Our LabelRows add-on can create a Google Doc from the sheet using its free L7163 and J8163 size, with up to 60 labels per document. It creates text-only labels and shortens text that has too many lines to fit.

Desktop Word mail merge is another option if you already use Word. Whichever route you choose, print a test on plain A4 paper at 100% or Actual size. Hold it against a label sheet in front of a light and check every edge before using the adhesive stock.

The L7163 layout in numbers

These are the dimensions to start with for L7163 and J8163. Width and height describe each individual label. They do not, by themselves, tell you exactly where the grid starts on the page or how the remaining space is divided.

Measurement	L7163 and J8163 layout
Paper	A4, 210 × 297 mm
Label	99.1 mm wide × 38.1 mm high
Labels per sheet	14: two across and seven down
Width occupied by labels	2 × 99.1 = 198.2 mm
Height occupied by labels	7 × 38.1 = 266.7 mm
Space left across A4	11.8 mm in total
Space left vertically on A4	30.3 mm in total

Across the page, the 11.8 mm left after the two label widths must accommodate the side margins and any gap between columns. Those spaces are small. Vertically, 30.3 mm remains after the seven label heights, to accommodate margins and any gaps between rows. These totals do not establish the individual margins or gaps. Check your box or the manufacturer template for exact margins, and measure your sheet before setting up a table.

Do not choose a layout by a similar product number alone. L7160 and J8160 are different A4 sheets with 21 labels, arranged three across and seven down. US Avery 5163 is a different Letter-size sheet with 10 labels, each 2 × 4 inches. A 5163 template is not the A4 L7163 template.

Get the address list ready

Put one recipient on each row and use a header for each column. A useful starting set is Name, Address 1, Address 2, Town or city, Postcode and Country. Separate columns let you leave out an empty address line and decide whether a country line belongs on each label.

Check the address format for the destination and postal service. Depending on the address, you may want the postcode on its own line or alongside the town. Look for missing fields, duplicates and postcodes that have lost a leading zero. Keeping postcodes as plain text can help preserve their intended appearance; re-enter a zero if it has already been lost.

For the manual method, suppose those six fields are in columns A to F and the first recipient is on row 2. Enter the following in an empty column and fill it down:

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

CHAR(10) separates the fields with line breaks, and TRUE tells TEXTJOIN to skip empty cells. The IF test leaves the result blank when the name is blank. Adjust the references for your sheet and inspect the output for several recipients. This example puts the town and postcode on separate lines; change the arrangement if your addresses need something else.

A wide label gives each line more room, but its height is still 38.1 mm. Long lines can wrap and a country line adds another line. Keep the address complete and readable, and remove unnecessary wording where appropriate. The L7160 guide uses the same Sheets formula and Docs table approach for a different A4 grid.

Free: make a Google Docs table

You can make an Avery L7163 template for Google Docs without an add-on. The task is to place two 99.1 mm-wide label areas across each of seven rows, while matching the positions on your actual sheet. The label dimensions alone do not specify the table’s page margins or the gap between columns, so get those measurements from the manufacturer template or measure your stock first.

Prepare the text. Fill down the formula above and check the address cells. Include an example with an empty Address 2 and another with a longer address. Keep the original fields in the sheet so you can correct them.
Set up an A4 document. In a blank Google Doc, open File → Page setup, choose A4 and portrait, and enter the margins established from your stock or its manufacturer template. If the controls use a different unit or round an entry, check in your account and measure the printed result.
Build the grid. Insert a table for two label positions across and seven down. Set the label areas to 99.1 mm wide and each row’s minimum height to 38.1 mm. Account for any measured column gap when setting the table up; if a spacer column is needed, keep it empty. Check the exact column controls available in your account.
Adjust the table. Use no visible borders for the finished labels and keep cell padding and paragraph spacing small enough for the text to fit. Leave enough room to keep text clear of the label edges. Check that the seven rows remain on one A4 page.
Add up to 14 addresses. Copy the joined text into the label positions from left to right, then top to bottom. If copying a whole Sheets cell produces a small table or unwanted quote marks, copy the text inside the cell instead. Check every position, especially if you have used a spacer column.
Test the page. Print on plain A4 paper at 100% or Actual size. Hold the test against the label sheet in front of a light, inspect all four edges and adjust the document if needed. Repeat the test before printing onto labels.

Table controls, minimum widths and padding can vary, so check in your account if you cannot enter a measurement or keep the table on the page. A minimum row height is not necessarily a fixed height: a long address or excess spacing can make a row taller and move the rows below it. Shorten appropriate wording, reduce the text size or spacing, and test the entire page again.

Keep an empty, checked copy of the table for another batch. The addresses you paste into Docs are a copy: if you correct a recipient in Sheets, update the corresponding label in the document too. For more than one sheet, work through the list in groups of 14 and inspect each page. This manual copying can be useful for a short list, but it takes more attention as the list grows.

Use Word mail merge

If you have desktop Word, download the Google Sheet as an Excel file and start a labels mail merge. Select the matching Avery product number, connect the downloaded list and place the address fields in the label. Check the available product choices in your copy of Word and confirm that the selected layout matches your box.

Finish the merge, inspect the addresses and print a plain-paper A4 test at 100% or Actual size. Word uses the downloaded copy of the list, so download it again and update the merge if you make later changes in Google Sheets.

Make labels with LabelRows

LabelRows is our Google Sheets add-on for creating a label document from spreadsheet rows. In the size picker, the A4 address-label size measuring 38.1 × 99.1 mm, 14 per sheet is compatible with L7163 and J8163 and is free. The A4 L7160 size is also free; 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, though their test pages work.

Install and open LabelRows. On its Google Workspace Marketplace page, click Install and choose your Google account. Open your spreadsheet and click the orange tag icon in the right side panel. If the panel is hidden, use the small arrow at the bottom right to show it.
Authorise access. Click Authorize access and allow the two requested permissions. You only do this once. The documentation explains what the permissions are for.
Pick the size. Choose the A4 address labels measuring 38.1 × 99.1 mm, with 14 per sheet. Compare the size and compatible code with the label box before continuing.
Set the label text. Click Suggest from headers for a starting layout, or write your own using fields such as {{Name}} and {{Address 1}}. The available column names appear under the text box. Click Update preview after editing and inspect the result.
Choose rows. Use all rows, a range with the first and last row numbers as shown in the sheet, or selected rows. For selected rows, select them on the sheet before clicking Create labels. To skip unticked entries, choose a checkbox or TRUE/FALSE column under Only rows ticked in.
Choose the layout and create the Doc. Select a font and size, left or centre alignment, and top or middle placement. You can make the first line bold. Check the text, click Create labels at the bottom of the panel, then click Open label Doc to inspect it.

Each field is replaced by that row’s value as shown in the sheet. LabelRows leaves empty lines out, so preview addresses with and without Address 2 and check the order of the postcode and country. The result is a Google Doc in your Drive, which you print from Docs. LabelRows makes text-only labels and does not add a logo or image.

If a label has more lines than fit, LabelRows shortens it and reports how many labels were affected. Pick a smaller font or revise the affected addresses, create the document again and check that each address is complete. You can also turn on Print label outlines for a check; turn it off for the final print.

The free limit is 60 labels per document, not 60 labels per A4 sheet. For a longer list, create separate Docs using row ranges. For example, use rows 2 to 61 and then 62 to 121 if row 1 contains headers and the intended rows are consecutive. Check your own row numbers and review each document before printing.

Test and print on A4

LabelRows offers a Test page with numbered, outlined labels in the selected size. The test page is free for every size and plan. Print it on plain A4 paper, place it over your label sheet and hold both in front of a light. Check the top and bottom rows as well as both columns; an apparently correct first label does not prove that the rest of the page lines up.

Print the label Doc using File → Print. Select A4 and 100% or Actual size, with no extra print margins. Check the document and print settings before using the label stock. Scaling the page to fit can change the distance between label positions as well as the overall position.

If the whole LabelRows test is slightly out of position, use Printer alignment. Nudge right and Nudge down accept values in inches from −0.5 to 0.5; negative values move the layout left or up. Make a small adjustment, print the test page again and compare it with the stock. A nudge moves the whole layout, so check the paper size and scale if the error increases across or down the page.

Once the test aligns, check your printer’s feed directions and use label stock suitable for that printer. Print one label sheet and inspect it before printing the rest. Keep the label Doc available while you check the batch, particularly when you have split the list into several documents.

Common problems

Every label is shifted by about the same amount. Measure the shift on a plain-paper test. In LabelRows, adjust Nudge right or Nudge down and test again. For a manual table, adjust the document position using the measurements you established from the stock, then check all four edges.

The top row lines up but lower rows drift. Check A4 and 100% or Actual size. In a manual table, look for an address or paragraph spacing that has made a row taller than 38.1 mm. Shorten the text or reduce its size or spacing, then test the complete page again.

The left column lines up but the right column does not. Check the label widths, the measured gap between columns and the print scale. The two label widths occupy 198.2 mm of the 210 mm page, leaving only 11.8 mm for both side margins and any gap. Compare your table with the box or manufacturer template rather than guessing how that space is divided.

An address is missing its last line. Look for the LabelRows notice that text was shortened. Use a smaller font or revise unnecessary wording, recreate the Doc and inspect the address. In a manual table, check wrapping and padding too. Keep the details needed for delivery.

The wrong recipients appear. Check the row numbers in the range. For selected rows, select the intended rows on the sheet before creating labels. If using a tick column, check which rows are ticked. For the manual method, verify the source cells and the order in which you pasted them.

The table creates an extra page. Check whether an address expanded a row or content after the table moved onto another page. Reduce excess spacing and confirm that all seven rows fit. Print another plain-paper test before using the labels.

Frequently asked questions

Is there an Avery L7163 template for Google Docs?

You can make a reusable Google Docs table with two label columns and seven rows. Size the label areas to 99.1 mm wide by 38.1 mm high, check the exact margins and any gap against your box or the manufacturer template, and test on plain A4 paper. LabelRows can also create a Google Doc for this layout.

Are Avery L7163 and J8163 the same layout?

Both codes are listed as compatible with the 38.1 × 99.1 mm A4 layout, with 14 labels per sheet. Check the code and measurements on your box and use stock suitable for your printer.

Is L7163 the same as L7160 or US 5163?

No. L7163 is an A4 sheet with 14 labels. L7160 is an A4 sheet with 21 labels, and US 5163 is a Letter sheet with 10 labels measuring 2 × 4 inches. Use the layout for the code on your box.

How can I make more than 60 labels with LabelRows Free?

The free plan creates up to 60 labels per Google Doc. Create separate documents using different row ranges, such as rows 2 to 61 and 62 to 121 when row 1 contains headers and the rows are consecutive. Check the ranges against your own sheet.

What happens if Address 2 is empty?

LabelRows leaves empty lines out of the label text. For a manual Docs table, TEXTJOIN with its ignore-empty argument set to TRUE can skip an empty Address 2 cell. Check the result for addresses both with and without that line.

Can LabelRows add a logo to an L7163 label?

No. LabelRows creates text-only labels. If you need a logo or another image, use a method that supports images and test its layout against your label stock.

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

Check that the document and printer use A4 and that the print scale is 100% or Actual size. In a manual table, long text or paragraph spacing can make a row taller and shift the rows below it. Shorten the text or reduce its size, then run 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.