Ask Your Question

Importing CSV with multiline entries [closed]

asked 2013-04-15 11:55:36 +0100

SeanW gravatar image

I have a CSV file exported from Aptest which contains descriptions that spread over more than one line. I want to import it into Calc.

The entries are all surrounded by quotation marks, yet after the import each line of such an entry appears as a seperate row in Calc. How to fix this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-30 08:16:21.277750

1 Answer

Sort by » oldest newest most voted

answered 2013-04-15 11:57:23 +0100

SeanW gravatar image

You have to change line endings from LF to CRLF for the importer to correctly handle the quotation marks. This may be a bug or a feature worth implementing.

edit flag offensive delete link more


I don't have any problem here importing a CSV with very long (multi-line) quoted fields. Are you running LO on Windows? What platform is the file coming from? May simply be a platform difference.

oweng gravatar imageoweng ( 2013-04-15 15:10:48 +0100 )edit

@oweng running Mint. Also, such things, even if varied across platforms, should be possible to parametrize in the importer.

SeanW gravatar imageSeanW ( 2013-05-02 10:15:58 +0100 )edit

Question Tools


Asked: 2013-04-15 11:55:36 +0100

Seen: 1,198 times

Last updated: Apr 15 '13