Buggish: Pasting data from SSMS to Teams Excel (Web)

Issue

When I copy data from SSMS default results table to Teams Excel (Web), data is not translated directly into separate cells.

Cause

The cause for this is due to one of the cells that starts with a single double-quote. This will result with all data after the single double-quote to be in a single cell.

Fix

I do not have a fix for this if you require to keep the double-quote except to manually work around it. This was a data issue on user end which does not resolve the actual issue.

Work-around is perhaps to save the SSMS results in a different format, replace the double-quote with a different value or prepend with an escape character (sorry, I don't know what that is either).

Setup

SQL Server Management Studio	v18.4
Google Chrome	Version 83.0.4103.97 (Official Build) (64-bit)
Teams Excel (Web)	16.0.13014.35904