--- title: Editing groups of questions in a spreadsheet description: In Appulate, related questions are often grouped together in collections, for example, Locations and Payroll and Rating. The Edit in spreadsheet functionality allows you to edit these questions. --- [Skip to content](https://help.appulate.com/en/knowledge/edit-in-spreadsheet#main-content) English Show submenu for translations ![appulatelogo-1.svg\]](https://help.appulate.com/hubfs/appulatelogo-1.svg) - [Appulate](https://appulate.com/?browse) Open main navigation Close main navigation - [Appulate](https://appulate.com/?browse) - English Show submenu for translations - [appulate.com](https://appulate.com/) [appulate.com](https://appulate.com/) Get help from Appulate team - There are no suggestions because the search field is empty. 1. [Help](https://help.appulate.com/en/knowledge?hsLang=en) 2. [Using Appulate](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en) 3. [Questionnaire & Forms](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#questionnaire-forms) # Editing groups of questions in a spreadsheet In Appulate, related questions are often grouped together in collections, for example, **Locations** and **Payroll and Rating**. The **Edit in spreadsheet** functionality allows you to edit these groups of questions in a spreadsheet. This simplifies the workflow if you store the insured's information in spreadsheets – you can easily copy and save it to Appulate. The **Edit in spreadsheet** functionality is implemented with two buttons in a collection's top-right corner: - **![download](https://help.appulate.com/hs-fs/hubfs/download.png?width=25&name=download.png)** (**Download**)downloads the spreadsheet to your computer. - **Edit in spreadsheet** opens a spreadsheet with the collection's questions for editing. Note: Not all collections are available for editing. The **![download](https://help.appulate.com/hs-fs/hubfs/download.png?width=25&name=download.png)** (**Download**)button is displayed for collections in policies to allow you to save the data as a spreadsheet. ### Editing a collection in a spreadsheet 1\. Click the **Edit in spreadsheet** button in a collection's top-right corner. [![edit in spreadsheet](https://help.appulate.com/hs-fs/hubfs/2024-02-12_15-46-34%20edit%20in%20spreadsheet.png?width=688&height=323&name=2024-02-12_15-46-34%20edit%20in%20spreadsheet.png)](https://help.appulate.com/hubfs/2024-02-12_15-46-34%20edit%20in%20spreadsheet.png?hsLang=en) 2\. This will open the **Edit** dialog with the collection's questions in a spreadsheet. Make the edits and click **Save**. Note: Some cells cannot be edited. A warning message will appear.  [![edit collection](https://help.appulate.com/hs-fs/hubfs/2024-02-12_15-48-13%20edit%20collection.png?width=688&height=387&name=2024-02-12_15-48-13%20edit%20collection.png)](https://help.appulate.com/hubfs/2024-02-12_15-46-34%20edit%20in%20spreadsheet.png?hsLang=en) 3\. The edits you have made will be saved. The collection is updated accordingly. [![editing groups of questions in a spreadsheet](https://help.appulate.com/hs-fs/hubfs/2024-02-12_15-50-47%20editing%20groups%20of%20questions%20in%20a%20spreadsheet.gif?width=688&height=323&name=2024-02-12_15-50-47%20editing%20groups%20of%20questions%20in%20a%20spreadsheet.gif)](https://help.appulate.com/hubfs/2024-02-12_15-50-47%20editing%20groups%20of%20questions%20in%20a%20spreadsheet.gif?hsLang=en) Note: Questions in Appulate often only accept a certain type of data as an answer (e.g. only numbers or only text). When you click **Save** in the **Edit** dialog and return to the questionnaire, you may see that some answer hasn't been filled in or is highlighted in red. A message below will explain how to rectify the error.  ![](https://help.appulate.com/hubfs/image-png-May-04-2023-02-56-46-3940-PM.png)   - [Getting started](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#main-content) - [How to start](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#how-to-start) - [For agencies](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#for-agencies) - [Submissions & Quotes](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#submissions-quotes) - [Users](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#users) - [Company settings](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#company-settings) - [Additional information](https://help.appulate.com/en/knowledge/getting-started?hsLang=en#additional-information) - [Using Appulate](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#main-content) - [Appulate functionality](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#appulate-functionality) - [Main pages](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#main-pages) - [Questionnaire & Forms](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#questionnaire-forms) - [Submissions & policies](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#submissions-policies) - [For MGAs and carriers](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#for-mgas-and-carriers) - [For agents](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#for-agents) - [Working with Insured](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#working-with-insured) - [Email Notifications](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#email-notifications) - [Notes and messages](https://help.appulate.com/en/knowledge/using-appulate?hsLang=en#notes-and-messages) - [Tools & integrations](https://help.appulate.com/en/knowledge/tools-integrations?hsLang=en#main-content) - [Uplink](https://help.appulate.com/en/knowledge/tools-integrations?hsLang=en#uplink) - [Weblink](https://help.appulate.com/en/knowledge/tools-integrations?hsLang=en#weblink) - [AMS](https://help.appulate.com/en/knowledge/tools-integrations?hsLang=en#ams) - [FAQ & troubleshooting](https://help.appulate.com/en/knowledge/faq-troubleshooting?hsLang=en#main-content) - [FAQ](https://help.appulate.com/en/knowledge/faq-troubleshooting?hsLang=en#faq) - [New features](https://help.appulate.com/en/knowledge/new-features?hsLang=en) - [AppulateConnect](https://help.appulate.com/en/knowledge/appulateconnect?hsLang=en) - [Appulate](https://appulate.com/?browse) [![Appulate Logo](https://help.appulate.com/hubfs/Blog%20SVG-1.svg "Appulate Logo")](https://blog.appulate.com/?hsLang=en) Copyright © 2026, Appulate Inc.