Skip to Content
-2

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 10, 2017 at 03: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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10, 2017 at 03: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                  |
    +-----------------+-----------+--------------+---------------------+
    Add comment
    10|10000 characters needed characters exceeded