Delimited Import Field Wrappers

What Are Field Wrappers in Daylite Imports?

Field wrappers help Daylite correctly recognize and group data during imports so information is imported into the right fields. If a CSV file contains a commas, or a Tab Delimited File contains a tab, Daylite might treat it as a separator, accidentally shifting data into the wrong columns causing import issues.

Why Does Daylite Use Double Quotes by Default?

Most spreadsheet apps, like Excel and Numbers, automatically add double quotes (” “) around fields that contain special characters when exporting to CSV. Since this is the most common format, Daylite defaults to using double quotes as field wrappers to prevent data misalignment.

When Should You Adjust Field Wrappers?

•  If your data already has field wrappers (like < > instead of “ “), update the setting in Daylite to match.
•  If your data includes double quotes, you need to remove the quotes from your data or update your field wrappers in your delimited text file, AND your import settings in Daylite.

Adjust Field Wrapper Settings

If your data uses a different field wrapper, you can update the setting while importing data into Daylite:

1. Use the Import from Spreadsheet window.

2. Click inside the Field Wrappers field.

3. Enter your new field wrapper using your keyboard.

4. Ensure both Field Wrapper fields match the way your data is formatted.