Your new data set would have three variables: var1, count, and percent. This is fine for a single variable frequency. If you do a by- frequency, then you'd get a more complex data set.
One thing that I've had good luck with in copy/pasting single frequency tables from the output window is using the Excel feature of Data / Text-to-Columns. It takes a little playing around with to get it to break just right, but it's pretty forgiving.