Apple Numbers has a 1,000,000 rows limit.
When importing a big CSV file, only the first million rows are imported. Extra rows are skipped.
<img src="/learn_images/csv/apple-numbers-rows-limit/numbers-import-rows-limits.png#1232x536" alt="Importing a CSV file with more than 1m rows">
This is a hard limit defined in the software. The operational limit is way lower. When editing a 1,000,000 rows spreadsheet with a Macbook Pro M1 16Go, the application freezes for several seconds every time I want to edit a cell.
<img src="/learn_images/csv/apple-numbers-rows-limit/editing-big-csv-numbers.png#2504x1588" alt="Editing big spreadsheet Apple Numbers">
<h2 id="user-content-how-to-get-around-apple-numberss-max-row-limit"><a href="#how-to-get-around-apple-numberss-max-row-limit" aria-hidden="true" tabindex="-1"></a>How to get around Apple Numbers's max row limit?</h2>
Spreadsheet tools are not suited for big spreadsheets. They must keep all the data in memory so users can link any cell in their formulas.
Apple Numbers is not a database and have poor performance on big listing. See our guide on how to <a href="/how-to/edit-big-csv-files-online">edit big CSV files online</a>.


**Apple Numbers has a 1,000,000 rows limit.**

When importing a big CSV file, only the first million rows are imported. Extra rows are skipped.

