Skip to end of banner
Go to start of banner

Exported Survey & Vote and MS Excel Import

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

An export from a Survey or Vote macro that contains multiple lines (in comments, for example) may render without the newlines in MicroSoft Excel.

This is not a limitation of the Survey & Vote macros. This is a limitation of MS Excel.

See this and numerous other articles about problems with MS Excel importing CSVs with multiline values: How can we improve Excel for Mac?

We have tested importing Survey & Vote multiline data into Libreoffice and OpenOffice without problems. We have reproduced the trouble with importing into MS Excel.

WORKAROUND:

Many people think the best workaround is to import CSV into Libreoffice or google sheets or … and then save as an MS Office doc and then open that in MS Excel.

  • No labels