• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Discuss: Export text from titles and Mogrts as CSV or Text file

Adobe Employee ,
Jun 10, 2022 Jun 10, 2022

Copy link to clipboard

Copied

With this feature we are adding support to export all text of titles and graphics within a sequence as a CSV or as a text file.

We are curious to hear if this is a helpful little addition, how you will be using this feature and what's more helpful to you, CSV or Text. 

 

While the Captions and Transcript tabs in the Text panel already supported this in previous versions, we are now adding this for the Graphics tab so you can export your text used within titles, Premiere and After Effects Mogrts. 

This can be handy for quality control of text in a sequence or for handoff to translation. 

 

How does it work?

  1. Make sure your sequence is open in the Timeline panel
  2. Open the Text panel and switch to the Graphics tab
  3. In the overflow menu click on Export to text file... or Export to CSV file

TinyTake10-06-2022-01-02-37.png

 

Here is an example of a sequence with one Premiere graphic, one After Effects graphic with the Essential Graphics panel and the Text panel open. 

TinyTake10-06-2022-01-00-51.png

 

 

This is what a CSV for that sequence would look like: 

AnnikaKoenig_1-1654886925900.png

 

 

The .csv file will contain five columns ordered by time: 

  • Start Time (e.g. 00:00:04:29) 
  • End Time (e.g. 00:00:05:23) 
  • Text (The actual text you added to your Premiere or After Effects graphic) 
  • Video Track (e.g. 1, the video track on which the track item is on) 
  • Layer ID (e.g. 1, For Premiere graphics this will index the layers in the order shown in the Essential Graphics panel layer stack, for After Effects graphics (Ae Mogrts) it will show you the Source Text label, which is whatever the author in After Effects edited it to be) 

 

This is what a text file for that sequence would like: 

AnnikaKoenig_2-1654886925901.png

 

 

The .txt file will give you a block for each graphic ordered by time with these three rows per text layer/source text: 

  • Start Time to End Time (e.g. 00;00;00;00 - 00;00;04;29) 
  • Video Track, Layer ID (e.g. V3, Main Title) 
  • The text of the graphic 

 

Note: We have made minor changes to the Captions and Transcript export to CSV to align better with the export for graphics. We have 1. Moved multiple blocks of caption segments on its own row in the CSV and have renamed the Transcript column to Text. 

 

 

 

TOPICS
Feature request , Feedback

Views

2.4K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 10, 2022 Jun 10, 2022

Copy link to clipboard

Copied

Annika,

 

While this is very useful ... getting the "return trip" accepted would be even more useful ... being able to import the text.

 

Neil

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 21, 2022 Jul 21, 2022

Copy link to clipboard

Copied

+1 for that. I fully agree with Neil!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 13, 2022 Jun 13, 2022

Copy link to clipboard

Copied

Note: the new export options are available as of Beta 22.6 Build 13.


Annika,

 

This is a good addition. The csv is VERY useful. For example, users asked for timecode in the .txt export from captions and transcript. When it was added, all the users who did NOT want timecode had a problem. But it was easy to get the text only from the csv. Users have diverse workflows, and at least two exports are desireable: one that is ready to use for a novice (.txt) and one that is very flexible for users with the skills to reformat and output as they need (.csv).


As Neil suggests, the roadmap forward needs to include more. And the types and details of exports can help or hinder use of the main caption workflow.


Captioning/subtiling, closed or otherwise, is complicated, comes in an extraordinary variety of formats, and will probably always require users to have third party tools. PR should have very flexible import and export options that recognize this. For example, my belief at this moment is that the .srt sidecar export, even with "styling" selected will only include font color. (I last tested for 4 style elements: Font color, Font family, Caption Position, and Background - yes/no and color.) That was not so bad when you could export .stl from a Subtitle stream, but that was removed. Really? Tell me I'm missing something. Closed caption exports carry more style, but they are, of course, severely limited on styles.


Caption Blocks are complicated, and I think need attention going forward. How they are set up in exports is important.


With no blocks, the current and revised Caption .csv are the same, except for the renaming of the "transcription" column to "text" (which I agree is logical).


