Export to excel requires user to use "text to columns"

  • 1
  • Question
  • Updated 8 months ago
  • Answered
I have included the "export table data" button on all object list views.Though I'm not sure it has been configured correctly.

Upon clicking this button, the file downloads.

When I try to open the file I'm asked what program I'd like to use to open the file (see screenshot below of the file that has downloaded.



When I open the file, I am required to use the "text to columns" function for the fields to be seperate by column.

Is this by design, or have I configured something incorrectly?

I'd really like to get away from using Salesforce report builder, but this isn't currently an upgrade.
Photo of Glenn Daly

Glenn Daly

  • 1,270 Points 1k badge 2x thumb

Posted 8 months ago

  • 1
Photo of Glenn Daly

Glenn Daly

  • 1,270 Points 1k badge 2x thumb
Fixed this by upgrading!
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,714 Points 20k badge 2x thumb
Also, export to Excel should really be labelled as "Export to CSV" as it's a comma separated values text file that we can open in Excel using it's ability to interpret as rows and columns.