# Data Import and Export

Here are the most immediate use cases:

* importing data from a legacy system when starting with Pakk from scratch&#x20;
* exporting data, bulk manipulation in Excel, then re-import to Pakk
* exporting data for import into 3rd-party systems
* exporting data for backup
* exporting data for reporting and analysis

Here's the thing though - you'll also know that the CSV format can be unwieldy and the export/import process tedious, for lots of reasons:

* column headings misspelt&#x20;
* column headings in the wrong order
* stray characters like `"` or `,` within your text can throw a spanner in the works
* differences in line ending and character encoding between systems
* complex and embedded structures like lists or composite fields don't map at all well to the CSV format
* referencing other records by their ID can be hard to get right
* empty lines at the bottom of your CSV

I've probably still missed quite a few!

The Pakk data export/import system is designed, as far as possible, to be your everyday companion in commerce data munging and to be as painless as possible in the face of the above difficulties.


---

# 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.pakk.io/data-and-integrations/data-import-and-export.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.
