FAQ Section: Data Analysis


Opening CSV files containing international language data

A user reported that responses from Greek participants looked fine in iSurvey but appeared as meaningless symbols (e.g. ΓεÏμανία) when the CSV data file was opened in Excel. I used the excellent free open-source Notepad++ to open the CSV file … Continue reading

Category Tags Data Collection, Data Analysis, News
How to open a CSV file containing foreign characters e.g. Chinese

The default Excel conversion from CSV containing non english characters doesn’t often work. This is what we suggest.  Download and install Libre Office from here http://www.libreoffice.org/ Open Libre Office and click ‘Spreadsheet’ Click Open and select your CSV file On the … Continue reading

Category Tags Data Analysis
Why do I have lots of ‘blank’ participants?

You may find that your survey gets a lot of empty participants i.e. participants that appear to have started the survey but have given no answers. This is often due to ‘robots’ and search engine spiders that are trawling the … Continue reading

Category Tags Data Collection, Data Analysis
Why do I have a lot of ‘non-finisher’ participants?

The nature of online surveys dictate that you will get many ‘non completers’ – typically only 30-40% of people that start your survey will actually complete the entire survey. This will obviously vary if their is a reward for completion … Continue reading

Category Tags Data Collection, Data Analysis
What options are there for data download?

The data is downloaded as a CSV file (Comma Separated Values) which is compatible with most data analysis tools e.g. SPSS and Excel. However, you have a number of options of HOW the data is formatted prior to download. For example, if … Continue reading

Category Tags Data Analysis
How can I view my data?

You can view your datasets online, as well as downloading all data as a CSV spreadsheet for importing into SPSS or Excel. Options for online viewing include bar graphs, pie charts and 3d pies. Examples are shown below – note … Continue reading

Category Tags Data Collection, Data Analysis
What data does iSurvey collect about participants?

The default data options when you are download your participant responses are the following: – Participant ID (Unique) – Date/Time Started – Date/Time Finished – Total time taken – IP Address – Question Order – Section Order This is then followed by … Continue reading

Category Tags Data Collection, Data Analysis
How to import CSV data to SPSS or Excel

iSurvey allows you to download your data as a CSV file. This stands for ‘Comma Separated Values’ and is essentially a text file with the file extension .csv CSV files can be imported into either excel or SPSS and there already exists  many tutorials … Continue reading

Category Tags Data Collection, Data Analysis