Data Transfer & Integrations
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.
📤 Exporting Data from AnyDB
You can export your data in several formats depending on your use case:
1. Download as PDF
- Export any Data Document or Page as a PDF.
- Useful for sharing, printing, or offline review.
2. Export as JSON
Export a Data Document or its contents in AnyDB’s native JSON format, which can be imported back into AnyDB later.
Export Options:
| Export Type | What It Includes |
|---|---|
| Document Only | The selected data document only (without any attachments or children) |
| Document + Children | The document and all its attached children items (files, pages, documents) |
| Children Only | Only the children of the document |
| Template | The template used to generate the item |
If the exported document includes files or images, the export will be packaged as a ZIP file containing both the JSON and associated attachments.
3. Export to Excel (.xlsx)
You can export data to Excel in two ways:
- Single Document – Exports the item in a spreadsheet format, retaining layout and structure.
- Bulk Export by Template – Export all child items of a given template (e.g., contacts) into a spreadsheet. Each row represents one item, and each column corresponds to a field.
4. Export to CSV
Similar to Excel exports, but in a CSV format:
- Bulk Export by Template – Export multiple items of a specific template into a CSV. Each row represents a single data document.
📥 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
cautionExcel 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.
🔌 Integrations
Zapier integration (coming soon)
Soon, you'll be able to connect AnyDB to thousands of other apps using Zapier. Automate workflows, trigger actions, or sync data effortlessly across platforms.
✅ Summary Table
| Action | Formats Supported | Notes |
|---|---|---|
| Export to PDF | Pages, Data Documents | For quick sharing and printing |
| Export to JSON | AnyDB JSON or ZIP | Supports document + children + attachments |
| Export to Excel | .xlsx | Export single document or rows from a template |
| Export to CSV | .csv | Export rows from a specific template |
| 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 |