Home Dev Guides Databases How to Convert SQLite Database to Excel with SQLite manager

How to Convert SQLite Database to Excel with SQLite manager

1

SQLITE-EXCEL

SQLite Manager is a free Firefox plug-in, perfect for managing small data system that lay at the core of your applications or websites. This post will show you how to convert an SQLite database table to an excel file.

This will make it easier to edit the content of your database tables, prior to importing them back to your database. See the full guide along with screenshots down below.

How to export an SQLite file into Excel

1. Open Firefox SQLite manager and load the database.

1

2.  Go to View and select Export View.

2

3. This should bring up a new tab called Export Wizard. As you can see, no view is selected for export yet. We are going to select one in the next step. Select the CSV tab.

3

4. Next, right-click on the table in the left section of the screen and hit Export Table.

4

5. With the table selected, tick the First row contains column names and separate the fields by Tab. Hit OK to export.

Untitled

6. Prior to hitting Save, make sure you modify the extension from .csv to .xls.

6

7. Open the file you saved with Excel and hit Yes to the first prompt.

5

8. Edit your database easily in Excel.

7

Denis Madroane App junkie, Android developer, proud Freelancer. Passionate about app development and blogging, updated with the new stuff. Likes to think that he's versed in app re-skinning, content writing and social media.

Comment(1)

  1. Really great article. The way you describes the whole thing is really appreciable. Thanks for sharing such an informative article. Looking for same type of great articles in near future. Great Job 🙂

LEAVE YOUR COMMENT

Your email address will not be published. Required fields are marked *

Powered by WordPress