GlobalReader Analytics environment offers an option to export the reports either in CSV or XSLS format. On this page, we will share tips&tricks on how to see report data correctly in the exported files and what kind of system settings you need to review/set for yourself within GlobalReader.
Define your CSV exporting preferences in Analytics
On your **Analytics My Profile** page you can set your CSV exporting preferences for separator and encoding language. Path: Click on Your Name → Make changes on Settings → Click on 'Save'
- Separator - can be either comma or semicolon
- Encoding - Latin1 (Windows computer) or UTF8 (Mac or Linux computer)
Define your date format preference in Passport
On your Passport My Profile page you can set your date format preference that will be the format used within every GlobalReader eco-system environment and will be the format for the date in report exports. Path: Click on My profile → Choose a date format → Click on 'Save'
- Format selection - dd.mm.yyyy; mm.dd.yyyy or yyyy.mm.dd
What are CSV and XSLS formats?
- CSV is a format for saving tabular information into a delimited text file with extension .csv whereas Excel is a spreadsheet that keeps files into its own proprietary format viz xls or xlsx.
- CSV is a plain text format with a series of values separated by commas whereas Excel is a binary file that holds information about all the worksheets in a workbook.
- CSV file can’t perform operations on data while Excel can perform operations on the data.
- CSV files are faster and also consumes less memory whereas Excel consumes more memory while importing data.
- CSV files can be opened with any text editor in windows while Excel files can't be opened with text editors.
How to open CSV file in excel?
If CSV file opens in excel as series information and not in tabular format, then this probably means that the separator choice is incorrect and needs to be changed on your Settings in Analytics.
- Separator update makes the export file open as expected