Open the sheet, then choose File, then Export, then Export to Microsoft Excel or Export to CSV. The file downloads to your browser. That is the whole flow, and it works the same on Pro, Business and Enterprise plans.
Pick Excel unless something forces you to use CSV. Smartsheet's help article on exporting a sheet notes that the Excel export keeps row hierarchy, which is the parent and child indentation your project plans rely on, while CSV flattens everything into plain rows. Excel also carries more of the column formatting. CSV carries text, and only text.
Two things surprise people on the first export. Formulas come out as the values they calculated, not as formulas, so a sheet full of SUMIF and cross sheet lookups becomes a sheet full of numbers. And multi select dropdown cells come out as one cell with the values separated, which is fine for reading and messy for importing into a database later.
What the file actually contains
You get the grid. Column names, row data, row hierarchy in the Excel version, and the sheet name as the file name. You do not get attachments, comments, cell history, proofs, automation rules, conditional formatting rules, the forms attached to the sheet, or the links to other sheets. Smartsheet's own documentation describes the export as the sheet data, and that phrasing is accurate in the narrow sense.
A faster way to grab many sheets
Exporting sheet by sheet is fine for twenty sheets and painful for four hundred. If you are over about fifty, skip ahead to the backup section and then the API section. Clicking through File and Export six hundred times is how a two day job becomes a two week job, and it is also how sheets get missed.
Before you export anything, build an inventory. One row per sheet, with the workspace, the owner, the row count, whether it feeds a report or dashboard, and whether anything else links to it. You will use that list four more times during the migration, and it is the single most useful artifact of the whole process.