# Import Data to dqMan

You can import data (not documents) from external sources into a repository using the import function. A data import takes place in two stages. First the data is loaded into a dqMan data grid, then the data is processed using the script generator.

The Import function is available in the **Extras** menu. In the **File Open** dialog box, you can select Excel files, CSV or text files.

Depending on the selected file type, you will be helped by the import assistants, as you can see later in this document.

### Import CSV or Text Files <a href="#toc88303078" id="toc88303078"></a>

<table><thead><tr><th>Function</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td><strong>Header line</strong></td><td>Line number with column headers, enter 0 for none.</td><td></td></tr><tr><td><strong>Start row</strong></td><td>Line to import from.</td><td></td></tr><tr><td><strong>End row</strong></td><td>Line to import to.</td><td></td></tr><tr><td><strong>Separator</strong></td><td>The character that separates the data columns. Valid are Tab, Semicolon, Comma or any free combination of characters, as well as the Fixed Width option.</td><td></td></tr><tr><td><strong>Options</strong></td><td><strong>Remove leading and trailing blanks</strong> - Removes all surrounding blanks.<br><strong>Remove leading and trailing apostrophes</strong> – Removes apostrophes.<br><strong>Pool separators</strong> – Combines several sequential separators into one.<br><strong>Ignore empty lines</strong> – Does not import lines with no data.</td><td></td></tr><tr><td><strong>Preview</strong></td><td>The preview shows how the selected options affect the import result. The number of lines displayed as preview is limited to 25.</td><td></td></tr></tbody></table>

### Import from Clipboard

You can also import data directly from the clipboard, if the data is of type text. Calling this function opens the CSV import assistant.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.dqman.com/opentext-documentum-edition-25.1/import-data-to-dqman.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.