# Export a database from the SaaS (and import it for another workspace or account)
**URL:** https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621
**Category:** Tips&Tricks
**Tags:** api, opensource, n8n
**Created:** [October 22, 2023, 4:12pm UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621 "2023-10-22T16:12:10Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [October 22, 2023, 4:12pm UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/1 "2023-10-22T16:12:10Z")
Baserow is a great platform.
But one of my frustrations from time to time is that it is not possible to create a template database and pass it to other users. A scenario that is very common when using Baserow to teach database and API basics.
Luckily, Baserow is a great platform with a [well-documented API](https://api.baserow.io/api/redoc/) that makes almost everything possible.
So, I started this weekend project and created an automation with n8n that makes it possible to export an entire database with structure, views and data from the SaaS platform in a JSON format. The front-end was build with Appsmith.
You can test it [here](https://app.appsmith.com/app/import-export-baserow/home-6533ac8d517d1f5679b748e8).
- Step 1: click the Authenticate Baserow account button and fill in your credentials to get an access token. You can also generate a token yourself and paste it in the textfield if you do not like to enter your credentials in an external tool (I do not save any data)
- Step 2: select the database from the list
- Step 3: click the export button and the download starts once the automation has completed.
Next step is to implement the import process. At this moment, I can already create a new database and the tables, but I am having some problems with creating the fields since Baserow automatically creates 3 fields when generating a new table. So, I need some time to figure this out. I also expect that linked records will cause some challenges, but I feel pretty confident it will work in the end.
I like to keep this project open source:
- Check the Appsmith application on Githhub: [GitHub - basicity/import-export-baserow: A tool for exporting Baserow bases from the SaaS platform and importing them in a different workspace or account](https://github.com/basicity/import-export-baserow)
- The repo also contains an export of the [n8n automation](https://github.com/basicity/import-export-baserow/blob/main/export_baserow_templates.json)
---
### Author:  [@Peter](https://community.baserow.io/u/Peter)
#### Post date: [October 23, 2023, 4:23am UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/2 "2023-10-23T04:23:23Z")
This is really great work đź‘Ź
---
### Author:  [@marcus](https://community.baserow.io/u/marcus)
#### Post date: [October 23, 2023, 7:27pm UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/3 "2023-10-23T19:27:24Z")
Would there be (exist) some tutorial or tool for us (non-technical people) to export (and later import again) the whole baserow database self-hosted in a Synology NAS docker?
---
### Author:  [@joseph\_appsmith](https://community.baserow.io/u/joseph_appsmith)
#### Post date: [October 29, 2023, 3:00pm UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/4 "2023-10-29T15:00:01Z")
Great work @frederikdc ! I like how you’ve implemented the auth with different options for the JWT.
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [November 3, 2023, 11:30am UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/5 "2023-11-03T11:30:22Z")
Update: you should be able to import the data structure and data from an exported database.
The views are a work in progress
---
### Author:  [@star26bsd](https://community.baserow.io/u/star26bsd)
#### Post date: [October 10, 2024, 11:44am UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/6 "2024-10-10T11:44:09Z")
Hi! Is your tool still working? Just tried to export, then the “Download Database” button is quickly spinning but no actual download seems to be initiated. Thanks for the update! 👍
Cheers
Stephan
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [October 10, 2024, 4:58pm UTC](https://community.baserow.io/t/export-a-database-from-the-saas-and-import-it-for-another-workspace-or-account/3621/7 "2024-10-10T16:58:44Z")
Hi,
I am afraid that the tool is obsoleted since it haven’t been updated for about a year. But the good news is that the 1.29 version of Baserow will allow you to export and import workspaces (and therefore also databases)