Free Tool

Free Google Forms Prefilled Link Generator

Build a Google Forms prefilled link with answers already filled in, edit entry IDs and values, generate mail-merge templates, and turn any Google Doc, Sheet or Slide into a make-a-copy link. Free, browser-only.

Finding entry IDs

  1. Open the form editor, click the three-dot menu, choose "Get pre-filled link".
  2. Type anything into each question you want to prefill, then click "Get link" and "Copy link".
  3. Paste that link above and click "Load entry values". Each entry.NNNNN is one question.
Fields
Prefilled link

Paste the form URL and add at least one entry ID. The link updates as you type. For the same form across many recipients, turn on template mode and feed it to your mail merge, then shorten each link.

No signup required
Free forever
GDPR compliant
Powered by U2L

Quick Answer

A Google Forms prefill link generator builds a form URL that carries answers in the query string, so the form opens with fields already completed. Each question has a numeric entry ID; the link looks like /viewform?usp=pp_url&entry.1234567=Value. Paste a form URL, add entry IDs and values, copy the link. A second tab makes force-copy links for Docs, Sheets and Slides.

Quick Facts

  • Prefill syntax: https://docs.google.com/forms/d/e/FORM_ID/viewform?usp=pp_url&entry.ENTRY_ID=Value. Google's own 'Get pre-filled link' feature emits exactly this format.
  • Entry IDs are numeric (typically 9 or 10 digits) and are fixed per question. Find them by generating a pre-filled link from the form editor and reading the entry.NNNNN parameters.
  • Checkbox questions take several values by repeating the same entry ID: entry.123=A&entry.123=B. Choice, dropdown and checkbox values must match the option text exactly.
  • Date questions split into entry.ID_year, entry.ID_month and entry.ID_day; time questions into entry.ID_hour and entry.ID_minute (24-hour).
  • File upload questions cannot be prefilled. Every prefilled answer stays editable by the respondent.
  • Make-a-copy links replace /edit with /copy on Docs, Sheets, Slides and Drawings. Add ?copyComments=true to carry comments across. The file must be shared with at least Viewer access.
  • Nothing is uploaded: the URL is assembled in your browser from the text you type.

How to create a Google Forms prefilled link

Get entry IDs, set values, copy the link.

  1. 2

    Paste it here and load the fields

    Paste the link into the form URL box and click 'Load entry values'. Each entry.NNNNN becomes an editable row with its ID and current value. You can also paste the plain viewform URL and add entry IDs by hand.

  2. 3

    Set the question type and values

    Pick Text for short answer, paragraph, multiple choice and dropdown. Pick Checkbox to enter one value per line, Date or Time for those question types, and 'Other' to prefill a custom answer on a choice question that has an Other option.

  3. 4

    Copy, shorten, or export a template

    Copy the prefilled URL, or click Shorten with U2L to get a short link for email, print or a QR code. Turn on template mode to output {{placeholders}} you can feed to a mail merge, then shorten each personalized link.

What is a Google Forms Prefill Link Generator?

Google Forms Prefill Link Generator is a browser tool that assembles the query string Google Forms reads on load - usp=pp_url plus one entry.ID=value pair per question - so a respondent opens the form with answers already filled in. It also builds make-a-copy links for Google Docs, Sheets, Slides, Drawings and Forms so each visitor gets their own editable copy.

Google Forms assigns every question a numeric entry ID when it is created. The ID never changes, even if you rename or reorder the question, which is what makes prefilled URLs stable. When the form loads, it reads the query string, matches each entry.ID parameter to a question, and writes the value into the field. Text questions accept anything; choice, dropdown and checkbox questions accept only values that exactly match an existing option; date and time questions expect separate year, month, day, hour and minute parameters.

The practical value is that you can send one form to many people with the parts you already know filled in: a customer's name and order number in a feedback survey, a student's class in an assignment form, a venue code on an event check-in form, or a hidden 'Source' answer that tells you which email or poster a response came from. The respondent only fills in what is genuinely new. Combined with a mail merge, that becomes a personalized link per recipient.

The second tab covers a related trick for the rest of Google Workspace. Replacing /edit with /copy in a Docs, Sheets, Slides or Drawings URL prompts the visitor to save a copy, which is how teachers hand out worksheets and teams share templates without anyone editing the original. Google Forms accepts /copy too, but only for people who already have edit rights on the form, so the tool labels that link accordingly.

How does a Google Forms Prefill Link Generator work?

The tool first normalizes the form URL. Both the published respondent form (/forms/d/e/1FAIpQL.../viewform) and the editor URL (/forms/d/ID/edit) are accepted; the path is rewritten to end in /viewform and any existing query string is dropped. forms.gle short links are rejected with a hint because the form ID is hidden behind a redirect that the browser cannot follow from a page on another origin; opening the short link once and copying the full address solves it. If the pasted URL already carries entry.* parameters, 'Load entry values' parses them into rows, merging repeated IDs into a checkbox row and _year/_month/_day or _hour/_minute suffixes into a date or time row.

The output is built with usp=pp_url first, which is the marker Google's own pre-fill feature adds, followed by one parameter per row. Text rows emit entry.ID=value with the value passed through encodeURIComponent, so spaces become %20, ampersands %26 and non-Latin text is percent-encoded as UTF-8. Checkbox rows emit the same entry ID once per line of input. Date rows emit entry.ID_year=2026, entry.ID_month=9 and entry.ID_day=15 from a YYYY-MM-DD value; time rows emit entry.ID_hour and entry.ID_minute from HH:MM. The 'Other' type emits the two-parameter pair that Google's pre-fill tool produces for a custom answer on a choice question: entry.ID=__other_option__ and entry.ID.other_option_response=your text.

Two optional fields cover form-level parameters. emailAddress= prefills the email box on forms set to collect the responder's email as an input field (it has no effect when Google collects the signed-in address automatically), and hl= sets the interface language of the form page using a language code such as es or hi. Template mode swaps every value for a {{placeholder}} token instead of a literal, producing a URL skeleton you can hand to a mail-merge tool or a spreadsheet formula, which then substitutes and encodes per recipient. Rows whose entry ID is not 6 to 12 digits are skipped and flagged rather than producing a broken link.

The make-a-copy tab parses docs.google.com URLs for the five apps and builds https://docs.google.com/APP/d/ID/copy. For Docs, Sheets, Slides and Drawings it can append copyComments=true, includeResolvedCommentsOnCopy=true (only meaningful together with copyComments) and title=Suggested name, and it also offers /preview (the document without the editing toolbar) and /template/preview (a template-gallery style page with a 'Use template' button). All of these depend on the original file's sharing: the visitor must be able to view it, so 'Anyone with the link' at Viewer level is the setting that makes the links work for everyone.

Use Cases

How marketers, businesses, and developers use google forms prefill link generator.

Personalized survey links from a mail merge

Prefill the respondent's name, email and customer ID so a feedback form takes ten seconds to submit. Use template mode to get a {{placeholder}} URL, drop it into a Gmail mail merge or Mailchimp with the matching merge tags, and shorten each result with U2L so the email shows a clean link and you can see who clicked.

Tracking the source with a hidden question

Add a short-answer question titled Source, move it to the last section, and prefill it with a different value per channel: poster, newsletter, instagram. Responses arrive tagged with where they came from, the way /tools/utm-builder tags website traffic. Respondents can see the field, so keep the values plain and harmless.

Event check-in QR codes

Print a QR code per venue, table or session that opens the check-in form with the location already selected. Guests only type their name. Generate the prefilled link here, shorten it so the QR code stays simple, and build the code with /qr-code-generator. A short link also lets you fix the form later without reprinting.

Google Forms prefilled URL for classes and cohorts

Teachers share one form with the class, period or assignment name prefilled so the response sheet sorts itself. Because the dropdown value must match an option exactly, copy the option text from the form rather than retyping it. A separate link per class keeps the sheet clean without duplicating the form.

Force copy Google Doc link for worksheets and templates

Share a worksheet, brief or contract template as a /copy link so every recipient gets an editable copy in their own Drive and your master stays untouched. Turn on copyComments when the comments are part of the instructions. Works for Docs, Sheets, Slides and Drawings; for Forms, only editors can copy.

Support and returns forms with the order prefilled

Link from an order confirmation email to a returns form with the order number, SKU and purchase date already entered. Date questions need the _year, _month and _day parameters, which the Date type builds for you from a single YYYY-MM-DD value.

Multi-select defaults on checkbox questions

Pre-tick the options most people choose - for example the sessions in a default conference track - by entering one value per line for a checkbox question. The tool repeats the entry ID once per value, which is the syntax Google expects. Respondents can untick anything.

Localized forms with hl=

The hl parameter sets the language of Google's form chrome (buttons, validation messages, the Submit label) without changing your question text. Pair a Spanish-language prefilled link with hl=es for a consistent experience. Combine with /tools/email-qr-code-generator when the form lives on a printed piece.

Template gallery style previews

The /template/preview link shows a Doc, Sheet or Slide deck the way Google's template gallery does, with a large 'Use template' button that creates a copy. It is a friendlier landing page than the raw /copy prompt when you are publishing a template on a website or in a newsletter.

Google Forms Prefill Link Generator vs Alternatives

Side-by-side feature and pricing comparison with the top alternatives.

FeatureU2LGoogle Forms built-inFormfacade add-onManual URL editing
Free, no signupFree tier
Edit entry values after the link existsRegenerate each timeError-prone
Date, time, checkbox and Other syntax handledVaries
Template mode for mail merge
Make-a-copy links for Docs, Sheets, SlidesManual
Short branded link with click statsVaries
Needs form owner accessOnly to find entry IDsOnly to find entry IDs
Runs in the browser, nothing storedGoogle

Google Forms Prefill Link Generator vs Google's built-in 'Get pre-filled link'

Google's feature is the source of truth for entry IDs and the safest way to get the syntax right for every question type, including grids. It is also the only way to discover the IDs without inspecting the page source. Use it first.

Where it falls short is iteration: every change means re-opening the editor, retyping the answers and regenerating the link, and it cannot produce a template with placeholders. This tool takes Google's link as input, lets you edit values in place, add or remove fields, switch a field to checkbox or date syntax, and outputs a mail-merge template or a short link.

Google Forms Prefill Link Generator vs Formfacade and other prefill add-ons

Workspace add-ons such as Formfacade's Prefill and Email can generate personalized links per row in a Sheet, send them by email, and hide prefilled questions from the respondent. If you need hidden fields or bulk sending inside Google Sheets, an add-on is the right tool.

They require installing an add-on with access to your forms and often gate volume behind a paid plan. This generator has no install and no access to your Google account: it only builds URLs. Pair its template mode with your existing mail-merge tool and U2L short links for tracking, and you cover most of the add-on use case without the permissions.

Best Practices

Always start from Google's pre-filled link

Guessing entry IDs does not work: they are 9 or 10 digit numbers assigned at creation. Generate a pre-filled link once from the form editor with a placeholder in every question you care about, paste it here, and edit from there. Save the raw link in your notes for later.

Copy option text exactly

Multiple choice, dropdown and checkbox prefills are matched against the option labels character for character. 'Yes' and 'yes' are different, and a trailing space breaks the match. Copy the option from the form editor rather than typing it.

Put tracking questions in a final section

A prefilled 'Source' question is visible to respondents unless you move it to its own section at the end of the form. That section still submits with the answer. Do not rely on it for anything sensitive, since anyone can edit the value.

Shorten personalized links

A prefilled URL with five fields runs to 300 or more characters and looks alarming in an email. A U2L short link is readable, fits on a printed card, tracks who clicked, and can be edited if you change the form later. Shorten the final personalized URLs, not the template.

Test with a private window

Open the prefilled link in a private or incognito window. If the form requires sign-in or collects email automatically, you will see the real respondent experience instead of your own owner view, and you will catch a value that failed to match an option.

Use template mode for mail merge

Template mode outputs {{field_ID}}, {{email}}, {{year}} style tokens. In Google Sheets, build the link with SUBSTITUTE and ENCODEURL so values with spaces and ampersands survive. Gmail mail merge and Mailchimp merge tags work the same way.

Share copies at Viewer level

For /copy links, the original needs 'Anyone with the link' with the Viewer role. Editor access is not required and lets recipients change your master. If a recipient sees 'You need permission', the sharing setting is the cause, not the link.

Keep prefilled data non-sensitive

Everything in the URL is visible in browser history, email logs and analytics. Prefill names, IDs and choices; never passwords, payment details or health information. Shortening the link hides the parameters from casual view but does not encrypt them.

Common Mistakes to Avoid

Pasting a forms.gle short link

The short link redirects to the real form, so the form ID and entry IDs are not in it. Open the short link in your browser, copy the docs.google.com/forms/d/e/.../viewform address, and paste that instead.

Prefilling a choice with text that is not an option

If the value does not match one of the options exactly, Google silently ignores it and the question opens blank. Check spelling, capitalization and spacing against the option label in the editor.

Sending a single date value

entry.ID=2026-09-15 does nothing on a date question. Date questions need entry.ID_year, entry.ID_month and entry.ID_day. Choose the Date type in the tool and it emits all three from one input.

Expecting file uploads or hidden fields

File upload questions cannot be prefilled, and Google Forms has no hidden fields. Any prefilled value can be seen and changed by the respondent. For tamper-proof tracking, use a separate short link per channel and read U2L's click data.

Sharing a /copy link for a Form to non-editors

Forms copy only for people with edit access. A Viewer gets a permission error. Either add the recipient as an editor first, publish the form as a template via a shared Drive folder, or send Docs and Sheets instead, which copy at Viewer level.

Forgetting URL encoding in a spreadsheet formula

Building the link in Sheets with plain concatenation leaves spaces and ampersands in the URL, which truncates values or breaks the parameter list. Wrap each value in ENCODEURL, or paste a finished link back into this tool to check what it decodes to.

Technical Specifications

Prefill basehttps://docs.google.com/forms/d/e/FORM_ID/viewform?usp=pp_url
Text / choice / dropdownentry.ID=value (choice values must match option text)
Checkboxentry.ID=A&entry.ID=B (repeat the ID per value)
Date and timeentry.ID_year, _month, _day; entry.ID_hour, _minute (24h)
Other optionentry.ID=__other_option__&entry.ID.other_option_response=text
Form-level paramsemailAddress= (responder-input email), hl= (interface language)
Make a copy/copy, ?copyComments=true, &includeResolvedCommentsOnCopy=true, &title=
Not supportedFile upload prefill; forms.gle short links; hidden fields
PrivacyBuilt in the browser; no data sent to U2L or Google

Industry-Specific Use Cases

Education

Prefill class and assignment names so response sheets sort themselves, and share worksheets as /copy links so each student edits their own copy. Google Classroom's 'Make a copy for each student' remains the better option inside Classroom itself.

Events

One check-in or feedback form, a prefilled link per session or venue, and a QR code per poster. Shortened links keep the codes scannable, and click counts per code show which sessions drew traffic before the form data is even opened.

Customer support

Link from order confirmations and support emails to a returns or satisfaction form with the order number, product and purchase date already entered. Fewer fields to type means more completed forms.

Recruiting and HR

Send candidates and new hires forms with their name, role and start date prefilled from your tracking sheet using template mode and a mail merge, and hand out policy acknowledgment Docs as /copy links.

Frequently Asked Questions

What is a Google Forms prefill link generator?

It is a tool that builds a Google Forms URL carrying answers in its query string - usp=pp_url plus entry.ID=value pairs - so the form opens with those fields already completed. This one also edits links Google generated, handles checkbox, date, time and Other syntax, and outputs mail-merge templates.

How do I find the entry ID for a Google Forms question?

In the form editor, open the three-dot menu, choose 'Get pre-filled link', type a placeholder into the question, click 'Get link', then 'Copy link'. The URL contains entry.NNNNNNNNN=placeholder for each question you filled. Paste it here and the tool lists them.

What does usp=pp_url mean?

It is the parameter Google adds to links produced by the pre-fill feature; pp_url stands for the prefilled-URL source. The form loads prefilled values with or without it, but including it matches Google's own output and is what the tool emits.

Can I prefill checkbox questions with more than one value?

Yes. Repeat the same entry ID once per option: entry.123=Option A&entry.123=Option C. Choose the Checkbox type in the tool and enter one value per line. Each value must match an option label exactly.

How do I prefill a date or time question?

Dates use three parameters: entry.ID_year, entry.ID_month and entry.ID_day. Times use entry.ID_hour and entry.ID_minute in 24-hour form. Pick the Date or Time type, enter one value, and the tool splits it for you.

