How to export SQLite data to CSV file in Flutter app

Question

I am trying to achieve export to CSV from SQLite data of my Flutter app. I want to know an efficient way to achieve this.

chunhunghan · Accepted Answer · 2019-10-01 08:21:08Z

6

You can use https://github.com/tekartik/sqflite_more/tree/master/sqflite_porter

alextekartik comments in https://github.com/tekartik/sqflite/issues/78

csv utils detail code https://github.com/tekartik/sqflite_more/blob/master/sqflite_porter/lib/utils/csv_utils.dart

var result = await db.query('MyTable');
var csv = mapListToCsv(result);

answered Oct 1, 2019 at 8:21

chunhunghan

54.7k5 gold badges123 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Haroon khan Over a year ago

do you know a proper way of using sqflite_porter to export db to sql statements but I'm getting issues like below: No such table: sqlite_sequence in "SELECT * from sqlite_sequence"

Collectives™ on Stack Overflow

How to export SQLite data to CSV file in Flutter app

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related