How to Easily Edit Database and Import Back without Errors

Hello, I need to change an huge quantity of rows from a table in phpMyAdmin.
I try to export and change it on Excel or LibreOffice but it doesn’t work when i import back. What’s the easiest why to edit great quantities of rows at the same time?