Ask Your Question

How to export CSV file from spreadsheet with multi-line cells? [closed]

asked 2014-12-24 07:08:06 +0200

john Paul gravatar image

updated 2016-03-07 03:14:55 +0200

Alex Kemp gravatar image

Need a way to quote or remove newlines in exported CSV files. Using LibreOffice

Is there a way to search/replace spreadsheet cells that have multiple lines?

If the original spreadsheet has multiple lines, the CSV file will look like

A1, "B1 stuff",C1 A2, "B2 stuff",C2 A3,"B3 stuff",C3


this is difficult for text based tools to work with

the xlsx2csv php python script has a quoting option so the output looks like: A1, "B1 stuff",C1 A2, "B2\nstuff",C2 A3,"B3 stuff",C3

would be nice to do this directly in save as

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 2016-03-07 03:15:07.554271

1 Answer

Sort by » oldest newest most voted

answered 2014-12-24 08:44:35 +0200

karolus gravatar image

tick [x]Filteroptions in save-Dialog, with [x]quote Text between Quotechars in next Dialog

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-12-24 07:08:06 +0200

Seen: 2,059 times

Last updated: Dec 24 '14