Connect VoiceQ Cloud to Microsoft Excel with Office Scripts to pull character data or full script data — lines, rates, pay, timecodes, recorded/adapted/QC status — straight into a spreadsheet. This guide covers the three workflows: character export with a token, character export with your login, and script export. Updated October 2025.
What you'll need
- A Microsoft 365 account with access to Excel Online (the Automate tab)
- A VoiceQ Cloud account and an active project or group
- The export script for your chosen workflow — both are linked in the full user guide (button below), with raw code in its appendices
Start by creating a blank spreadsheet in Excel, then download the script you need: Auth-Characters-export.osts for character/group data, or Excel_Script.osts for script data.
Workflow 1 — Character data with a token
- Open your VoiceQ Cloud project and copy the Project ID from the end of the URL (app.voiceqcloud.com/app/#/projects/YOUR_PROJECT_ID). Paste it into Cell A1.
- Click Get Token (above the Characters section), press Copy Token, and paste it into Cell A2.
- In Excel, open the Automate tab, select New Script, and import Auth-Characters-export.osts into the Code Editor. If there's no import option, create a new script first, then paste the code in.
- Select Run to test — character data imports with columns for name, actor, lines (50*/65*), rates, calculated pay, completion date and more. You can also add a button to the sheet to run the script with one push.
Group exports: the same script enables the Project ID and Project Name columns. Characters appearing in multiple episodes are listed per project, e.g. 'JOHN SMITH, UUID, PROJECT ID, PROJECT NAME'.
Workflow 2 — Character data with your login
To skip the 48-hour token cycle, you can authenticate with your account instead: follow the steps above, but enter your VoiceQ Cloud username in Cell B1 and password in Cell C1 (Cell A2 can stay empty — the script signs in directly).
A word of caution: this stores your credentials in plain text in the spreadsheet. Only use it if you're confident the document is saved and shared securely — for anything shared beyond yourself, the token workflow is the safer choice.
Workflow 3 — Script data
- Paste the Project ID into Cell A1.
- Click Get Token — the dialog offers two values. Copy Token into Cell A2 and Copy User ID into Cell A3.
- In Cell A4, enter the language code to pull — e.g. 'EN-US' for English (United States) or 'ES' for Spanish.
- Import Excel_Script.osts via Automate > New Script, then select Run.
The export includes scene, character, actor, timecodes in/out, duration, script text, cue number, and status flags (recorded, adapted, QC, pick-up, V/O, use OV) with their timestamps — plus comments, on-screen notes and event types. The username/password option in B1/C1 works here too, with the same security caveat.
Token expiry
Tokens expire after 48 hours or when you log out of VoiceQ Cloud. When that happens, click Get Token again and paste the fresh token into Cell A2 (and User ID into A3 for script exports). For a different project, update the Project ID in A1 — the script itself doesn't change.
Troubleshooting
The script runs but nothing imports
- Check A1 holds only the Project ID and A2 the full token — stray spaces are the usual culprit. For script exports, also confirm the language code in A4 matches a language that exists in the project; a non-matching code returns no rows.
It worked before but now fails
- Your token has expired (48 hours, or you logged out of VoiceQ Cloud). Generate a fresh one and update A2.
Authentication failed using username and password
- Check the credentials in B1/C1 are exactly your VoiceQ Cloud login. Note that accounts with MFA enabled may need the token workflow instead.
There's no option to import a script in the Automate tab
- Create a new blank script first, then paste the code from the .osts file (or the guide's appendix) into the Code Editor and save.
Still stuck? Download the full user guide below for screenshots of every step and the complete script code, or contact support and we'll help you get connected.