Use the import or export wizard to help you to import or extract any data into or from your application
The import wizard allows to import a lot of data from any external application from a CSV or Excel file. Make your import in Insert or Update mode.
The export wizard allows you to export any data of application in a CSV or Excel file.
Export
Use the wizard to export any data in several steps:
- Choose the data to export among a list of predefined export profiles.
- Define which field you want to export.
- Define your filters and position of fields.
- Save your export profile so you can remake the export later at any time in few clicks.
- Build and download the exported file.
![](/www.dolibarr.org/medias/image/www.dolibarr.org/images/doc_import_home.png)
Save your export profiles to be able to redo the same export later, in one click.
![](/www.dolibarr.org/medias/image/www.dolibarr.org/images/doc_import_profile.png)
Import
Use the import wizard to load or update data in your database.
Import from any CSV or Excel files. You can get a predefined empty source files, but any source file can be used.
![](/www.dolibarr.org/medias/image/www.dolibarr.org/images/doc_import_exemple.png)
Make a mapping between fields in your source file and Dolibarr fields, so you can import files with any format, or reuse a previously saved import profiles to save your time if you need to make frequently the same import / update.
![](/www.dolibarr.org/medias/image/www.dolibarr.org/images/doc_import_arrange.png)
Run the simulator so you can know result of import with no data change. Once the simulation is successful, you can run the real import.
![](/www.dolibarr.org/medias/image/www.dolibarr.org/images/doc_import_simulation.png)