Invoicing - Paste Multiple Cells into Invoice Lines
Why can’t Xero do basic spreadsheet-style paste???
This is honestly ridiculous: in 2026, Xero still can’t handle basic multi-cell paste like every normal grid on the web.
Everyone uses Excel, Google Sheets, Airtable. We copy blocks of rows and columns all day. In Xero, the same paste either dumps into one field or doesn’t work, so we’re forced into CSV import or manual entry. That is a massive waste of time for something that should be a baseline feature.
There is no technical excuse here. Airtable/Sheets don’t do anything magical. In a browser, multi-cell paste is just:
Clipboard text in TSV format (tabs between columns, newlines between rows)
A grid intercepts the paste event, reads clipboardData.getData('text/plain'), parses the TSV, and fills the grid cells
For strict fields (Account, Tax Rate, Tracking), it matches exact values or flags invalid cells with a clear error
Request
Add spreadsheet-style multi-row, multi-column paste (TSV) into line item grids (Invoices and Bills at minimum). Create new lines automatically, validate values, and highlight any cells that don’t match (e.g., Account/Tax). This is a basic productivity feature and Xero is behind on it.
be MODERN. PLEASE!
Nic Lap
shared this idea
Hey team, I'd like to confirm drag and filling a column of your invoice from one cell is now released to all users.
You can click the blue dot in the bottom-right corner of a cell and drag up or down the column. Alternatively, hold Shift on a cell and use the up or down arrows to select cells, then press Enter to apply. 😁
You'll find this feature within invoices, quotes, purchase orders, sales credit notes, and when editing bills in quick view. Thanks for your support and contributions to the idea here.
-
Rod LLoyd
commented
We use Xero for hire of goods on a monthly basis and use the Quantity column to advise the number of days that the goods have been on hire.
We find it too time consuming with having to change the number from 30 days to 31 days each month If we could copy and paste to change these quantities it would be great -
David Downie
commented
I like this idea, it would make thing more efficient.
-
Nic Lap
commented
Why can’t Xero do basic spreadsheet-style paste???
This is honestly ridiculous: in 2026, Xero still can’t handle basic multi-cell paste like every normal grid on the web.
Everyone uses Excel, Google Sheets, Airtable. We copy blocks of rows and columns all day. In Xero, the same paste either dumps into one field or doesn’t work, so we’re forced into CSV import or manual entry. That is a massive waste of time for something that should be a baseline feature.
There is no technical excuse here. Airtable/Sheets don’t do anything magical. In a browser, multi-cell paste is just:
Clipboard text in TSV format (tabs between columns, newlines between rows)
A grid intercepts the paste event, reads clipboardData.getData('text/plain'), parses the TSV, and fills the grid cells
For strict fields (Account, Tax Rate, Tracking), it matches exact values or flags invalid cells with a clear error
Request
Add spreadsheet-style multi-row, multi-column paste (TSV) into line item grids (Invoices and Bills at minimum). Create new lines automatically, validate values, and highlight any cells that don’t match (e.g., Account/Tax). This is a basic productivity feature and Xero is behind on it.be MODERN. PLEASE!
-
Okey Onyeachu
commented
I have worked with an accounting system that allows many rows e.g. description, Qty, Price, Account and Tax rate to be copied from Excel (at a go) and pasted to create an invoice, Journal etc. This saves a lot of time.
Can you please look into activating such function. Thanks