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

Open

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

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.

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

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.

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.