Re: How To Download All Forms

Leana_Zhao
Level 1

How To Download All Forms

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.

Tags (2)
4 REPLIES 4
SanfordWhiteman
Level 10 - Community Moderator

Re: How To Download All Forms

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

Jep_Castelein2
Level 10

Re: How To Download All Forms

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
Level 1

Re: How To Download All Forms

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

SanfordWhiteman
Level 10 - Community Moderator

Re: How To Download All Forms

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...