# How to export data from multiple tables to CSV file in Business Central online? **URL:** \ **Category:** Developers Forum\ **Created:** [March 22, 2019, 2:29pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875 "2019-03-22T14:29:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![priyank014](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@priyank014](https://www.dynamicsuser.net/u/priyank014)\ **Post date:** [March 22, 2019, 2:29pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/1 "2019-03-22T14:29:44Z")
I want to export data from multiple tables into a CSV file. How can accomplish this in business central online? ---
**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\ **Post date:** [March 23, 2019, 9:02pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/2 "2019-03-23T21:02:28Z")
Depends one what you are exporting, from where to where. Business Central have many ways to handle export to CSV files. So what do you need? ---
**Author:** ![priyank014](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@priyank014](https://www.dynamicsuser.net/u/priyank014)\ **Post date:** [March 25, 2019, 9:52am UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/3 "2019-03-25T09:52:29Z")
I need to be able to export fields from Payment Journal and other related tables like Gen Journal line, Company information, Vendor bank account, Vendor etc. I need to generate a CSV file containing these fields. ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [March 25, 2019, 2:07pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/4 "2019-03-25T14:07:36Z")
did you use rapidstart packages/ configuration packages? ---
**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\ **Post date:** [March 25, 2019, 3:17pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/5 "2019-03-25T15:17:07Z")
> [@](#): > > I need to be able to export fields from Payment Journal and other related tables like Gen Journal line, Company information, Vendor bank account, Vendor etc. I need to generate a CSV file containing these fields In other words, you are creating a payment file? If that is the case, then you must look into the Data Exchange Framework. That’s what is already being used tor vendor payment exports. With DEF you can define your CSV formats via setup. The best way to learn how it works would be to check out the payment export data definitions that you find in Cronus (depends on localization). ---
**Author:** ![priyank014](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@priyank014](https://www.dynamicsuser.net/u/priyank014)\ **Post date:** [March 25, 2019, 4:31pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/6 "2019-03-25T16:31:27Z")
Yes Erik, I need to create a payment file in a format which is accepted by the bank. ---
**Author:** ![priyank014](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@priyank014](https://www.dynamicsuser.net/u/priyank014)\ **Post date:** [March 25, 2019, 4:32pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/7 "2019-03-25T16:32:15Z")
No, I haven’t used them yet. Can I use rapidstart with Business central online? ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [March 25, 2019, 5:14pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/8 "2019-03-25T17:14:14Z")
yes it is not possible to export payment file using rapidstart, you need to ue data exchange framework as suggested by Erik. if it is data import and export then rapidstart will work. ---
**Author:** ![priyank014](https://avatars.discourse-cdn.com/v4/letter/p/bcef8e/32.png) [@priyank014](https://www.dynamicsuser.net/u/priyank014)\ **Post date:** [March 26, 2019, 1:19pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/9 "2019-03-26T13:19:41Z")
I tried data exchange definition but we can’t use more than one source table with data exchange definition. Can we use more than one source tables with XML ports? ---
**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\ **Post date:** [March 29, 2019, 7:06pm UTC](https://www.dynamicsuser.net/t/how-to-export-data-from-multiple-tables-to-csv-file-in-business-central-online/66875/10 "2019-03-29T19:06:50Z")
That is not correct. You can use many source tables with data exchange definitions, otherwise for example then you could not use it for PEPPOL the European E-invoicing function, where you import/export sales invoices etc. And you always have the option of creating your customized, but that should not be required. > [@](#): > > I tried data exchange definition but we can’t use more than one source table with data exchange definition.