---
title: "Create a spreadsheet"
description: "Turn survey responses into a workbook, check how formulas use the source rows, and review missing answers."
---

> Documentation Index
> Fetch the complete documentation index at: https://docs.insightgig.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Create a spreadsheet

Ask InsightGig to create an Excel workbook when you need calculations a colleague can inspect. This example uses a fictional grocery checkout survey.

For the example, set up **Retail checkout study** using [Complete a quantitative study](/research-workflows/complete-a-quantitative-study/#before-you-begin). Check that the project contains `Survey/checkout-survey.csv`. Have Excel available to inspect the formulas.

## Describe the workbook

1. Open **Research** in the study project. Name the input file and the workbook you want to save.
2. Ask for a **Raw** sheet with the original rows and a **Summary** sheet with formulas. For this example, send the following request.

   ```txt
   Create Analysis and Reporting/fee-visibility.xlsx from Survey/checkout-survey.csv.
   Put the original rows on Raw. Use formulas on Summary to count yes, no, and blank by region.
   Include all four regions and a total. Calculate the total percentage from summed counts.
   Divide yes by the valid yes-or-no base. Show blanks separately and link the saved workbook.
   Use Survey/survey-guide.md to include the exact fee question wording on Summary.
   ```
3. Open the workbook link in the reply. Check the filename and sheets before using the results.

The valid base includes **yes** and **no** answers. The workbook reports blank answers separately.

## Check the workbook

1. Select **Raw** and compare its row count and field names with the source.

2. Select **Summary**. Check counts for one region before reviewing the percentages.

   ![InsightGig workbook preview with the Summary sheet selected and the regional fee visibility table](@/assets/images/research-workflows/checkout-fee-workbook-summary.png)

3. Open the workbook in Excel. On the **Summary** sheet, select a fee percentage and read the formula in the formula bar. Check that it divides the yes count by the valid base for that region.

In the example, North has 206 yes answers out of 286 valid answers, or 72.0%. The 14 blanks remain outside the valid base. Check that **Raw** has 1,200 responses before checking the total of 1,152 valid answers.

The workbook layout and formulas can vary. Find the percentage for North by its label and check that it uses the counts shown here.

If you need to test changes, save a copy and change one source value there. Confirm that the summary updates as expected before sharing.

Check that **Summary** gives the fee question's exact wording as well as the source and the base. Follow [Evaluate research outputs](/research-workflows/evaluate-outputs/) to see how Eval flags a missing detail.

For a workbook with linked cost calculations, follow [Create complex spreadsheets](/research-workflows/create-complex-spreadsheets/).

Source: https://docs.insightgig.ai/research-workflows/create-a-spreadsheet/index.mdx
