Marketo Certified Expert Certification Practice Test

Which is the correct format to import a list into Marketo?

1. MS Word mail merge

2. Native Excel file

3. Comma separated values text document

4. Tab separated values text document

The correct answer is: Comma separated values text document

The correct format to import a list into Marketo is a comma-separated values (CSV) text document. CSV files are widely used for importing and exporting data because they are simple and compatible with various applications. This format allows data to be easily structured in a table format, where each row represents a record and each column represents a field. Marketo can effectively read this structure and process it to update or create new records in the platform. In contrast, while Excel files can be used in some contexts, they may involve additional complexities because they contain formatting and features that may not translate well into a database context. MS Word mail merge is not designed for data importing in the same way; it’s used for creating individualized documents rather than managing bulk data imports. Lastly, tab-separated values (TSV) documents can be utilized for data input, but CSV files are more commonly recognized and supported by Marketo, making them the preferred choice for importing lists.