Categories
Technology - Tips

How To Export SQLite Table Into CSV Or Excel File

How To Export SQLite Table Into CSV Or Excel File

In this tutorial we will learn How To Export SQLite Table Into CSV Or Excel File.For this we are using Firefox browser.In Firefox browser we have to install a Add-ons(SQLite Manager).

1. Open Mozilla Firefox Browser.

2. Click on Firefox Menu Dropdown on Top-Left.Click on Add-Ons.

3. Now search for SQLite, you we get results.On Results you will see Sqlite Manager, Install it.

1-28-2014 8-28-33 PM

4. Now Open SQLite manager, by going Menu > Web Developer > SQLite manager.

1-28-2014 8-32-21 PM

5. Now Select your table from left and click on Export button on right.

1-28-2014 8-36-39 PM

6. Now do some settings for data like, first row contains column names, fields separated by etc. and click on OK.This will prompt for file to save.Save your file and enjoy.

1-28-2014 8-37-30 PM