DEV Community

ryjfgjl
ryjfgjl

Posted on

How to import excel into sqlite only 1 step

In our work, we often need to import Excel data into SQLite for data analysis and processing. Usually we use database tools like Navicat or the Excel import function in the editor that comes with the database to manually import it. However, it is not easy for both professional and non-professional data processing personnel to correctly import an Excel file into a database.
Now, through years of practice, we have solved various problems through the DiLu Converter tool, achieving one-click import of Excel into the SQLite .

DiLu Converter is an automated tool that can import Excel files into a database in bulk.
Support for 6 common formats of Excel files (xls/xlsx/xlsm/xlsb/csv/txt) and 8 database types (mysql/oracle/sql server/postgresql/access/hive/sqlite/dameng).
Let's take an example of importing a product information table into a SQLite database.

DiLu Converter

Now, we can import it to the database with 1 step through the DiLu Converter tool.

Create a new database connection

Click on the toolbar (New Connection) to select your database type. Here, we will use SQLite as an example. To create other database connections, please refer to the DiLu Converter New Database Connection Guide.

DiLu Converter

DiLu Converter

Add a configuration

DiLu Converter

1 Step to import: Select the file to import and click "Start"

DiLu Converter

Finally, enter the database editor to view the import results

DiLu Converter

Introduction and Download of DiLu Converter

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

Billboard image

Try REST API Generation for MS SQL Server.

DreamFactory generates live REST APIs from database schemas with standardized endpoints for tables, views, and procedures in OpenAPI format. We support on-prem deployment with firewall security and include RBAC for secure, granular security controls.

See more!

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay