Google Forms Bulk Response Export by Date Range

WHAT IT DOES

Google Forms Bulk Response Export by Date Range lets you export survey responses filtered by a specific date range. Instead of exporting all responses and manually filtering them, or scrolling through the response sheet to copy data one by one, this tool provides a unified checklist of responses with timestamp information. You can set a start and end date using the built-in date pickers to narrow down responses to a specific period. Select any number of responses within that date range using checkboxes, choose your preferred export format (CSV or TSV), and click Export. The tool then extracts the selected response data with full question-answer mapping and generates a clean, structured export file. This turns what could be a tedious manual filtering process into a single batch action, making time-based survey data analysis significantly faster and more precise.

WHERE IT RUNS

This script runs exclusively on the Google Forms web application in your browser. It activates on the form response view, including the embedded response spreadsheet view within Google Forms. It requires the BotGentz extension to inject and execute the script. The tool does not work on the standalone Google Sheets view of the data, the mobile app, or any third-party wrappers — only the Google Forms admin interface accessed through a Chromium-based or Firefox browser. It specifically targets pages under *.google.com/forms/*, including the form editor and response viewer.

HOW TO USE

After installing the script via BotGentz, open your Google Form and navigate to the "Responses" tab. The tool automatically detects the response data and displays a floating panel on the right side. The panel shows all responses, with each response displaying its timestamp and a preview of the first few answers. Use the date pickers to set the start and end dates for your desired date range — responses outside this range will be hidden. Check the boxes for every response you want to export. Below the response list, toggle between CSV and TSV format using the toggle switch. You can also toggle whether to include the timestamp column in the export. Click "Export Selected" and the tool will extract the selected response data and generate the export file for download.

THE ACTUAL MECHANISM — WHY IT WORKS

Google Forms displays responses in a tabular view within the form interface, often embedded directly in the page. The response data is rendered as a table with question labels as column headers and each response as a row. This tool scans the DOM for the response table using multiple selector patterns that Google Forms consistently uses across versions. It extracts the question headers from the table header row and each response row's data cells, building a complete question-answer mapping for each response. The timestamp is extracted from the first column or from a dedicated timestamp field. For date range filtering, the tool parses the timestamp string from each response and compares it to the start and end dates provided by the user, displaying only matching responses. When exporting, the tool generates CSV with question labels as headers and each selected response as a row, or TSV for compatibility with Google Sheets. This approach works without making direct API calls, which would require authentication tokens and knowledge of Google Forms' internal API structure. By reading the rendered DOM, the tool captures exactly what you see on the page.

THE PANEL

The floating panel is fully draggable — click and drag the header to reposition it anywhere on the page. The panel's position is saved per site in localStorage, so it reappears exactly where you left it when you return to the form. Double-click the header to snap the panel to the nearest edge (left or right). A collapse button minimizes the panel to a small tab showing a calendar emoji badge, keeping it out of the way while still accessible. The response list inside the panel is scrollable and resizes vertically based on the number of responses. Pressing Escape while the panel is focused closes it completely; reopening is done via a small button injected near the page header. All panel interactions are non-blocking — Google Forms' main UI remains fully responsive while the panel is open, and the panel updates automatically when you navigate between forms or pages.

PLEASE NOTE

This script requires the BotGentz extension (free) to run user scripts on Google Forms. Google Forms frequently updates its web interface and response display structures; if the tool stops working, check for an updated version within BotGentz's script repository. This tool does not store, transmit, or log any response data or question content — all operations occur locally in your browser with no external network requests except those made by Google Forms itself. Exported data is generated entirely from the visible page content. For very large response lists with dozens or hundreds of entries, the tool may take a moment to generate the export file — a status message indicates when the export is complete. The date filtering is applied in the browser based on the displayed timestamps; ensure your responses are fully loaded on the page before filtering. The tool only affects responses visible on the current page; to export all responses, ensure you have loaded all responses in the view. The CSV export uses comma-separated values with quoted fields, compatible with all major spreadsheet applications. The TSV export uses tab-separated values, which is the native format for pasting into Google Sheets.