Finance | Project Operations, Human Resources, ...

How to export to excel blank columns

(0) Share

Report

Posted on by Bhagyashree Dave

133

Hi all,

I have created one inquiry page, in which more than 20 columns are blank, but are there for user's reference.

So, when we are exporting these data to excel, we are not able to export those blank columns and out of 60, we can only see 20 columns in our excel file.

Does anyone know what to do here?

Thanks in advance,

Bhagyashree Dave

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to export to excel blank columns

Hi Bhagyashree,

Please make sure you are not duplicating your questions on this forum. I just cleaned your duplicate.

Can you explain your question with screenshots? Are you using the option 'Open in Excel' or 'Export to Excel'? Can you also tell more about the inquiry page? Is it retrieving data from one table or multiple data sources? Are all columns on the grid or in case you are using 'Open in Excel', do you have all columns? Why do you need blank columns if an user can also extend the table in Excel?

Was this reply helpful? Yes No
Bhagyashree Dave 133 on at

Like (0)

Report

RE: How to export to excel blank columns

Hello Andre Arnaud de Calavon ,

Thanks for your reply.

We are using export to excel feature to export our inquiry page in excel.

We have 2 tables in our FormDataSource, VendInvoiceJour and VendInvoiceTrans.

We have more than 20+ columns without data in it, like we haven't assigned any value to them. User just wants to see those columns there without any data.

I have attached screenshot below.

Here, in the image, all the columns that you're seeing, are blank. Like there is no value assigned to them.

And after exporting to excel, it just skips all these columns and exports only columns with value in it with only 20 columns out of 60, as shown in below image.

What can we do here?

Regards,

Bhagyashree Dave

Was this reply helpful? Yes No
André Arnaud de Cal... 299,397 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to export to excel blank columns

Usually, the Export to Excel will take all the columns, regardless if they have a value or not. There might be a limitation with the number of columns which are exported from Dynamics 365. Have you tried a view with less fields?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to export to excel blank columns

Hi Bhagyashree Dave,

Is it a custom report? Do you have the same issue with other reports?

Can you check if the records that this report indicate are existed in a related table?

Was this reply helpful? Yes No