Skip to end of banner
Go to start of banner

Exported Survey & Vote and MS Excel Import - newlines

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

« Previous Version 2 Current »

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