It's possible to cut and paste data from excel and other grid based applications i.e. SQL Server.Tabular data can only be pasted into the XML Grid, and only into cells which are being viewed in the table layout. The pasted cells overwrite existing cells (as with Excel) so it's better to add new data to the end of an existing table.

If the clipboard data contains more columns than are to the right of the target paste point then they are discarded.

If the clipboard data contains more rows than are bellow the target paste point then new rows are inserted.

Step By Step Walk through

Step 1

Open and XML Document

Step 2

Ensure the Design or Split View layout is selected (bottom left of the window)

Step 3

Create a row at the end of the existing data, we will paste our new data over this.

Step 4

Select the data within Excel and copy it to the clipboard (excluding any title rows)

Step 5

Select the first columns in the row we inserted in step 3 and paste the Excel data. New rows will be created for each Excel row.