SQL Export all rows and Delete all rows

Hi this is my first post and I Was hoping someone could give me some helps and give me some ideas for solutions here. I am inserting entries into rows and i do not want the table becoming overwhelming and confusing. . . I would like to export the rows into a csv or excel using the export function and then delete all of the rows after x number of inserts. Currently I am on a windows computer doing the test server, but it will likely linux in the end. Any ideas for how this could happen would be great. . .