Speaking for the Pathfinder sheet; there is not a way to import all spells at once. You can either enter them manually or drag/drop them from the compendium. Also, I would not recommend adding ALL spells. The character sheet will slow down significantly. My suggestion is to only add your prepared and/or your most frequently used spells. If you decide to change things up, just drag/drop as needed. The pathfinder sheet also uses Spellbooks (menu buttons of your spells posted to chat) There is an option on the sheet to only show the prepared spells.