Daniel Morrison

Excel has a per-cell character limit.

Note: Excel (on a 32-bit system) has a limit on the number of characters (bytes) per-cell that is somewhere around 32,000. NeoOffice’s limit (on a 64-bit system) is around 64,000. Careful when you’re shoving large amounts of text into a file.

This public service announcement has been brought to you by Frustration, and Debugging a CSV Exporter.

2 Comments

  1. dreamhost promo code — August 19, 2008

    I am not sure about limit, but I was wondering if there is a way to use Excel to open a CSV file separated by ^ such that some cells contain new lines (\n) ?

  2. joseph — November 10, 2008

    i want to write these 2 lines into a single cell.

    example: The lion is in the field
    The bird is in the tree

    BOTH LINES IN A SINGLE CELL ?
    THANKS