Home Dev Guides Databases How to Import Google Sheets into SQLite Database

How to Import Google Sheets into SQLite Database

0

googlesheets-sqlite

Let’s say you’re building a new app. If you worked on your app database using Google Spreadsheets, you’re probably looking for an easy way to efficiently export to an SQLite database without too much of a hassle. This post will guide you through it!

How to Import Google SpreadSheets into SQLite Database

1. Download and install SQLite Expert software.

2. Open the Google Sheet file that you want to be imported into SQLite Database.

3. Go to File> Download as and select Tab-separated values.

7

4. Open the SQLite Expert software, find the Import/Export tab and select Import text file.

5

5.  Load the file you want to be imported under the Source tab. Make sure the Delimiter is set to Tab. Depending on your goals, you may choose to import into a New table or insert into an Existing table. If you want to override you existing database, tick Delete existing data.

8

Note:  If your excel file contains file names on the first row, make sure to tick Field names on first row under Options.

6

6. That’s All! Your Google Sheet file is successfully imported to an SQLite Database.

9

 

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.

LEAVE YOUR COMMENT

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

Powered by WordPress