Copy Paste from Google Sheets to Numbers not working

I am copying 4 columns and about 30 rows.

When I paste the strangest thing happens. Only the first column appears, but with empty rows between each line, starting with 4 empty rows, then 5 empty rows, then 6 empty rows, and at 9 empty rows the data stops completely.

None of the other columns paste whatsoever.

I found a workaround by pasting to Excel, then copy and paste again back into Numbers.

[Edited by Moderator]

MacBook Pro 13″, macOS 14.0

Posted on Oct 11, 2023 6:27 AM

Top-ranking reply

Recycleur

Level 4

1,633 points

Posted on Oct 20, 2023 11:25 AM

After copying from Google sheet, switch to Numbers but make sure no table is selected. Just do a Paste, it will create a brand-new table and usually data is correctly laid out. If that data has to be put into a larger existing table you can then copy from that new table into the other one.

If some conversions are not correct (like your decimal separator is different than in the imported data) you can select the table and adjust import parameters in Format / Table / Adjust import rules.

View in context

Copy Paste from Google Sheets to Numbers not working

Similar questions