Rows copied from a spreadsheet commonly arrive as tab-separated text. Use Paste rows and verify that Separator is Tab when the date, description and amount fields are separated by tabs.
- Copy the intended rectangular range, including the header row if there is one.
- Paste into Rows, select the correct financial account, and choose Read rows.
- Check the separator, header setting and column mappings. Compare the preview with the spreadsheet before checking against the books.
Copy only the transaction table. Notes, subtotals and formulas displayed outside the table can become extra rows or misleading values if included in the selected range.
Preserve source values
Ensure the pasted dates and amounts show the values you intend. Spreadsheet display formatting can hide decimals, shorten dates or render identifiers differently from the original export. Compare a few representative rows with the bank source.
If the pasted text exceeds the size limit, divide the source into clear, non-overlapping periods. Keep headers consistent in each part and track which saved batch corresponds to each range. Resume an existing interrupted batch before starting another copy of the same rows.
Was this article helpful?
Tell us whether this answered the question you came with.