How to export while keeping blank rows?

50 views
Skip to first unread message

tanisfr...@gmail.com

unread,
Apr 18, 2018, 4:55:20 PM4/18/18
to OpenRefine
Hi there,

I have a spreadsheet that is one column. It is important that I preserve the blank rows between records, but no matter how I export, including playing around with the "Custom tabular exporter", the data comes back compressed without the blank rows. Is there a way to do this?

Many thanks!
Tanis

Thad Guidry

unread,
Apr 18, 2018, 5:04:47 PM4/18/18
to openr...@googlegroups.com
Capture.PNGAre you sure you have the option checked at bottom of Custom Tabular exporter ?

I click Download and then choose CSV format and get the following CSV file content...

thad,Spain
,
,
,
,

-Thad

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ettore Rizza

unread,
Apr 18, 2018, 5:08:47 PM4/18/18
to OpenRefine
Hi Tanis,

The export of empty rows works for me with "Custom tabular exporter".

tanisfr...@gmail.com

unread,
Apr 19, 2018, 11:14:29 AM4/19/18
to OpenRefine
Thanks Thad and all that finally worked for me!
Tanis
Reply all
Reply to author
Forward
0 new messages