![Importing a CSV file with more than 1m rows](/learn_images/csv/apple-numbers-rows-limit/numbers-import-rows-limits.png#1232x536)

This is a hard limit defined in the software. The operational limit is way lower. When editing a 1,000,000 rows spreadsheet with a Macbook Pro M1 16Go, the application freezes for several seconds every time I want to edit a cell.

![Editing big spreadsheet Apple Numbers](/learn_images/csv/apple-numbers-rows-limit/editing-big-csv-numbers.png#2504x1588)

## How to get around Apple Numbers's max row limit?

**Spreadsheet tools are not suited for big spreadsheets.** They must keep all the data in memory so users can link any cell in their formulas.
Apple Numbers is not a database and have poor performance on big listing. See our guide on how to [edit big CSV files online](/how-to/edit-big-csv-files-online).


Apple Numbers has a 1,000,000 rows limit.
When importing a big CSV file, only the first million rows are imported. Extra rows are skipped.
Importing a CSV file with more than 1m rows
This is a hard limit defined in the software. The operational limit is way lower. When editing a 1,000,000 rows spreadsheet with a Macbook Pro M1 16Go, the application freezes for several seconds every time I want to edit a cell.
Editing big spreadsheet Apple Numbers
How to get around Apple Numbers&amp#39;s max row limit?
Spreadsheet tools are not suited for big spreadsheets. They must keep all the data in memory so users can link any cell in their formulas.
Apple Numbers is not a database and have poor performance on big listing. See our guide on how to edit big CSV files online.


Apple Numbers maximum rows per spreadsheet

To convert a Numbers (<code>.numbers</code>) file into a <code>.csv</code> file, you can directly use the Apple Numbers app.
First, load your Numbers file file with the Apple Numbers app. Then, use the File -> Export To -> CSV menu action.
<img src="/learn_images/csv/export_apple_numbers_to_csv/apple_numbers_to_csv.png#1488x966" alt="File -> Export To -> CSV">
If needed, change the text encoding format in the "Advanced Options".
<blockquote>
Do not check the "Include table names" option! It adds a first row with the name of the table in your CSV file, which will be considered as a <a href="/learn/csv/csv-headers">CSV header</a> with only one column by most applications.
</blockquote>
<img src="/learn_images/csv/export_apple_numbers_to_csv/apple_numbers_csv_options.png#1410x826" alt="CSV Exporting Options">
Then, click the Next button to select a save location. Finally, click the Export button.


To convert a Numbers (`.numbers`) file into a `.csv` file, you can directly use the Apple Numbers app.

First, load your Numbers file file with the Apple Numbers app. Then, use the **File -> Export To -> CSV** menu action.

![File -> Export To -> CSV](/learn_images/csv/export_apple_numbers_to_csv/apple_numbers_to_csv.png#1488x966)

If needed, change the text encoding format in the "Advanced Options".

> Do not check the "Include table names" option! It adds a first row with the name of the table in your CSV file, which will be considered as a [CSV header](/learn/csv/csv-headers) with only one column by most applications.

![CSV Exporting Options](/learn_images/csv/export_apple_numbers_to_csv/apple_numbers_csv_options.png#1410x826)

Then, click the **Next** button to select a save location. Finally, click the **Export** button.


To convert a Numbers (.numbers) file into a .csv file, you can directly use the Apple Numbers app.
First, load your Numbers file file with the Apple Numbers app. Then, use the File -&ampgt; Export To -&ampgt; CSV menu action.
File -&ampgt; Export To -&ampgt; CSV
If needed, change the text encoding format in the &ampquot;Advanced Options&ampquot;.
Do not check the &ampquot;Include table names&ampquot; option! It adds a first row with the name of the table in your CSV file, which will be considered as a CSV header with only one column by most applications.

CSV Exporting Options
Then, click the Next button to select a save location. Finally, click the Export button.


Export Numbers spreadsheet into a CSV file

Spreadsheet and database both store sets of data. However, each one has advantages and disadvantages and is suited to specific use cases.
A spreadsheet represents a digital worksheet and was invented for accounting tasks. In a spreadsheet, data is stored in a flat structure consisting of rows and columns, also known as tabular format. Spreadsheets are simple to use and require no technical knowledge. Because a spreadsheet is flexible and doesn't have a data schema, any value can be entered in any cell. The drawback of this flexibility is the lack of data schema. Spreadsheets cannot be used safely as a source of data for other applications as they cannot provide a strict structure.
Finally, spreadsheets are designed to handle a limited volume of data.
In databases, data is stored in tables, which have a defined structure. This data structure describes for each table, the attributes and data types expected. For example, attributes can be text, date, text, or relationship to another table. This data structure adds constraints and triggers errors directly when inserting a new record in the database. Thanks to this strict structure, other applications can rely on the data provided by a database.
Unlike spreadsheets, databases are better for storing large amounts of data and when several users or applications access the data simultaneously.


Spreadsheet and database both store sets of data. However, each one has advantages and disadvantages and is suited to specific use cases.

A spreadsheet represents a digital worksheet and was invented for accounting tasks. In a spreadsheet, data is stored in a flat structure consisting of rows and columns, also known as tabular format. Spreadsheets are simple to use and require no technical knowledge. Because a spreadsheet is flexible and doesn't have a data schema, any value can be entered in any cell. The drawback of this flexibility is the lack of data schema. **Spreadsheets cannot be used safely as a source of data for other applications as they cannot provide a strict structure**.
Finally, spreadsheets are designed to handle a limited volume of data.

In databases, data is stored in tables, which have a defined structure. This data structure describes for each table, the attributes and data types expected. For example, attributes can be text, date, text, or relationship to another table. This data structure adds constraints and triggers errors directly when inserting a new record in the database. **Thanks to this strict structure, other applications can rely on the data provided by a database.**
Unlike spreadsheets, databases are better for storing large amounts of data and when several users or applications access the data simultaneously.


Spreadsheet and database both store sets of data. However, each one has advantages and disadvantages and is suited to specific use cases.
A spreadsheet represents a digital worksheet and was invented for accounting tasks. In a spreadsheet, data is stored in a flat structure consisting of rows and columns, also known as tabular format. Spreadsheets are simple to use and require no technical knowledge. Because a spreadsheet is flexible and doesn&amp#39;t have a data schema, any value can be entered in any cell. The drawback of this flexibility is the lack of data schema. Spreadsheets cannot be used safely as a source of data for other applications as they cannot provide a strict structure.
Finally, spreadsheets are designed to handle a limited volume of data.
In databases, data is stored in tables, which have a defined structure. This data structure describes for each table, the attributes and data types expected. For example, attributes can be text, date, text, or relationship to another table. This data structure adds constraints and triggers errors directly when inserting a new record in the database. Thanks to this strict structure, other applications can rely on the data provided by a database.
Unlike spreadsheets, databases are better for storing large amounts of data and when several users or applications access the data simultaneously.


How spreadsheets and databases differ technically?

To convert a <code>.xlsx</code> or <code>.xls</code> file into a <code>.csv</code> file, Microsoft Excel is the perfect tool.
First, load your <code>.xlsx</code> or <code>.xls</code> file with Excel. Then, use the File -> Save As menu action.
<img src="/learn_images/csv/export_excel_to_csv/microsoft_excel_convert_to_csv_save_as.png#1488x966" alt="File -> Save As">
Choose where you want to save your CSV file and select CSV UTF-8 (Comma delimited) (.csv) in the File format dropdown.
<img src="/learn_images/csv/export_excel_to_csv/microsoft_excel_convert_to_csv_select_format.png#1378x892" alt="Select CSV in file formats">
Finally, click the Save button.


To convert a `.xlsx` or `.xls` file into a `.csv` file, Microsoft Excel is the perfect tool.

First, load your `.xlsx` or `.xls` file with Excel. Then, use the **File -> Save As** menu action.

![File -> Save As](/learn_images/csv/export_excel_to_csv/microsoft_excel_convert_to_csv_save_as.png#1488x966)

Choose where you want to save your CSV file and select **CSV UTF-8 (Comma delimited) (.csv)** in the File format dropdown.

![Select CSV in file formats](/learn_images/csv/export_excel_to_csv/microsoft_excel_convert_to_csv_select_format.png#1378x892)


Finally, click the **Save** button.


To convert a .xlsx or .xls file into a .csv file, Microsoft Excel is the perfect tool.
First, load your .xlsx or .xls file with Excel. Then, use the File -&ampgt; Save As menu action.
File -&ampgt; Save As
Choose where you want to save your CSV file and select CSV UTF-8 (Comma delimited) (.csv) in the File format dropdown.
Select CSV in file formats
Finally, click the Save button.


Export Microsoft Excel spreadsheet into a CSV file

When it comes to storing data online, spreadsheets and databases are two possible options. Understanding the differences between them is crucial to find the best tool for your task.
Spreadsheets (Excel and Google Sheets) are easy to use and inexpensive. They are the go-to solution when it comes to simple analytics and data manipulation. For example, spreadsheet tools offer analytics features to display charts or create pivot tables.
Databases are designed to handle larger datasets and structured data. They offer built-in data constraints to force field format or to avoid duplicate information. Databases have powerful query languages to search and filter their data. These features are powerful but add complexity compared to spreadsheets. As a result, databases have a steep learning curve.
If you need to connect to your data programmatically, databases are the go-to solution. Thanks to its data structure, a database ensure the data is valid before saving it.
If you need to store less than 1 million records and don't need to connect your data to an application, spreadsheets do the job.


When it comes to storing data online, spreadsheets and databases are two possible options. Understanding the differences between them is crucial to find the best tool for your task.

Spreadsheets (Excel and Google Sheets) are easy to use and inexpensive. They are the go-to solution when it comes to simple analytics and data manipulation. For example, spreadsheet tools offer analytics features to display charts or create pivot tables.

Databases are designed to handle larger datasets and structured data. They offer built-in data constraints to force field format or to avoid duplicate information. Databases have powerful query languages to search and filter their data. These features are powerful but add complexity compared to spreadsheets. As a result, databases have a steep learning curve.

If you need to connect to your data programmatically, databases are the go-to solution. Thanks to its data structure, a database ensure the data is valid before saving it.

If you need to store less than 1 million records and don't need to connect your data to an application, spreadsheets do the job.


When it comes to storing data online, spreadsheets and databases are two possible options. Understanding the differences between them is crucial to find the best tool for your task.
Spreadsheets (Excel and Google Sheets) are easy to use and inexpensive. They are the go-to solution when it comes to simple analytics and data manipulation. For example, spreadsheet tools offer analytics features to display charts or create pivot tables.
Databases are designed to handle larger datasets and structured data. They offer built-in data constraints to force field format or to avoid duplicate information. Databases have powerful query languages to search and filter their data. These features are powerful but add complexity compared to spreadsheets. As a result, databases have a steep learning curve.
If you need to connect to your data programmatically, databases are the go-to solution. Thanks to its data structure, a database ensure the data is valid before saving it.
If you need to store less than 1 million records and don&amp#39;t need to connect your data to an application, spreadsheets do the job.


Spreadsheet

What is Apple Numbers row limit?

How to convert an Apple Numbers file to CSV?

What is the difference between a spreadsheet and a database?

How to convert an XLSX file to CSV with Microsoft Excel?

Should I use a spreadsheet or a database?