Articles on: ggLeap

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

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

Set Up Required Data

Enter Username and EmailAddress for each entry.
These must not be left blank.

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.

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:

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

Updated on: 17/12/2025

Was this article helpful?

Thank you!