Sunday, January 20, 2013

export sqlite to excel


Export sqlite db to excel:


Open Sqlitedatabrowser
File open database- select ur db file
After it is opened
Go to file – export – table as csv file




Export table as csv file

Select table name –click Export
Open excel
Goto file - Open

Select -All files in the right side and choose ur file
Then select Delimited

Next –
Select Comma also as delimiter



Next

Finish
Now you can see the db fields in excel sheet
Now go to file – save as – excel
Thus your db is converted to excel.

No comments:

Post a Comment