Skip to main content
All CollectionsFAQs
Why are my columns not matching after importing from Excel?
Why are my columns not matching after importing from Excel?

After importing an Excel sheet into O&D, if it doesn't display correctly, check for extra whitespace around the placeholders in O&D.

Ciara Scott avatar
Written by Ciara Scott
Updated over a year ago

After you have imported your Excel sheet into O&D and it is not displaying properly in the document, it may be due to extra whitespace accidentally added before or after the placeholder in Excel.

In order to get rid of the extra whitespace, you will need to edit the column in O&D and remove the extra spaces. Follow these steps to do so:

  1. Clicking on the arrow beside each Column Heading will open the Column Heading menu.

2. From this menu, you can click Edit column

3. Within the field name input delete any whitespace before or after the placeholder.

4. Press Update. Then open your document preview to make sure everything is matching as expected.

Did this answer your question?