notion-database-exporter
This tool exports Notion's database in csv format.
Usage (node/npm)
The supported node version is 16.15. Other versions have not been tested.
- Install command.
npm i -g notion-database-exporter
- Add Notion Integration from the following page.
https://www.notion.so/my-integrations
- Copy the token
- Open the page containing the database (even the parent page), click the Share button in the upper right corner, and then click the Invite button.
- Select the integration you just created.
- Create
notion-db-exporter-secret.yml
in the folder where you run the command and write the token you just copied.
notionToken: XXXX
- The following command will output CSV to the
notion-db-csv
folder.
notion-database-exporter --export
You can also only display a list of databases.
notion-database-exporter --list
Command Options
option | description | default |
---|---|---|
-c , --config
|
Specify the path to the configuration file | ./notion-db-exporter.yml |
-s , --secret
|
Specify the path to the secret file | ./notion-db-exporter-secret.yml |
-l , --list
|
display a list of databases | true |
-e , --export
|
export databases | false |
Configuration
You can change the settings by placing notion-db-exporter.yml
in the folder where you run the command.
# Output directory.
outDir: './notion-db-csv'
# if want to filter database by title or id so enable below
#includes:
# - title: "Your Database Title1"
# - title: "Your Database Title2"
# - id: "Your Database id1"
# - id: "Your Database id2"
#excludes:
# - title: "Your Database Title1"
# - id: "Your Database id1"
For development
Build
npm run build
# or
npm run watch
Run
dist/main.js
Run tests
npm run test
Build container
docker build --tag example-container .
Run container
docker run example-container example
Release new version
Update all packages
npm install -g npm-check-updates
ncu -u
npm install
# Check
npm run test
npm run build
node dist/main.js