Skip to Content
-2

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

Aug 10, 2017 at 03:05 PM

135

avatar image
Former Member

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!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mike Pokraka Aug 10, 2017 at 03:11 PM
3

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.

Share
10 |10000 characters needed characters left characters exceeded
Bertrand DELVALLEE Aug 10, 2017 at 03:58 PM
1

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                  |
+-----------------+-----------+--------------+---------------------+
Share
10 |10000 characters needed characters left characters exceeded