How can I clear the blank lines between rows in the CSV to table macro?

Question

I set up a searchable database of training materials on a wiki page last year, but at some point a few months ago, the "CSV (Comma Separated Values)" macro decided to start reading a blank line between each of the lines in my CSV file, resulting in a table where half the lines are blank (which, because it's sorted, all end up at the top).

Is anyone else encountering this issue? Any ideas how I can get the blank lines to go away?

Arne Balks · Answer

Getting the same issue on Confluence Cloud with the "CSV (Comma Separated Values)" macro. Didn't find any solution yet.

Katerina Kovriga {Stiltsoft} · Answer

Hi @Paul Golightly ,

If you are talking about the Table from CSV macro provided by the Table Filter and Charts for Confluence app, please raise a support ticket - the portal is confidential, attach your CSV file and we'll look into the issue.

Benjamin_tmh9yg · Answer

Hi @Paul Golightly ,

I haven't encounter this issue. But maybe this article can help clear your CSV file of blank lines, so the Macro can render it properly.

https://www.techrepublic.com/article/a-quick-way-to-delete-blank-rows-in-excel/

-Ben