Home Dev Guides Databases How to Import Excel file into SQLite DB with SQLite Manager

How to Import Excel file into SQLite DB with SQLite Manager

1

excel-sqlitedb

Let’s say you’ve successfully created your SQLite database contents in Excel. The next logical step will be to import the table back to your SQLite database file. Here’s the easiest and most efficient way to do it.

How to Import CSV or Excel file into SQLite

1. Open the file you plan on importing in Excel and Save As CSV (Comma delimited). 

2

2. Open SQLite Manager and load your database.

1

3. Go to Database > Import and select the file you previously converted into CSV.

3

4. Load the CSV file, and write the name of the table you want to import to. Tick First row contains column names and separate the fields by comma.

4

5. Hit OK and confirm the operation one more time.

5

6. If you see this message the operation completed successfully.

6

7. Check whether your imported table displays correctly.

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)

LEAVE YOUR COMMENT

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

Powered by WordPress