# CSV Import Guide

### 1. Copy our Google Spreadsheet

Make a copy of our [Google Spreadsheet](https://docs.google.com/spreadsheets/d/1jUtwBarNf_VUifHL6bJj7-96quL2HuY_PL6_gNE2Wa4/copy) to ensure your laws are formatted correctly for CSV import.

{% hint style="danger" %}
**Do not change the document name.** When downloaded as a `.csv`, ImperialCAD verifies specific values from the original template to process the upload.
{% endhint %}

<figure><img src="/files/vtXdTWjQ7rLJN2s29EHh" alt="" width="563"><figcaption><p>Laws - Copy</p></figcaption></figure>

***

### 2. Enter Your Laws

You may now begin entering your laws into the spreadsheet:

* Add new rows for each law you want imported.
* Do **not** modify the header row (Row 1), as these values are required for proper import.
* Fill in each column as needed, including section, violation, fine amount, license points, and classification (Infraction, Misdemeanor, Felony).

<figure><img src="/files/qt9iOPgFlzzDUEsIoP5x" alt=""><figcaption></figcaption></figure>

***

### 3. Download as CSV

When finished, download your file:

* In Google Sheets, go to **File > Download > Comma Separated Values (.csv)**.

{% hint style="success" %}
Before downloading, **remove any unused rows** at the bottom of your sheet. Extra blank rows may cause errors during import.
{% endhint %}

<figure><img src="/files/yVrVB3etzzdLZO49QY35" alt="" width="504"><figcaption></figcaption></figure>

### 4. Import your CSV File

Log into your ImperialCAD Admin Panel and navigate to:\
**Configuration > Laws > Import CSV**

\
From there, upload your `.csv` file to import your laws.

<figure><img src="/files/ym1hZ3aFozsfvaUa9SYw" alt=""><figcaption></figcaption></figure>

***

### 5. Done! 🎉

Once uploaded, your laws will automatically be stored in your community’s database and ready to use inside ImperialCAD.

***

### Having Issues?

If you experience problems:

* First, verify you used our official [Google Spreadsheet](https://docs.google.com/spreadsheets/u/1/d/1tUyc65fGp0fn4i4GkeqPO_sy5c2-bSkWLkMODxfJPUA/copy) template.
* If issues persist, join our Discord and open a support ticket. Our team will be happy to assist you.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.imperialcad.app/general/administration/csv-import-guide.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
