🧙‍♂️ 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.

---

---

✏️ 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

🟡 Optional Fields

🔍 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.

---