Export to Excel: Why are answers incomplete when I export the data to Excel?

Registering a new user

With email

I agree to user agreement! General terms of use.

I agree that you send me notifications to the above-mentioned email address (important information about 1KA, 1KA evaluation, event invitation - once a year).

Do you have an account? Sign in

With account

With email

Please, check if data are correct, especially the email address, since you will receive a confirmation email at the given email account.

Namely, often do the following problems occur:

Typos when entering an email address, for example: 'eenklikanketa@gmali.com'
Wrong address, for example, you logged in with another email address, so check all you email accounts
Unnecessary space, for example 'enklikanketa @ gmail.com'
Incorrect domain extension, for example, instead of 'enklikanketa@gmail.com' you entered 'enklikanketa@gmail.si' or 'enklikanketa@gmail.net'

E-mail:

Name (username):

Password:

Notification:

Next Back

E-mail confirmation

We have sent instructions on how to finish your registration to the entered email address (SFMAIL).
If you don't receive an e-mail in a few minutes, don't forget to check your spam folder.

Also, check if the entered email address is correct. Namely, often do the following problems occur:

Typos when entering an email address, for example: 'enkllikanketa@gmali.com'
Wrong address, for example, you logged in with another email address, so check all you email accounts
Unnecessary space, for example 'enklikanketa @ gmail.com'
Incorrect domain extension, for example, instead of 'enklikanketa@gmail.com' you entered 'enklikanketa@gmail.si' or 'enklikanketa@gmail.net'.

If you still have problems finding our confirmation e-mail, you can contact us by e-mail info@1ka.si.

You won't be able to login into this webpage until you confirm your registration through e-mail!

Export to Excel: Why are answers incomplete when I export the data to Excel?

If you export the data from 1KA in the Excel format, this problem does not occur. In case you export the data in CSV format and then open it with Excel, opened answers may be incomplete.

This issue is due to the limitations of the Microsoft Excel software (version 2007 and newer versions), which can be resolved in a few steps.

1. The first steps has two options (if one fails, try the other):

In the ‘DATA’ – ‘Export’ – ‘CVS’ tab, perform an export (the separation character should be set to a semicolon) and save the file to local disk.
In the ‘DATA’ – ‘Export’ – ‘Text file’ tab, export the text file and save it to local disk.

2. Open MS Excel with a blank document.

3. In Excel, select the tab Data and click on the From text icon. Then find the data file that you transferred in step 1 on your computer and click Import.

4. Text import wizard will appear in a new window, which has three steps:

In the Original data type tab, select the option Delimited. Continue to the next step by clicking Next.
In the Delimiters tab, select only the semicolon. Proceed to the next step by clicking Next.
In the Data preview tab, select all columns, by clicking on the first column, pressing shift, and then clicking on the last column. Set the design of the columns in the Column data format tab to Text. Click Finish.

5. A new window will appear, where you specify where you wish to import the data. Existing worksheet is set by default, which you confirm by clicking OK.

The data has now been imported into an empty Excel file in a way that does not limit the number of characters with open-ended questions.

Login user NA WWW.1KA.SI

With email

With account

Password activation

Own installation

Password reset

Gmail

Facebook

1KA.ARNES.SI

1KA.ARNES.SI

Registering a new user

With email

With account

With email

E-mail confirmation

INDIVIDUALNO SVETOVANJE

ONLINE SERVICE

Main menu

Export to Excel: Why are answers incomplete when I export the data to Excel?