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

Questions
,
1

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.

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1720716/RackMultipart20180329-101003-dyr2vc-file_inline.PNG?1522312286373×517 11.4 KB

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.

2

Fixed this by upgrading!

3

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.