---
sourceDocument: Yokohama Governance, Risk, and Compliance
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/governance-risk-compliance

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Governance, Risk, and Compliance

ft:clusterId :

    - grc

bundleId :

    - grc

workflow :

    - Technology


---

# Guidelines for importing spreadsheet data

# Guidelines for importing spreadsheet data {#ariaid-title1}

* Release version: Yokohama
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Before you try to import the questionnaire data from a Microsoft Excel spreadsheet into Third-party Risk Management tables, you must verify that its format meets particular guidelines.

## Property settings that affect spreadsheet data {#excel-formatting-guidelines__section_lsf_x1f_zyb}

You can specify the following property settings:

Text delimiter in spreadsheets \[`sn_vdr_risk_asmt.excel_choice_delimiter`\]

:   Character string that separates response text in questions of type 'Choice' and 'Multiple Selection'.

    Common delimiters: \\r, \\n, \\t, \\r\\n, and the comma character.

Maximum spreadsheet file size \[`sn_vdr_risk_asmt.excel_file_max_size`\]
:   Maximum file size in MB that can be imported.

See [Configure TPRM properties](https://servicenow-prod.fluidtopics.net/pZaXWFHutN0JCkNdKbavkg "Configure property settings for a variety of TPRM operations.").

## Supported columns {#excel-formatting-guidelines__section_m3y_x1s_kxb}

Required columns are marked with \*. Column headings must appear in the first row of the spreadsheet.

* Serial number \*
* Category \*
* Question \*
* Order \*
* Data type \*
* Description
* Scored
* Correct answer
* Scale definition
* Depends on
* Displayed when
* Min
* Max
* Weight
* Mandatory
* Allow additional information
* Allow not applicable
* All other columns of the Assessment Metric \[asmt_metric\] table
{#excel-formatting-guidelines__ul_xtw_gmn_kkb}

## Supported question types {#excel-formatting-guidelines__section_xzg_fbs_kxb}

* Check box
* Yes/No
* Choice
* Attachment
* Date
* Date/Time
* Percentage
* String
* Multiple Selection
* Number
* Numeric Scale
{#excel-formatting-guidelines__ul_u4y_vmn_kkb}

## Supported Excel formats {#excel-formatting-guidelines__section_czz_gbs_kxb}

Requirements:

* Each file can have only one worksheet.
* You can separate multiple choices in a cell with line breaks (Alt/Option + Enter). Other options are available in System Properties.
{#excel-formatting-guidelines__ul_js2_vjq_lkb}

* .xlsx
* .xls
* .xlm
* .xltx
* .xlt
* .xlw
* .xlsb
* .csv

{#excel-formatting-guidelines__ul_jsk_bnn_kkb}  
Note:  
You can review the formatting requirements and view or download a sample spreadsheet to use as an example. Referencing a sample file can help you ensure that you are using values in the expected format.  

<br />

**Related tasks**   

* [Import a questionnaire from a spreadsheet](https://servicenow-prod.fluidtopics.net/BRa4BwNMtt5GhtmWDEjuxg "If you maintain questionnaires using Microsoft Excel spreadsheets, you can save time and effort by importing your spreadsheet data directly into TPRM tables. You can then create questionnaires automatically from templates.")
* [Configure TPRM properties](https://servicenow-prod.fluidtopics.net/pZaXWFHutN0JCkNdKbavkg "Configure property settings for a variety of TPRM operations.")