NEW 
Blog | Community | Contact      en  fr  pl
Professional online survey system!

Help sections

FAQ

MS Excel data import

Please find below description showing how to import data to MS Excel.

To import data to MS Excel :

  1. open MS Excel and select Data tab (if you are using Excel 2003 select File and then Open)
  2. in section Get external data select From text
    Import responses from text
  3. select file you want to import and press Import button
  4. in section Original data type select option Delimited
  5. set file origin as Unicode (UTF-8) and press Next button
    import survey results to excel (data type)
  6. set delimiters as Comma and press Next button. Make sure that Comma is the only check box selected.
    Import survey responses to Excel (delimiters)
  7. set column data formal as General and press Finish button
    import data to excel (column data format)
  8. select initial cell in your spread shit where you will place your data and press OK

NOTE. Exported from mysurveylab zip file contains two csv files. We recommend usage of flat csv file for MS Excel. Flat file does not contain ENTER characters which may cause problems with proper data import into Excel.

Character coding standards

For most cases Unicode (UTF-8) coding should properly display your language characters. If you encounter any problems please check other available coding standard or contact our support.