CSV Format with Comma as Delimiter
StarMeUp uses CSV (Comma Separated Values) files and the data must follow certain formatting guidelines:
Use a comma as a data separator.
Enclose the data in double quotes as a data delimiter.
Use line breaks to separate rows.
Save the file with UTF-8 encoding.
Configuring Regional Settings for CSV
To ensure correct CSV formatting, configure regional settings as follows:
Go to Control Panel.
Access the “Region and language” settings.
In the "Formats" tab, select "Additional settings".
In the "Numbers" tab, set the following:
Decimal symbol: .
List separator: ,
Save your changes by selecting OK.
Saving Files in CSV Format
To save files in CSV format, follow these steps:
Create a file in Microsoft Excel.
Click "Save As."
Select "CSV (comma delimited)" from the list of file types.
Click Save.
If you open the CSV file using Notepad, you will see the columns separated by commas.
Using Double Quotes for Special Characters in CSV
If the CSV file contains cells with special characters (for example, "," "/" ";" or numbers), enclose the cell data in double quotes to ensure successful import. To automatically enclose data in double quotes, set the cell format to Text in Excel:
Go to "Format Cells."
Select "Text."
Click OK.
Save the file as CSV again.
When you reopen the CSV file in Notepad, you will notice that the columns are separated by commas and that each cell data in Excel is enclosed in double quotes.
Encoding Consideration Before Importing to StarMeUp
Make sure you have the correct encoding before importing the file into StarMeUp. UTF-8 encoding is the preferred option. By default, Windows uses ANSI encoding. To change the encoding to UTF-8:
Open the file you want to import using Notepad.
Click "Save As."
Choose Encoding = UTF-8.
Click Save.
A proper CSV format and correct encoding ensure a smooth and accurate import of users and their leadership relationships into StarMeUp.