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

[Paul Golightly]

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?

[Katerina Kovriga _Stiltsoft_]

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.

[Arne Balks]

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

[Benjamin]

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

[Brant Schroeder]

@Paul Golightly Welcome to the Atlassian community

Are you using the CSV file to table app?  If yes I would suggest submitting a support issue to them https://marketplace.atlassian.com/apps/1224637/csv-file-to-table-for-confluence?tab=support&hosting=cloud