Import CSV into Numbers
Opens instantly,
no import dialog.
Free CSV to Apple Numbers converter. Download an XLSX file that Numbers opens natively with no import wizard — auto-sized columns, bold header, number detection. Or get a clean UTF-8 CSV for the Numbers Text Import. Your data never leaves your browser.
Three methods — the XLSX route needs zero clicks in any import dialog.
Mac — drag and drop (fastest)
- Download the .xlsx from CSVShift
- Drag the file onto the Numbers icon in your Dock
- Numbers opens it instantly — no import dialog, no delimiter selection
iPhone & iPad
- Download the .xlsx via Safari or AirDrop it from your Mac
- Tap the file in the Files app
- Tap Open with Numbers — the spreadsheet opens fully formatted
iCloud Drive (any device)
- Upload the .xlsx to iCloud Drive at icloud.com
- On any Apple device, open the Files app → iCloud Drive
- Tap the file — Numbers opens it automatically
| Feature | XLSX (recommended) | Clean CSV |
|---|---|---|
| Import dialog in Numbers | None — opens instantly | Shows Text Import Settings |
| Number types preserved | Integers and decimals detected | All columns open as text |
| Auto column widths | Yes — set by CSVShift | Numbers uses default widths |
| Bold header row | Light grey background | No formatting |
| Opens on Windows/Linux | Excel, LibreOffice | Any text editor |
Numbers is the default spreadsheet on macOS and iOS. CSV exports from web apps, databases and analytics tools need to be imported into Numbers for further analysis, charting and sharing with Apple users via iCloud.
Numbers on iPad is a powerful spreadsheet tool for mobile data review. Converting CSV to XLSX via CSVShift and transferring via AirDrop or iCloud Drive produces a formatted spreadsheet ready to present on an iPad without any additional setup.
Export from Google Sheets as CSV, then convert to XLSX via CSVShift. Numbers opens the XLSX with correct column types — a cleaner result than Numbers' direct CSV import which treats numeric columns as text.
MySQL, PostgreSQL and SQLite exports come out as CSV. Converting to XLSX before opening in Numbers avoids the manual step of converting text columns to numbers in Numbers' format toolbar.
XLSX for Numbers —
no dialog, no rework. No server.
When you open a CSV directly in Numbers, it shows the Text Import Settings panel every time — and all columns come in as text, so numbers need to be converted manually. CSVShift generates an XLSX via SheetJS that Numbers opens instantly: column widths auto-fitted, integers and decimals already detected, header row with light grey background.
The .numbers format (IWA protobuf inside ZIP) cannot be generated in a browser. XLSX is the correct cross-platform approach — it opens in Numbers, Excel, LibreOffice and Google Sheets with full fidelity.
