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
Hi everyone, we totally get wanting more efficiency in entering repetitive data into your invoices, especially when updating longer invoices.
We’re working on an improvement to the line item grid of invoices that’ll make repeated column-based entry much faster. 😊
Once out, you'll be able to drag the contents of a field in one row up or down a column, making repeated updates much easier when entering things like account codes, tracking or tax rates.
I’ll round back to share once this is available to you all 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