Importing Data into AnyDB

AnyDB makes it easy to import and export data, so you can move information between systems or keep backups for offline use. Whether you're working with PDFs, spreadsheets, JSON exports, or preparing integrations, AnyDB ensures you stay in control of your data.

We believe you own your data, and we give you multiple ways to export or import it at any time.

---

Importing Data into AnyDB

You can import structured or unstructured data into AnyDB using the following options:

1. AnyDB JSON (with or without ZIP attachments)

• Import a JSON file that was previously exported from AnyDB.
• Supports importing the main document, children, and embedded attachments.
• If using a ZIP archive, attachments are automatically imported and linked.

2. Excel (.xlsx)

You can import Excel files in two ways:

• Import as a Single Document - Imports the excel cells directly into a AnyDB data document. Note only the first sheet of the excel file is imported.

  caution

  Excel files with many sheets or large datasets are not ideal for full parsing. AnyDB supports light spreadsheet-style structure but is not a full Excel replacement.

• Import and Parse Rows - Each row in the Excel file is imported as a separate data document based on a selected template.

3. CSV Files

• Parse each row into a separate data document based on a selected template.
• Useful for bulk imports from CRMs, contact lists, form responses, etc.

---

✅ Summary Table

Action	Formats Supported	Notes
Import from JSON	AnyDB JSON or ZIP	Preserves structure and attachments
Import from Excel	.xlsx	Import entire file or parse rows into structured data documents
Import from CSV	.csv	Parse each row into a new item based on a template