With blocks, in the current method, for srt and txt, the block texts are simple multiple lines in a single segment. For those formats, we have no way of knowing whether these are blocks or just multiline captions. For .csv, a vertical line character (space, vertical line, space) is used to separate one block from another within the same segment.


In the new method, each block is a separate line in the .csv, and the only indication that there are blocks is that the timecode repeats. Note that in the old and new exports, for .csv, unlike .srt and .txt, caption number is omitted. As long as there is only one segment (i.e. one occurence of that timecode), it is not a big problem to generate the number. But when there are blocks and the timecode now repeats, it becomes a problem. In the new Graphics Text exports, there are assignments that identify them (Video Track and Layer ID). Something like that is needed for caption blocks.


This points to the "big picture" problem with blocks; I think they are only partially implemented. And they are still undocumented in the user guide. A major use of blocks would be to differentiate speakers, which cries out for: 1) having an OPTION to use speaker information from the transcript in the captions, 2) identifying different sub-streams of blocks per speaker and providing methods for working with the streams, and 3) including as one of those methods different Caption Styles per speaker. Currently, 1) speaker designation is limited to the transcript, 2) you must edit blocks one by one, and 3) if a style is applied AFTER changing style in individual or multiple blocks, it will override any differences.


A frequent topic of conversation on the release forum is how to convert captions to graphic text and, less often, vice versa. Because the captions/transcript are coded in hashed hex, a third party is unlikely to create a tool to do this. Third parties do provide options once the text is accessible. For example, you can convert .srt to .xml that will import to PR as graphics text, such as Subtitle2xml by ‪Bas Tempelman‬:
https://www.microsoft.com/en-us/p/subtitle2xml/9n78158bn7xm?activetab=pivot:overviewtab


PR should have an option for converting captions to graphic text and, while potentially more complicated, graphics text to captions.


The other big picture issue is users who want to export the captions, edit outside PR (because the editors are not PR users and PR is not an efficient text editing program), and then reimport the edited transcript of captions without losing or breaking timecode. Some users want to do that with transcripts. Either process is complicated by timecode issues. As you say, "This can be handy for quality control of text in a sequence or for handoff to translation." But those purposes are very limited if you cannot reimport with changes.

 

Stan

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 13, 2022 Jun 13, 2022

Copy link to clipboard

Copied

Awesome post there Stan!

 

Annika & Team ... what he said! Every single bit of it.

 

With all the other apps working to get better captions/subtitling, this is a big area for working towards the future ...

 

 

Neil

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jun 22, 2022 Jun 22, 2022

Copy link to clipboard

Copied

Thanks for your feedback, Stan. We added an additional column to the captions CSV to identify blocks. It has the same header as in the graphics CSV (Layer ID). You can test this in a Premiere beta build 22.6x24 or later.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 23, 2022 Jun 23, 2022

Copy link to clipboard

Copied

Annika,

 

Thanks! Yes, that is great.

 

More later on.....

 

Stan

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 11, 2022 Jul 11, 2022

Copy link to clipboard

Copied

This is a very useful feature but I don't see the option to "import" a CSV file of text once I made changes to it. Being able to batch edit text with a spreadsheet can save tons of time.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 12, 2022 Jul 12, 2022

Copy link to clipboard

Copied

> I don't see the option to "import" a CSV file of text once I made changes to it.

 

Yes, that would be a useful addition to my comments about round tripping.

 

Stan

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 28, 2023 Nov 28, 2023

Copy link to clipboard

Copied

LATEST

Hello sir, I gave the customer the transcript .CSV file to correct for the subtitles. 
Did you find a way to import .CSV into Premiere? 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Nov 03, 2022 Nov 03, 2022

Copy link to clipboard

Copied

You need to be able to import raw txt files into Premiere, and then have Premiere slice and dice and set the time codes. This is necessary for everyone who works with a teleprompter, where the text that is used is already in digital form. Using the auto-transcription process is very labor intensive since there are so many mistakes that then have to be corrected manually. If the original text file was used, there would be no mistakes at all, and the transcription process would be very quick and easy.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 08, 2022 Dec 08, 2022

Copy link to clipboard

Copied

I have a need to export title text and text box text as VTT for a distribution platform I am working with.  It is to meet accessibility requirements so this feature would be great. Otherwise I have to pretend they are captions and use a caption tool and enter that same text again.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources