: > Enabling global identity GLEI F Protecting digital trust CSV | t Guid FINAL V1.1 2018-03-01 This short guide demonstrates how to prepare and open a CSV data file using a spreadsheet application such as Excel. It does not cover all possible ways to open files. It is intended to draw attention to problems that can be avoided when working with data files in this format. Public Version 1.1 2018-03-01
Please note: GLEIF does not provide tool support, so we are not able to give detailed advice on your organization’s particular systems or workflows. The examples here are for illustration and you may need to adapt to your local operating system and / or application. We recommend consulting your IT team for any complex tasks. 1 Download file First download the file from the GLEIF.org website. Right-click on the file and select “Save As...” to save the file locally (please do not open it yet). The data file has the filename extension “.csv”. Do not double click the data file immediately. 2 Open Excel Once the data file has been downloaded, do not directly open it. e Instead, find your spreadsheet application (e.g. Excel) and open it. e Create a new (blank) workbook: [ X X ] Microsoft Excel C g, N Total a List —
: B E Take a - o= tour . B @ Blank Workbook Welcome to Excel Make a List Total a list Track My Task [ 0] . Budget —_— et ‘ = — p— - \ 2 0 =k wlly Hule - o Dol . [ = - CSV Import Guide Page 2 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01
With some versions of Excel you may need to do this from a menu, such as: @ Excel File Edit View Insert Format Tools Data Window Help 3 Set up import Once a new workbook is open, select this option from the File menu: A dialog will now begin, guiding you through the steps of importing a file. You need to repeat the steps in sections 2 until the end, for each file you wish to use. CSV Import Guide Page 3 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01
4 Import dialog 4.1 Select file type 1. Select CSV. 2. Click Import. Import Select the type of file vou want to import: ot— t FileMaker Pro database Files created with FileMaker Pro, like .fp5 or .fp7. HTML file ‘ Hyper-text markup files from your computer. Text file Text files, which import best when separated by tabs or spa :s. Cancel | SRULCESS 4.2 Select data (file) formats The next step may be different, depending on the operating system, application, and even the version of Excel. If the application sets any of the following values correctly, please do not change them: e The data must be recognized as Delimited. e The import must start at row: 1. e The most important setting may not yet be detected: Unicode (UTF — 8) Please see the next page for an example. Make sure that all settings that offer Unicode and / or UTF — 8 are set to this value only. CSV Import Guide Page 4 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01
Do not click Finish. Instead always click Next until the final step is complete. Text Import Wizard - Step 1 of 3 If this is correct, choose Next, or choose the Data Type that best describes your data. _ Fixed width - Fields are aligned in columns with spaces between each field. Ui?-8 Preview of selected data: Preview of file /Users/minum /31520170630-gleif-concatenated-file-lei2.csv. 1 |LET,Legal Name,Other Entity Names,Transliterated Other Entity Names,legal Address First Address Line,L¢ 2 |"@37998BEFHAR09220120" , "SHIFT, a.s.","","SHIFT, AS","Moyzesova 932/6","","","" " "" "" "Bratislava-Stq 3 |"@97900BEFHORR200321 7" , "Centrdlny depozitér cennych papierov SR, a.s.”,"","CENTRALNY DEPOZITAR CENNYCH 4|"@97908BEGK@200A2331L" , "DLHOPIS, o.c.p., a.s.","","DLHOPIS, OCP, AS","Trnavské cesta 1@@","","" "" "", S |"@97903BEFSA000008472" , "VBRN s.r.0.","" ,"VBRW SRO","Hlavna ulica 1@9/62","","","","","" "" "Hrochot™," 6 |"@37998BEFSA000092563" , "Prvé stavebnd sporitelda, a. s.","","PRVA STAVEBNA SPORITELNA, A S","Bajkalskd 7 |"@37900BECX0000000644 " ,"IPT Investment a.s. investicny fond s premenlivym zdkladnym imanim" "" "JPT I 8 |"@37908BEH0RR20008743" . "LETICIA INVESTMENT, a. s."."", "LETICIA INVESTMENT, A S"."Prvosienkowvd 5"."". "" Cancel -| Finish 4.3 Set delimiters and qualifiers The CSV file contains two types of special formatting characters that tell your application where to split the text into columns and rows: e The delimiters are commas (,). e The qualifiers are double quotation marks (“). CSV Import Guide Page 5 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01
Text Import Wizard - Step 2 of 3 This screen lets you set the delimiters your data contains. Delimiters Tab Treat consecutive delimiters as one Semicolon Textqualifier | Space Other: Preview of selected data: LEI Legal Name ther Entity 7900BEFHAB20000128 [SHIFT, a.s. 7900BEFHO000008217 |Centrdlny depozitdr cennych papierov SR, a.s. 7900BEGKOA20003311 |DLHOPIS, o.c.p., a.s. 7900BE F 50000000472 s.r.o. 7900BE FS0000008569 |Prva stavebnd sporitelfa, a. s. 7900BECX0000000644 |JPT Investment a.s. investicny fond s premenlivym zdkladnym imanim 7998BEHQOAB2220743 LETICIA INVESTMENT, a. s. Cancel < Back Finish If your application detects these automatically please do not change the values; simply click Next. If any additional values (e.g. “Tab”) are selected, please de-select them. Only Comma (,) for Delimiters and double quotation marks (“) for Text qualifier are correct. 4.4 Set data (content) format The final step is to set data content formats that are used by Excel to display and in some cases, process, the data. This is essential for files containing LEls. e Set the LEl column to Text as shown in the next screenshot. e The “General” type can cause problems with some long sequences of numbers. CSV Import Guide Page 6 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01
Text Import Wizard - Step 3 of 3 This screen lets you select each column and set the Data Format. Column data format General o Text Date: MDY [ & Do not import column (Skip) Advanced... Preview of selected data: JLEI Legal Name Other Entity Namg )97900BEFHO000000120 |1t NN nepennidgy v vraidl(Centralny depozitar cennych papierov SR, a.s. neree 38y ey IDLHOPIS, o.c.p., a.s. P97900BEF50000000472 |1 ISR nepge gL LS S MPrva stavebna sporitelha, a. s. nepenn e s R IPT Investment a.s. investiény fond s premenlivym zakladnym imanim Y AR o Y EY LETICIA INVESTMENT, a. s. Cancel < Back
[}
Only click Finish when all of the steps have been checked.
Please note:
e When working with very large files, downloading, opening and manipulating the file may be interrupted sometimes due to e.g. lack of sufficient memory.
e For large files this could be impractical and a specialized tool e.g. a dedicated CSV editor or parser, is needed.
e For detailed technical assistance using your application, please consult the official application documentation. For example, detailed information on importing CSV files to Microsoft Excel can be found at:
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-
937b-339e391393ba CSV Import Guide Page 7 of 7 @ Public Version 1.1 2018-03-01_CSV_Import_Guide_V1.1 2018-03-01