Select a column. Create a new spreadsheet with a sheet in a column by category for export or print. Header and Footer Optional.
Listing updated:January 23, 2024
Works with:
6K+
Overview
Sections to Sheets is a free Google Sheets Add-on that separates rows by column sections and puts them in individual pages or sheets in a spreadsheet in preparation export and printing.

Example 1

Let's say you want to print out a list of expenditures by department and you want each department to start on a new page. You'll also want to keep the same header for each page.

Example 2

You might want to export a list of grades by class number. You sort the grades by class and then export the list with each class starting on a new page with a header and footer.

Sections to Sheets can help you achieve this quickly by creating a new Google Spreadsheet and separating each selection and putting it into a new Sheet(tab) with or without headers and footer. This will enable you to quickly export or print your sheets.

Spreadsheet programs generally don't do a good job of automatically separating data by a column and printing or exporting it out. Usually you are left with setting a header and footer and then dragging your cursor over each set data you want to have on a separate page.

This is fine if you don't have much data, but what happens if say, you want separate your sales data for each city in your state and put that data on separate pages with a neat header and footer. Then it becomes a massive chore prone to error.

But not with Sections to Sheet.
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Sections to sheets will ask for the permissions shown below. Learn more
Sections to sheets will need access to your Google account
This will allow Sections to sheets to :
See, edit, create, and delete only the specific Google Drive files you use with this app
See and download all your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu