# flotiq-excel-migrator

> Migrator of of Flotiq data to and from MS Excel

Latest version **1.1.1** (published 2026-05-29) · MIT license · 0 weekly downloads

## Install

```sh
npm install flotiq-excel-migrator
pnpm add flotiq-excel-migrator
yarn add flotiq-excel-migrator
bun add flotiq-excel-migrator
```

Provides the commands `flotiq-excel-migrator`, `flotiq-wordpress-import`.

## Health

**Score 50/100 (C)** — status: active.

Positive: esm support; no vulnerabilities.

Warnings: low downloads; no types.

## Facts

| | |
|---|---|
| Version | 1.1.1 |
| Published | 2026-05-29 |
| First published | 2022-12-01 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | ESM + CommonJS |
| Dependencies | 6 |
| Unpacked size | 47.6 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 1 |
| Author | Flotiq team |
| Maintainers | flotiq |
| Keywords | flotiq, excel, xlsx |

## Links

- npm: https://www.npmjs.com/package/flotiq-excel-migrator
- Repository: https://github.com/flotiq/flotiq-excel-migrator
- Issues: https://github.com/flotiq/flotiq-excel-migrator/issues
- npm.io page: https://npm.io/package/flotiq-excel-migrator

## Dependencies (6)

- [yup](https://npm.io/package/yup.md) ^0.32.11
- [yargs](https://npm.io/package/yargs.md) ^18.0.0
- [node-fetch](https://npm.io/package/node-fetch.md) 2
- [@flotiq/api](https://npm.io/package/@flotiq/api.md) ^1.0.0
- [read-excel-file](https://npm.io/package/read-excel-file.md) ^9.0.9
- [write-excel-file](https://npm.io/package/write-excel-file.md) ^1.4.13

## Recent versions

- 1.1.1 (latest) — 2026-05-29
- 1.1.0 — 2026-05-29
- 1.0.17 — 2026-05-19
- 1.0.15 — 2023-04-06
- 1.0.13 — 2022-12-02
- 1.0.12 — 2022-12-02
- 1.0.11 — 2022-12-02
- 1.0.10 — 2022-12-02
- 1.0.9 — 2022-12-02
- 1.0.8 — 2022-12-02
- 1.0.7 — 2022-12-02
- 1.0.6 — 2022-12-02
- 1.0.5 — 2022-12-01
- 1.0.1 — 2022-12-01

## README

# Flotiq-Excel migrator

This module migrates Flotiq data to and from an xlsx file.
It was made solely for [flotiq-cli](https://github.com/flotiq/flotiq-cli). However, you can use it independently.

## Setup

Add this module to your project and import functions from flotiq-xlsx-migrate.js.

Run `yarn` to install packages.

## CLI

This package also provides a CLI command.

### Usage

```
flotiq-excel-migrator <command> [options]
```

Commands:
* `export` - export content objects to an XLSX file,
* `import` - import content objects from an XLSX file.

Required options:
* `--api-key <value>`
* `--ctd-name <value>`

Run help:

```
flotiq-excel-migrator --help
```

or:

```
flotiq-excel-migrator help
```

## Export

`exportXlsx` is the module's function for exporting Flotiq CTD and CO to the xlsx file.

### Usage

Call function exportXlsx with options object as an attribute, for example:

```
import { exportXlsx } from "flotiq-excel-migrator";

const exportOptions = {
    apiKey: "[Flotiq API Key]",
    ctdName: "[CTD API Name]"
}
const exportFromFlotiq = async () => {
  let result = await exportXlsx(exportOptions);
    console.log(result);
}
exportFromFlotiq();
```

Function returns the following information:
* FilePath
* Number of Content Objects for export
* Number of Content Objects successfully exported
* errors data

### Options parameters

Options object accepts the following parameters:
* apiKey - API key to your Flotiq account,
* ctdName - API name of Content Type Definition you wish to export,
* filePath (optional) - the directory to which the xlsx file is to be saved, the current directory by default,
* limit (optional) - Number of Content Objects you wish to export, exports up to 10 000 Content Objects by default,
* saveFile (optional) - boolean value determining whether to save the xlsx file in the directory, true by default. If the value is false, the function will return the parameter `data` with data from Flotiq converted for MS Excel,
* logResults (optional) - boolean value determining whether to type out results into the console, true by default.

### Notes

 * Exported CTD is saved as plain text of properties id's. No metadata is being exported.
 * `Max string length` for all values is set to 30.000 because MS Excel has trouble handling text with length > 30 000 in one cell.

### Result example

```
{
  directoryPath: '[_dirname]//test.xlsx',
  errors: null,
  coTotal: 3,
  co_success: 3
}
```

## Import

`importXlsx` is the module's function for importing an xlsx file to Flotiq.

### Usage

Call function exportXlsx with options object as an attribute, for example:

```
import { importXlsx } from "flotiq-excel-migrator";

const importOptions = {
    apiKey: "[Flotiq API Key]",
    ctdName: "[CTD API Name]",
    filePath: "[path to xlsx file]"
}
const importToFlotiq = async () => {
  let result = await importXlsx(importOptions);
    console.log(result);
}
importToFlotiq();
```

Function returns the following promise:
For every sheet in the workbook:
* Number of Content Objects successfully imported
* Number of errors in Content Object import
* errors data (object)

If options validation error occurs, the function will not return the number of errors and CO exported; instead, it will return information about the invalid options parameter.

### Options parameters

Options object accepts the following parameters:
* apiKey - API key to your Flotiq account,
* ctdName - API name of Content Type Definition you wish to export,
* filePath - the directory to the xlsx file you wish to import data from,
* limit (optional) - number of Content Objects you wish to import, imports up to 10 000 Content Objects by default,
* logResults (optional) - boolean value determining whether to type out results into the console, true by default.
* updateExisting (optional) - boolean value determining whether to update existing Content Objects, true by default.
* batchLimit (optional) - number of Content Objects imported per batch call, 100 by default.

### Notes

* valid XLSX file looks just like the one that exportXlsx saves. The first row on the sheet (header) should have the names of CTD's properties. Every following row is a separate Content Object, for example:

| id | name | age |
|--|--|--|
| person-1 | John | 30 |
| person-2 | Alex | 20 |

* importXlsx allows you to import many sheets from the same workbook. However, these sheets must be dedicated to the same CTD and have this CTD's properties in the header.
* Parameter LIMIT limits the number of Content Objects you will import from XLSX works individually for every sheet in the workbook.
* Cells with `null` values are ignored during import and are not sent in the payload to Flotiq.

### Result example

Notice that the import function gives different results for every sheet from your xlsx file, so to read result errors `result.[excel sheet name].sheetErrors`.

```
{
  Sheet1: {
    sheetImportedCoCount: 98,
    sheetErrorsCount: 2,
    sheetErrors: [ [Object] ]
  }
  Sheet2: {
    sheetImportedCoCount: 100,
    sheetErrorsCount: 0,
    sheetErrors: []
    }
}
```

## Data mapping

The form in which Flotiq data is exported to / imported from xlsx varies on property type:

| Flotiq field property | Form in which data is exported to xlsx |
|--|--|
| Text | Text |
| Textarea | Text |
| Markdown | Text (with markdown syntax) |
| Rich text | Text (with HTML tags) |
| Email | Text |
| Number | Number (with ms excel's default decimal separator) |
| Radio | Text |
| Checkbox | TRUE / FALSE |
| Select | Text |
| Relation | API Url's in the form of text, separated with commas, for example: `/api/v1/content/[ctdName]/[coName1],/api/v1/content/[ctdName]/[coName2]` |
| List | JSON |
| Geo | JSON |
| Media | API Url in form of text, separated with commas, for example: `/api/v1/content/_media/[mediaId1],/api/v1/content/_media/[mediaId2]` |
| Date time | Date |
| Block | JSON |

## Notes

 * `Max string length` for all values is set to 30.000 because MS Excel has trouble handling text with length > 30 000 in one cell.

---
_Source: https://npm.io/package/flotiq-excel-migrator · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._