# Importing via CSV Template

PlexTrac provides a downloadable CSV file that can be used as a template for entering writeups offline and importing them into **WriteupsDB**.&#x20;

## Downloading the CSV Template

<mark style="background-color:yellow;">Step 1:</mark> From the **WriteupsDB** module, click the **Writeups** tab.

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2Fc9qSCNSw5hxkUPQyXWlx%2Fimage.png?alt=media&#x26;token=644f35f3-dd78-4542-8e65-86b9c10754da" alt="" width="563"><figcaption></figcaption></figure></div>

<mark style="background-color:yellow;">Step 2:</mark> Click **Import Writeups**.

<figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FLx15VXiyOBgNC8Eel05h%2Fimage.png?alt=media&#x26;token=60b80ab1-15b5-45e3-8a44-02dfb1398eed" alt=""><figcaption></figcaption></figure>

<mark style="background-color:yellow;">Step 3:</mark> Click **Download CSV template file**.

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FO1KlG7DhoM00wryMw5en%2Fimage.png?alt=media&#x26;token=9fa36a17-78b8-4e5b-ac8b-eafab3969577" alt="" width="563"><figcaption></figcaption></figure></div>

The file will be downloaded locally for editing.

{% hint style="warning" %}
Save the CSV template in UTF-8 format to prevent including non-UTF characters that may break the importer.
{% endhint %}

## Writeups CSV Field Mappings

When importing the CSV file, all fields below must appear as column headers and follow the rules defined in the table. Otherwise, the file may be rejected when imported or require further manual editing within PlexTrac.

{% hint style="warning" %}
**Title**, **description**, and **severity** are required.&#x20;
{% endhint %}

<table><thead><tr><th width="202">PlexTrac Field</th><th>CSV Header Label</th><th>Notes</th></tr></thead><tbody><tr><td>title</td><td>title</td><td>This is a required field.</td></tr><tr><td>severity</td><td>severity</td><td>This is a required field.<br><br>The severity value must be one of the following (not case-sensitive): <br>"Informational, Low, Medium, High, Critical"<br><br>If no value is provided in CSV, a value of "Informational" will be assigned.</td></tr><tr><td>description</td><td>description</td><td>This is a required field.</td></tr><tr><td>recommendations</td><td>recommendations</td><td>These are the writeup recommendations.</td></tr><tr><td>references</td><td>references</td><td><p>This field accepts multiple values delimited with a comma.<br></p><p>For example: "Item 1, Item 2, Item 3"<br><br>NOTE: Do not use commas if providing complete sentences, as any comma will result in a para break. Periods do not trigger a para break.</p></td></tr><tr><td>tags</td><td>tags</td><td><p>This field accepts multiple values delimited with a comma.<br></p><p>For example: "Item 1, Item 2, Item 3"</p></td></tr><tr><td></td><td>custom field</td><td>The headers will be converted to keys and labels in the writeup after import.<br><br>As many custom fields can be used as desired. For example, "custom field 1," "custom field 2," etc.</td></tr><tr><td></td><td>score::cvss3</td><td>The value before the double colon is the score; the value after is the vector string (calculation), if provided.<br><br>For example: "9.8::CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"</td></tr><tr><td></td><td>score::cvss</td><td>For example: "9.5"</td></tr><tr><td></td><td>score::YourLabel</td><td>Replace "YourLabel" with the Label of a custom scoring system.<br><br>The value before the double colon is the score; the value after is the vector string (calculation), if provided.<br><br>For example: "1000::a+b+c+d"</td></tr><tr><td></td><td>cves</td><td>Separate values with a column. For example: "CVE-1999-0001, CVE-2000-0001"</td></tr><tr><td></td><td>cwes</td><td>Separate values with a column. For example: "CWE-787, CWE-79, CWE-89"</td></tr><tr><td></td><td>score::cvss3.1</td><td>The value before the double colon is the score; the value after is the vector string (calculation), if provided.<br><br>For example: "3.7::AV:A/AC:H/PR:H/UI:R/S:C/C:N/I:L/A:L"</td></tr><tr><td></td><td>score::cvss4</td><td>The value before the double colon is the score; the value after is the vector string (calculation), if provided.<br><br>For example: "5.7::AV:L/AC:H/AT:P/PR:L/UI:A/VC:N/VI:L/VA:H/SC:H/SI:L/SA:N"</td></tr></tbody></table>

## Importing the CSV Template

<mark style="background-color:yellow;">Step 1:</mark> From the **WriteupsDB** module, click the **Writeups** tab.

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FZXsW1sPasUQKsVG7YLGq%2Fimage.png?alt=media&#x26;token=2da59503-2e78-4a7a-92d0-65a92ce03216" alt="" width="563"><figcaption></figcaption></figure></div>

<mark style="background-color:yellow;">Step 2:</mark> Click **Import Writeups**.

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FnF9XDkMnBxO5iYdVuhLP%2Fimage.png?alt=media&#x26;token=6e4b5b38-99d2-470a-8fe4-66459bec4692" alt="" width="563"><figcaption></figcaption></figure></div>

<mark style="background-color:yellow;">Step 3:</mark> Drag the file into the designated box or navigate to the file on the computer.&#x20;

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FQTvSCM3kKmt3E9YxZHHm%2Fimage.png?alt=media&#x26;token=3cfb0b9e-306d-4566-b2da-f10950cb15d3" alt="" width="563"><figcaption></figcaption></figure></div>

<mark style="background-color:yellow;">Step 4</mark>: Click **Upload**.&#x20;

<div align="left"><figure><img src="https://4252973360-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LXA6EayCcg12qfDcfXd%2Fuploads%2FwXQzQCbH2pcDlOHhwuVh%2Fimage.png?alt=media&#x26;token=d79d05c6-21ed-451c-8f03-0aad4699738c" alt=""><figcaption></figcaption></figure></div>

When completed, the imported writeups will be displayed within the selected repository.
