Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

What is the maximum size of the CSV file that can be exported?

former_member391452
Explorer

‎08-10-2017 4:05 PM

0 Kudos

I am developing a report which we give output in ALV format. The ALV has 140 columns and the number of records can be around 50K or more. So, when processed in background I want to export the ALV records in either XLS or CSV file. But I heard that XLS has a limitation of 50K records. Is there any such limitation on CSV file as well? If yes, what is the limitations?

Please help!!

2 REPLIES 2

pokrakam
Active Contributor

‎08-10-2017 4:11 PM

Why don't you just test it? In the time it takes to write your post you could have written the 5 lines of code or so to fill it with 100k or however many lines you're interested in.

bertrand_delvallee
Active Participant

‎08-10-2017 4:58 PM

Hello,

.XLS format is limited to 256 columns and 65k rows.

.CSV format as no rows limits (but a size limit that you will not reach...probably around 2Go, depending on your OS). Note that you can encounter difficulties if you open it with a basic text editor.

If you can, you should try to create .XLSX file or a more simple XML Excel file. You should have a look there : ABAP2XLSX

+-----------------+-----------+--------------+---------------------+
|                 | Max. Rows | Max. Columns | Max. Cols by letter |
+-----------------+-----------+--------------+---------------------+
| Excel 365*      | 1,048,576 | 16,384       | XFD                 |
| Excel 2013      | 1,048,576 | 16,384       | XFD                 |
| Excel 2010      | 1,048,576 | 16,384       | XFD                 |
| Excel 2007      | 1,048,576 | 16,384       | XFD                 |
| Excel 2003      | 65,536    | 256          | IV                  |
| Excel 2002 (XP) | 65,536    | 256          | IV                  |
| Excel 2000      | 65,536    | 256          | IV                  |
| Excel 97        | 65,536    | 256          | IV                  |
| Excel 95        | 16,384    | 256          | IV                  |
| Excel 5         | 16,384    | 256          | IV                  |
+-----------------+-----------+--------------+---------------------+