Workbook data collection

Collect workbook rows through a simple share link.

Create forms from saved workbook columns, share a public link, and review responses as they are saved back to the workbook.

WorkbookWise preview

Form workflow

XLSX

Item

Question

Detail

Invoice No.

Status

Required

Item

Answer

Detail

INV-1042

Status

Saved

Item

Workbook row

Detail

Updated or added

Status

Tracked

Preview

Form workflow

3 sample rows show the shape before users commit.

Validation

Checked output

Formula and internal fields cannot be made editable.

Included

7 core areas

Business add-row forms

Problem

Why this feature exists

Workbook owners often need updates from staff, vendors, customers or branch teams, but sending the whole Excel file creates copy-paste work and accidental edits.

Approach

How WorkbookWise handles it

WorkbookWise Forms turns selected saved-workbook columns into a simple share link. Owners decide which fields are asked, read-only or hidden, then review whether each submission was saved as a new row or used to update an existing row.

Outcomes

What you can accomplish

Collect rows without sharing the full workbook.
Keep helper, formula and internal columns protected.
Use update and prefilled links for existing-row workflows on Business.
Review submissions, uploaded files and writeback status in one place.

Who it is for

Built around real workbook owners

Business owners

Collect daily sales, payment status, stock updates or field reports from staff.

Accountants

Ask clients or vendors for invoice, payment and document updates without exposing workbook formulas.

Schools and clinics

Collect fee, appointment, receipt or parent/customer information through a simple form.

Operations teams

Use private update links when one existing workbook row needs a controlled correction.

Common workflows

Common tasks you can complete

Add customer payment updates
Update invoice status using a private link
Collect vendor details with file uploads
Use dropdown choices from workbook columns
Create regional-language form labels
Review failed or pending saves
Generate personalized update links
Hide GST/PAN/helper fields from public forms

How it works

From input to useful output

1

Choose a saved workbook

Forms start from a workbook the owner already saved in the workspace.

2

Pick the questions

Show only useful fields, hide private fields, and keep formula/internal fields read-only.

3

Configure behavior

Business users can enable update, prefill, dropdown and upload flows after choosing safe fields.

4

Publish the link

Share the public form link or generate personalized update links where the plan allows it.

5

Review responses

Open the responses page to see values, row action, record key, upload references and save status.

Product example

Payment Update Form

A payment form can ask for invoice number, paid amount and payment date while keeping GST/PAN/helper fields out of the public form.

Workbook Field
Form State
Plan
Invoice No.
Ask user
Business
Paid Amount
Ask user
Business
GSTIN/PAN
Hidden or read-only
Business
Receipt upload
File upload
Business
Forms are included in Business plans.
Business adds bulk personalized update links.

Included

What the flow covers

Business add-row forms
AI field suggestions with owner review
Update and upsert modes
Approved prefilled links
Dynamic and dependent dropdowns
File upload fields
Bulk personalized links

Trust notes

Formula and internal fields cannot be made editable.
AI suggestions only review field names and answer types.

What it does

Core capabilities

Create add-row forms from saved workbook fields.

Use Business for update links, prefilled answers, dynamic dropdowns and uploads.

Review submissions and workbook writeback status from the owner workspace.

FAQ

Frequently asked questions

Is this a mobile-only form?

No. The same form works on phone and desktop browsers, so staff, vendors or customers can submit updates from the device they already use.

Can Free or Pro users create forms?

No. Forms are part of Business so support, public submissions, uploads and writeback limits stay predictable.

Which form features need Business?

Add-row forms, update rows, prefilled links, dynamic dropdowns, dependent dropdowns, file uploads and regional-language form labels are Business features.

What does Business include?

Business includes 20 active forms, 5,000 responses per month and bulk personalized form links.

Can formula fields be edited from a form?

No. Formula and internal workbook fields can be hidden or shown read-only, but not made editable.

Related features

Continue exploring WorkbookWise

Open in App

Related Excel formats

Start from a matching free workbook

Ready to use Forms?

This page explains the workflow in detail. The app is where the user creates, downloads, saves or exports the workbook.