How do I use records from a spreadsheet (Google) to create a printable directory?

Question

I have a Google Sheets table with records containing our members' contact information.

How do I publish that in a Google Doc or other format for printing to PDF or printer?

The spreadsheet contains records in long rows.

The directory (I would call it a "report") is an alphabetized list with the following requirements:

Record values are in a vertical format
Records are in order by field "last name"
Record sets are set apart by the first letter of "last name" field

Example:


arr Ordinals = [A-Z];


foreach Ordinal in Ordinals :

  <>

  for Record in Records where Record.LastName begins with Ordinal:

    <>
    <>, <>
    <>
    <>
    <>, <> <>
    <>
    <>
    <>
    <>

  endfor

endforeach

userOq52 · Answer

This is a quick solution for users with access to Microsoft Word that uses "Mail Merge" to create a directory https://support.microsoft.com/en-us/office/create-a-directory-of-names-addresses-and-other-information-49afe95c-dc99-4cd3-85c7-3a80869cff90.

How do I use records from a spreadsheet (Google) to create a printable directory?

1 Answers