[mkayokay]

For CSV files you can also import them directly into a SQLite file using https://sqlitebrowser.org/

XLSX would be the same workflow with "save as" CSV and then push it into SQLite.

[shubhamjain]

IIRC, SQLlite requires you to define a schema first, which can be a bit tedious. DuckDB is actually a better tool for this in every regard, since it can parse CSV files quite well. The latest version includes support for XLSX as well.

My personal take is, yes, it's possible in multiple other ways, but I just like having a well-designed GUI app do it for me. Just how TablePlus does for Database Management.

[bob1029]

> I just like having a well-designed GUI app do it for me.

MSSQL/SSMS supports this with some fancy techniques.

> This wizard was created to improve the current import experience leveraging an intelligent framework known as Program Synthesis using Examples (PROSE). For a user without specialized domain knowledge, importing data can often be a complex, error prone, and tedious task. This wizard streamlines the import process as simple as selecting an input file and unique table name, and the PROSE framework handles the rest.

> PROSE analyzes data patterns in your input file to infer column names, types, delimiters, and more. This framework learns the structure of the file and does all of the hard work so users don't have to.

https://learn.microsoft.com/en-us/sql/relational-databases/i...

[account-5]

You can import CSV files into sqlite without a schema, and you can turn of the ability to auto guess a columns data type if needed.