- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Importing TXT survey structure fails (OSX) after open in Excel
- miket
- Topic Author
- Offline
- New Member
Less
More
9 years 5 months ago #113404
by miket
Importing TXT survey structure fails (OSX) after open in Excel was created by miket
Dear Forum!
I love the tab-separated-file export option in limesurvey because its so easy to make changes in the survey structure. But after trying to re-import the file I am super frustrated. I tried several ways to prevent the import error message, but no success:
- tried "save as tab-separated" in Excel
- tried to copy and paste the text in an unmodified text-file after having it open in Excel
- tried to import it as a CSV file
Hope somebody can help.
Thank you!
Mike
I love the tab-separated-file export option in limesurvey because its so easy to make changes in the survey structure. But after trying to re-import the file I am super frustrated. I tried several ways to prevent the import error message, but no success:
- tried "save as tab-separated" in Excel
- tried to copy and paste the text in an unmodified text-file after having it open in Excel
- tried to import it as a CSV file
Hope somebody can help.
Thank you!
Mike
The topic has been locked.
- cshaw
- Offline
- Senior Member
Less
More
- Posts: 57
- Thank you received: 4
9 years 3 months ago #115380
by cshaw
Replied by cshaw on topic Importing TXT survey structure fails (OSX) after open in Excel
I am having similar problems, did you find any solution?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
9 years 3 months ago #115398
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Importing TXT survey structure fails (OSX) after open in Excel
www.libreoffice.org/download/libreoffice-still/
is really the BEST solution.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- fransmarcelissen
- Offline
- Premium Member
Less
More
- Posts: 118
- Thank you received: 49
9 years 3 months ago #115405
by fransmarcelissen
Replied by fransmarcelissen on topic Importing TXT survey structure fails (OSX) after open in Excel
I would even go one step further, do'nt use excel for this, use libreoffice. I had many problems with the export, that stopped after using libreoffice. Of course you can save it in libreoffice as a excel file en use it in excel if you want.
Frans
Frans
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
9 years 3 months ago #115489
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Importing TXT survey structure fails (OSX) after open in Excel
And libreoffice is a free software, free like a speech !fransmarcelissen wrote: I would even go one step further, do'nt use excel for this, use libreoffice. I had many problems with the export, that stopped after using libreoffice. Of course you can save it in libreoffice as a excel file en use it in excel if you want.
Frans
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
9 years 3 months ago #115502
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic Importing TXT survey structure fails (OSX) after open in Excel
The problem is that MS Excel doesn't stick to standard. It is famous for creating problems when dealing e.g. with CSV files. Once a CSV file exported from Limesurvey is opened in Excel and saved, the internal data structure changes which could lead to failing import.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.