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

Paul Golightly
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 3, 2022

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?

4 answers

3 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2022

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.

0 votes
Arne Balks
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 3, 2023

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

0 votes
Benjamin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 3, 2022

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

0 votes
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 3, 2022

@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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events