> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://helpdesk.ggcircuit.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 🧙‍♂️ Importing Users to ggLeap (Spreadsheet Method) ✨

This guide will walk you through how to prepare your data, ensure accurate formatting, and use the CSV template for a smooth import process. If anything is unclear or you need extra help, don’t hesitate to reach out to the [**ggCircuit Support Team**](mailto:support@ggcircuit.com).

---

---

## ✏️ Getting Started

🔒 **View Only Mode**  
The original file is in “View Only” mode. To start editing:

> Click the “Enable Editing” button in the ribbon bar.  
> This will allow you to make changes in your own copy of the spreadsheet.

---

## ✏️ Important Note: Protected Sheets & Cells

Some cells are protected to prevent accidental changes to formulas. If you attempt to edit them you will need to “Enable Editing” on the document in the ribbon bar.

* ✅ If you're comfortable with Excel: Click “OK” to proceed.
* ⚠️ If you're not familiar with formulas: Avoid editing protected fields to prevent errors in spreadsheet behavior.

---

## ✏️ CSV Template Field Requirements

### ✅ Required Fields

| Field | Description | Example |
| ---- |
| `Username` | A unique identifier for the user | `john_doe23` |
| `EmailAddress` | Must be a valid email address | `user@example.com` |

### 🟡 Optional Fields

| Field | Description | Example |
| ---- |
| `FirstName` / `LastName` | User's name (can be left blank) | `John` / `Smith` |
| `Playtime` | Time in seconds to be credited | `3600` |
| `Phone` | Contact number (optional) – 4–20 characters | `+1 800-555-1234` |
| `CreatedAt` | Account creation date in `MM.DD.YYYY` format | `01.01.2025` |
| `Balance` | Numeric balance (whole number or decimal with dot as separator) | `10`, `1500.45` |
| `Birthdate` | User’s birthdate in `MM.DD.YYYY` format | `03.26.2025` |

🔍 *You can find an example of the full template in the "Senet Sheet".*

---

## ✏️ Prepare Your CSV Template

1. **Set Up Required Data**

* Enter `Username` and `EmailAddress` for each entry.
* These must not be left blank.
2. **Fill in Optional Fields (if needed)**

* Add data such as `Playtime`, `Phone`, or `Birthdate` as needed.
* Optional fields can be left blank without causing errors.
3. **Follow Data Format Rules**

* ✅ `Username`: Only use letters, numbers, underscores (`_`), and dots (`.`).
* ✅ `EmailAddress`: Must follow standard format like `example@mail.com`.
* ✅ `PlaytimeStartDate` / `PlaytimeEndDate`: If used, must follow `MM.DD.YYYY` and only if `Playtime` is defined.
* ✅ `Birthdate` and `CreatedAt`: Use the `MM.DD.YYYY` format.
* ✅ `Balance`: Must use a period (`.`) for decimals (e.g., `10.75`).
* ✅ `Phone`: Can include digits, spaces, `+`, `-`, `x` (e.g., `+1 800-555-1234`), and should be between 4–20 characters.

---

## ✏️ Exporting the File

When you're done filling in your data:

1. Go to `File > Save As > CSV UTF-8 (Comma delimited) (*.csv)`
2. This will generate a properly formatted CSV file for import.

---