Export All Your Program Data
Download everything TRIOPilot holds for your program, every record, text message and uploaded document, as ZIP files or straight into a folder on your device.
Your data belongs to you. Export All Program Data downloads everything TRIOPilot holds for your program and saves it to your device:
- Program Records: one ZIP file with every record, as spreadsheets and as JSON Lines, and the list of every uploaded document.
- Documents: every uploaded file (FAFSA documents, transcripts, signatures) in ZIP files of up to 1 GB or 10,000 files each, called parts, with one folder per student.
TRIOPilot builds every file in your browser, so no copy of your export is stored anywhere else.
Who Can Export
Only admins of your program can export all program data, and exporting is not a permission your admin can give to other roles, just as deleting students is not (see Add a User or Advisor). If you work in more than one program, you need to be an admin of the program you are viewing. A TRIOPilot support person can also run an export for your program, for example when a contract ends; your admins get the same email when they do.
Start an Export
- Go to Settings, choose the Account tab, and choose Export All Program Data.
- Read What You Get and Keep It Safe. What You Get shows how many students your program has today, how many documents its list of uploaded documents names, and how many files the Documents download holds and how large they are. The count includes the files the export keeps that you might not expect (see below), so it matches the export you start.
- Choose Email Me a Code. TRIOPilot emails a 6-digit code to the address you sign in with. It expires in 10 minutes.
- Type the code under Code and choose Start Export.
The code keeps someone who gets hold of your signed-in browser from taking every record. You have five tries. After that, send a new code. You can send one code a minute, and at most 5 codes an hour. After the fifth, the page asks you to wait up to an hour before sending another.
When the export starts, every admin of your program gets an email saying who started it and when. Nobody can turn that email off. If you did not expect one, email support@triopilot.com.
Download Program Records
Under Your Export, choose Download Program Records. The page reads each part of your program's records and shows its progress, then saves the ZIP file, named like stonefield-eoc-program-records-2026-09-30.zip. Keep the page open until it says it saved the file. For a large program this can take several minutes.
The ZIP file holds:
- csv/: one spreadsheet (CSV) per table, for example
students.csv,student_program_years.csv,contacts.csv,text_messages.csv,comments.csv,appointments.csv,events.csv,applications.csvandaudit_log.csv. Each opens in Excel or Google Sheets. Accented names open correctly. Every time is on your program's clock, with its offset from UTC. Beside a staff member's or a student's id, a column ending in _name gives their name. Your program's own profile fields each have their own column, namedcustom_fields.followed by the field's key.short_links.csvlists each short go.triopilot.com address your texts carried (the code after the slash, in token) and the web address it opens. - json/: the same rows in JSON Lines, one record per line, exactly as stored. If you are moving your data into another system, give it these files, not the spreadsheets.
- data-dictionary.csv: every spreadsheet column with its label, its type and, where TRIOPilot has them, its allowed values.
- documents.csv: every document uploaded for your program, with the student, the file name, who uploaded it, when, its size and type, its status, and where it is in the document download (Path in Download and Part). Included means the file is in one of the Documents parts. Not in storage means a record names the file, but the file itself is not in storage. Deleted record means the file belongs to a record your staff deleted. Deleted, file removed means someone deleted the document itself. Not linked to a record means a file in your program's storage that no record names.
- branding/: your program's logo and homepage images.
- README.txt: what each file is, when the export started and when the records were read.
Spreadsheet safety. In the spreadsheets, a value that starts with =, +, -, @, a tab or a carriage return has an apostrophe added in front, so a spreadsheet never runs it as a formula. A value longer than 32,000 characters is replaced by a note that points to the same row in the JSON Lines file, which holds every value exactly.
What is included that you might not expect. Records your staff deleted that TRIOPilot still keeps so support can restore them are in deleted_records.csv, and their files are in the Documents parts, under documents/_Deleted records/.
Download the Documents
Under Your Export, the Documents row says how many documents your export holds and in how many parts. Choose Download All Documents. The page downloads each part in turn and saves it as its own ZIP file, named like stonefield-eoc-documents-2026-09-30-part-07-of-45.zip. Each part holds whole students, in last-name order, so a student's files are never split across two parts (unless one student's files are larger than a part).
- Keep the page open until every part is saved. A large program can take several hours. Downloads run faster after 11 PM Eastern Time and on weekends, because TRIOPilot downloads fewer files at once during the working day.
- Your browser may ask whether to allow the page to download several files. Choose Allow. If your institution's browser settings block several downloads, use the Download Part button beside each part instead. Each one names its part, for example Download Part 7.
- If the download stops (you closed the page, or your connection dropped), come back and choose Continue Downloading (Download All Documents if no part has been saved yet). It starts at the first part not yet saved. A part that was half done starts over; a saved part is never downloaded again.
- To download one part again, choose Show Parts on a phone, then Download Part beside it. On a larger screen the parts list always shows.
Each part holds:
- documents/: one folder per student, named
Last, First (participant number). Each file is named with its upload date and its original name, for example2025-10-02 FAFSA Submission Summary.pdf. - documents/_Deleted records/: files of students your staff deleted that TRIOPilot still keeps.
- documents/_Not linked to a record/: files in your program's storage that no record names.
- _index.csv: every file in the part, with the student, the original file name, who uploaded it and when. Its Status column reads Included, Deleted record or Not linked to a record, as in
documents.csv, or Could not be downloaded for a file that is not in this part (it is also in_missing-files.csv). - _missing-files.csv: only when a file could not be downloaded. It names each one and why. The page also says how many files are missing. Download the part again to try them once more.
- README.txt: which part this is, the students it covers, and how to open it.
Opening a part on Windows. Extract it into a short folder, such as C:\Export, so no file path passes Windows' length limit. If Windows cannot extract a file, use 7-Zip. On a Mac, double-click the ZIP file.
Checking a part. To check that a part saved whole before you rely on it, test the ZIP file: in 7-Zip, select it and choose Test; on a Mac, open Terminal and run unzip -t followed by the file's name. Every file should read OK. If a test fails, download that part again with its Download Part button.
Download limit. Each export can download its documents about one and a half times over, which leaves room to download a part again. After that the page says the export reached its download limit; start a new export to download again. Once a download has started, the Documents section shows how much is left, for example 1.2 GB of downloads left for this export, and warns you when that is less than the parts not yet saved.
Save Everything to a Folder
On a computer with Chrome or Microsoft Edge, the Save to a Folder row under Your Export saves Program Records and every document straight into a folder you choose, as separate files. There are no ZIP files to extract, and a stopped save picks up file by file. Other browsers (Safari, Firefox) and phones do not offer it; use the ZIP buttons above.
- Choose Save to a Folder.
- Make a new folder for the export, for example inside Documents, and pick it. Your browser does not allow some folders themselves, such as Documents or Desktop, so pick a folder inside them. Your browser then asks whether TRIOPilot may save files there; allow it.
- Keep the page open. The row shows the part it is saving, how many files of that part are done and how much has been saved.
TRIOPilot makes one folder for the export inside the folder you pick, named like stonefield-eoc-export-2026-09-30. It holds:
- The Program Records folder, named like
stonefield-eoc-program-records-2026-09-30: the same files as the Program Records ZIP file. - One folder per part, named like
stonefield-eoc-documents-2026-09-30-part-07-of-45: the same files as that part's ZIP file, with the samedocuments/folders,_index.csv,README.txtand, when a file could not be saved,_missing-files.csv. - _manifest.json: every file saved, with its size and a CRC-32 checksum, so you or your IT staff can check the copy later.
The folder holds exactly what the ZIP files hold once you extract each one into a folder named after it, so you can use either.
If the save stops (you closed the page, the computer slept, or the connection dropped), choose Save to a Folder again and pick the same folder, either the folder you picked before or the export folder inside it. TRIOPilot checks each file already there: a file at its full size (and its recorded checksum) is kept and not downloaded again, and a file that was only partly written is saved again. Program Records are kept when they are already complete.
When the save ends, the row says how many files are in the folder, their total size and how many were already there. If any file did not save, the row lists it with the reason, and Try the Missing Files Again tries only those files, in the same folder. The Download limit above applies: files already in the folder are not downloaded again, so they do not use it.
What is not included. Sign-in details and connection secrets (for texting and Outlook calendars), TRIOPilot's internal notes about your account, the AI assistant's diagnostic trace, and TRIOPilot's own platform settings. README.txt lists each one with its reason.
Seven Days, and the Limits
- An export stays available for 7 days. After that, start a new export.
- Only the person who started an export can download it. Another admin sees who started it, and can choose Cancel This Export and start their own.
- If you come back more than 24 hours after your last code, the page asks you to confirm it's you again: choose Email Me a Code, type the new code under Code, and choose Confirm.
- Your program can have one export available at a time, and admins can start at most 2 exports in 30 days. If you need another, email support@triopilot.com.
Keep the Files Safe
These files hold every student's education records. Save them only to a device your institution manages, and delete them when you no longer need them. TRIOPilot cannot see or delete a copy once it is on your device.
What the One-Year Spreadsheet Is Still For
The Download Current Program Year (CSV) button on the same card is a quick spreadsheet with one row per student in the current program year. Its built-in outcome columns (HS Diploma / GED Received to Institution Type) appear only where your program's APR uses them: all six on EOC programs, Institution Type on Talent Search programs, and none on the other program types. Limited English Proficiency appears on EOC, Talent Search, Upward Bound and UBMS programs, and Military Connected and Age at First Service on EOC and Talent Search programs. Use it for everyday lists. Use Export All Program Data when you need everything.
Good to Know
- Every step is in the Audit Log tab in Settings, under the Reports category: Started a Full Data Export, Confirmed an Export Download (a new code after 24 hours), Read Program Records (TRIOPilot records this itself each time the records are read), Downloaded Program Records (the page saved the file), Read Document Files (TRIOPilot records this itself when it starts making download links for a part's files, again every 15 minutes while it keeps making them, and when the part ends: when it reaches the end of the part, when the page reports the part saved or failed, or when the export is cancelled. Each entry has the part and how many files it made links for since the last such entry. If the page closes before then, TRIOPilot adds the entry, usually within an hour and at the latest overnight), Downloaded Documents (the page saved a part, with how many files are missing; a part saved into a folder reads Saved to a folder, and so does Downloaded Program Records), Document Download Failed, Cancelled a Full Data Export, Export Code Locked (five wrong codes, recorded once when the code locks) and Full Data Export Failed. See See Who Changed What.
- The document list is fixed when the export starts. The records are read when you download them, so a record changed in between shows its newer value. README.txt gives both times.
- If the export says it could not be prepared, or a part could not be saved, the problem has been recorded and our team will look into it. You can start a new export, or try the part again: choose Continue Downloading (Download All Documents if no part has been saved yet), or, when every other part is already saved, that part's own Download Part button.
- Phones can download the parts too. Each part saves as an ordinary download.