This app converts data from Google Spreadsheets into a client-side file or in-memory sqlite database.
This app only works locally without going through the server. It allows you to convert instantly Sheets to a sqlite database.
Supported Format to be converted: Google Sheets, xls, xlsx, xlt, xltx, xlsm, xltm, ods, csv, tsv How to use this app?
Open a Google Sheets or File -> Click "Get Structure" or Convert Excel files to Google Sheets -> Confirm or edit table/column name, data type -> Create Table -> Insert Data
"Sheet name" is replaced by "SQLite table name", and "First line in a sheet" is replaced by "SQLite column names".
Only alphabet, numbers, under-bar(_) are allowed in the table/column name.
Supported column data type : TEXT, INTEGER, REAL, NUMERIC, TIMESTAMP(INTEGER, this app converts string to unix timestamp automatically)
How to create autoincrement column: Select a "INTEGER and Primary Key" in a column option. This column should not contain any data.
ⓒ 2022, Convert Google Sheets to SQLite
To use this app, Please login to the Google Drive and authorize this app or website.
(Note: If your browser block or disable the third-party cookies, this login does not work correctly.)