To export just one worksheet’s data from a Numbers spreadsheet, first make a separate working copy and remove the sheets and tables you do not want in the export. Then use File > Export To > CSV and choose whether Numbers should create a separate file for each table or combine tables into one file. Numbers’ documented CSV settings cover tables, not a “current sheet only” export, and hiding a sheet is not a reliable way to exclude its data. Apple’s export guide

Why a sheet tab alone does not limit the CSV

A Numbers spreadsheet can contain multiple sheets, and each sheet can hold tables and other items. Apple’s CSV export settings let you export each table to a separate file or combine tables into a single file; they do not document a control for exporting only the currently selected sheet. So clicking the sheet you want before exporting does not establish that the other sheets’ data will be omitted. Apple explains sheets and CSV export options.

A hidden sheet is still part of the spreadsheet. Apple specifically notes that people you share a spreadsheet with can still access hidden sheets. For a CSV intended to contain only one worksheet’s data, use a copy in which unwanted sheets and tables have been removed rather than relying on hiding them. This is a cautious workflow based on the documented export scope; Apple does not state that hidden sheets are excluded from CSV export.

Prepare a safe copy before exporting

  1. In Finder, locate the original .numbers file and duplicate it. Open the duplicate, and keep the original untouched. Give the working copy a clear name so you can distinguish it from the source.

  2. In the copy, identify the sheet that contains the table you want. Check whether it has additional tables: the CSV dialog’s per-table or combined-table choice affects whether more than one table’s data is included.

  3. Remove every unwanted sheet from the copy using the sheet tab’s menu and Delete. Apple documents deleting a sheet from its tab menu. If the target sheet itself contains other tables you must exclude, remove those from the copy too. Review the sheet tabs and tables before proceeding. Apple’s sheet guide

  4. If you need to keep the original arrangement or extra data in your working copy, another option is to create a separate Numbers spreadsheet containing only the desired table before export. That means rebuilding or copying the relevant table into a clean document; it is a workflow choice, not a special “export selection” feature documented by Apple.

Export the cleaned spreadsheet as CSV

With the copy open, choose File > Export To > CSV from the macOS menu bar. In the export settings, choose one file for each table if you want to keep tables in separate CSVs, or combine tables into a single file if the data should be together. For a copy containing one table, either option avoids including another table from that copy. Leave Include table names off unless the recipient needs table names added to the output. If text encoding matters to the receiving app, open Advanced Options and choose the encoding there. Apple documents these CSV controls.

Click Next or Save as shown in the export flow, choose a descriptive filename, and select a destination you can find again. Numbers appends the .csv extension. Exporting creates a copy in another format; changes to that exported file do not change the original Numbers spreadsheet. Apple’s export instructions.

Check the result before sending it

Open the CSV in a text editor or import it into the application that will use it. Confirm that the file contains the expected header row and records, and scan for a second table’s headings or data. If you exported one file per table, check the destination for multiple CSV files and share only the intended one. A CSV stores cell contents as comma-separated values; it is not a Numbers workbook with sheet tabs, charts, or layout preserved. Apple describes CSV output as cell values separated by commas.

If you find extra data, return to the Numbers working copy, remove the source of that data, and export again under a new filename. Do not treat deleting or hiding a sheet in the original as part of the export process; keep the original intact unless you deliberately want to change it.

Sources