How to paste WhatsApp exported chats into Numbers cells (individual cell per chat)?

Question

I need help with pasting strings of timestamped chats into rows of cells.

Currently, all chats are pasted into a cell instead of a cell per chat.

iPad mini 6, iPadOS 17

Posted on Nov 2, 2023 2:41 AM

Reply

Answer 1

Level 4

1,669 points

Numbers requires specific delimiters to separate data into different cells and if WhatsApp doesn't provide them you may be out of luck.

Two things you can try, I cannot guarantee that it works, I don't have WhatsApp to check.

Do not paste in a table. Make sure no table is selected and paste, it will create a new table, let's see if data organization will be different.
Paste first in TextEdit, Pages, Notes or Mail (or a Numbers text box ??), then copy again and paste in Numbers.

Reply

Similar questions