Entering your Planet or Fleet information into a spreadsheet is very tiring. So I say why reinvent the wheel?
I use Open Office - available for Mac, Windows, and Linux.
Step 1. Highlight the Planet information in full. Copy it.
Step 2. Paste, NOT Paste Special, into the spreadsheet. Here, it will automatically open the paste options
screen. Select the Merge Delimiters, Tab, and Other. In the Other space, place 2 spaces.
Step 3. Select Okay.
it is done. Your Planets will now be in separate cells and in an order you can now work with.
This will work with your fleets, ship build codes as well.
Respects...