You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Import Multi-Lined Descriptions

QUESTION

How should an Excel file be formatted so that there will be multiple lines in the description instead of the description wrapping when imported into QuickBooks Online (QBO)?

RESOLUTION

In the Excel file, enter the full description in the cell. Then, place the cursor right before the first character that needs to appear on a new line and select the ALT and ENTER keys on the keyboard.

Below is a screenshot showing an example of this technique. Please note that the example shown is for QBO, but this also works when importing into QuickBooks Desktop.

Sample Import File

Invoice in QBO

  • 362
  • 07-Jul-2019
  • 2295 Views