How To Download All Forms

[Leana_Zhao]

I would like to download all the forms we currently have in Marketo, how can I do that? There's an 'Export to Excel' button on Design Studio -> Landing Pages, but i can't find it on Forms.

[SanfordWhiteman]

You have to use the REST Asset API to do this (see Developer site).

[Jep_Castelein2]

Agree with Sanford. But what are you going to do with the Forms after downloading? There is no standardized format that you could import them into FormAssembly or some other form tool. Or do you just need a listing of Forms in an Excel sheet, not the actual Form fields?

[Leana_Zhao]

Yes, a list of form in excel, same thing as what i can download for landing page.

[SanfordWhiteman]

If you really need an Excel-compatible export from the top-level Forms node, open your browser console (F12 > Console)  and type this JS:

Array.from(document.querySelectorAll('.x-grid3-row-table tr'))
.map(function(row){
  return Array.from(row.querySelectorAll('td'))
    .map(function(col){
      return col.textContent;
    })
    .join("\t");
})
.join("\n");

That'll give you tab-delimited output you can copy and paste into Excel. You'll have do this once per page of forms (if you have more than a couple of pages, you're probably doing something wrong!).  Also, this code will definitely have to be rewritten after the Marketo UI upgrade, so get it while it's hot...