Import Cues From Excel File
CueDB can import cues from Excel by mapping the column headers of the Excel file with the table headers in CueDB.
In Excel
Make sure that a header named "Cue #" exists in the Excel file, since that is the primary key that is being used to create new cues and to update existing cues.
In CueDB
If your project uses a frame rate, make sure your CueDB project's frame rate matches that of your Excel timecodes. You can check and adjust this in CueDB under "Project Settings > General".
Click on "Tools > Import Cues" in CueDB.
Choose "Excel".
Choose how you would like to map Cue #.
- Choose your file and click on "Preview".
- To exclude specific cues from the import, simply uncheck them. If you prefer not to include titles, uncheck the "Title" checkbox.
Click "Import" if everything looks correct.
CueDB automatically maps standard column headers from your Excel file to corresponding columns in CueDB. However, it doesn't map custom fields.
If a cue with the same Cue # already exists in your CueDB document, it will be tagged as 'UPDATE' rather than 'NEW'. This will update the timecodes and, if checked, the title of the existing cue.
It's important to note that only the timecodes and titles are updated for existing cues; no other data is modified.
You can also use the Excel import to import data from a Google Sheet by clicking on "File > Download > Microsoft Excel (.xlsx)"
