Exports and history
Export to Google Sheets
Rows can go straight into a Google Sheet rather than a file. There is one prerequisite, and it is the step people miss: the sheet has to be shared so that the exporter can write to it.
Create or open a Google Sheet
Any sheet you own will do. The export adds a new tab rather than overwriting what is there.
Share it so the link can edit
Set the sheet’s sharing to allow anyone with the link to edit. Without edit access on the link, the export cannot write and will fail.
Copy the sheet’s link
Use the ordinary share link. It is checked before anything is written, so a wrong link fails immediately rather than half way through.
Run the export
Paste the link and export. Rows stream into a new tab in that sheet.
Reuse it next time
Sheets you have used before are remembered, so you do not paste the link again.
Worth knowing
- Anyone with the link can edit is a permanent setting on your document, not a temporary grant for the moment of the export. Tighten it again afterwards if the sheet holds anything sensitive.
- Exports are written through one shared account, so a very large export is paced rather than fired all at once. It will finish; it may not finish instantly.
- Re-sending a past export from your history into a sheet is free. It is the same rows you already paid for.
Try this on the real database
Free trial with the full dataset and every filter, and the allowance resets daily rather than expiring.