Why is my prefilled value not showing up?

The three usual causes: the value does not exactly match an option label on a choice, dropdown or checkbox question; the entry ID belongs to a different question or a different form; or the value was not URL-encoded so a space or ampersand cut it off. Test in a private window.

Can I prefill a file upload question?

No. File upload questions cannot be set from the URL. Grids and linear scales can be prefilled, but the safest way to get their exact syntax is to generate a pre-filled link from the form editor and load it into the tool.

Why does my forms.gle link not work here?

forms.gle links are short redirects and do not contain the form or entry IDs. Open the short link once in your browser, copy the full docs.google.com/forms/d/e/.../viewform address from the address bar, and paste that.

Can respondents change prefilled answers?

Yes. Prefilled values are ordinary field contents and can be edited or cleared before submitting. Google Forms has no read-only or hidden fields, so treat prefilled data as a convenience for the respondent, not as tamper-proof tracking.

How do I use a prefilled link with a mail merge?

Turn on template mode to get {{placeholder}} tokens in place of values. In Google Sheets, replace them with SUBSTITUTE and wrap values in ENCODEURL; in Gmail mail merge or Mailchimp use the matching merge tags. Then shorten each finished link with U2L so the email shows a short, tracked URL.

How do I make a Google Doc force-copy link?

Replace /edit and everything after it with /copy: https://docs.google.com/document/d/ID/copy. Visitors see a 'Make a copy' prompt that saves an editable copy to their Drive. The make-a-copy tab builds it for Docs, Sheets, Slides and Drawings, with optional comment copying and a suggested title.

Does the make-a-copy link work for Google Forms?

Only for people who can already edit the form. https://docs.google.com/forms/d/ID/copy shows a permission error to viewers. To share a form as a template with others, add them as editors first, or put the form in a shared Drive folder they can access.

What does copyComments=true do?

It carries the document's comments into each copy, which is useful when the comments are instructions or feedback prompts. Add includeResolvedCommentsOnCopy=true to bring resolved comments too. Both are query parameters on the /copy URL.

Is my form data uploaded to U2L?

No. The tool builds the URL from the text you type, in your browser. It does not open your form, does not read your Google account, and only makes a network request if you click Shorten with U2L.

Is the Google Forms prefill link generator free?

Yes. It is free with no signup and no limit on links. Shortening results with U2L is optional; anonymous short links are rate-limited and a free account removes that limit and adds click statistics.

Prefilled link vs a separate form per audience: which is better?

Prefilled links. One form with a prefilled Source or Class question keeps every response in a single sheet and every edit in one place. Separate forms multiply maintenance and split the data. Use a short link per audience so you can also count clicks per channel.

Google Forms prefilled URL vs a QR code: do I need both?

A QR code is just a way to deliver the URL, so yes when the audience is physical - posters, badges, table cards. Shorten the prefilled URL first: a 300-character link produces a dense code that scans poorly at small sizes, while a short link scans reliably and can be re-pointed later.

What are the Google Forms URL parameters besides entry?

usp=pp_url marks a prefilled link, emailAddress= prefills the email field on forms that collect the responder's email as an input, hl= sets the interface language (hl=es, hl=hi). The tool exposes all three. There is no parameter to hide questions or lock values.

Key Terms

Entry ID
The numeric identifier Google Forms assigns to each question. Used as entry.ID in prefilled URLs; fixed for the life of the question.
usp=pp_url
The parameter Google's 'Get pre-filled link' feature adds to mark a prefilled form URL.
Prefilled link
A form URL whose query string carries answers, so the form opens with those fields already completed and editable.
Force copy link
A Docs, Sheets, Slides or Drawings URL ending in /copy that prompts the visitor to save their own copy of the file.
Merge tag
A placeholder such as {{name}} or *|FNAME|* that a mail-merge tool replaces with each recipient's data when sending.
URL encoding
Replacing characters that are not allowed in a URL (spaces, ampersands, non-Latin letters) with percent sequences such as %20 so they survive as parameter values.

Turn long prefilled links into short, trackable ones

A personalized Google Forms URL runs to hundreds of characters. Shorten it with U2L for a clean branded link that fits in an email or a QR code, shows you clicks per channel, and can be re-pointed if the form changes. Sign up free.

Sign up free