Android Tutorial MySQL: Load Excel Sheets (or other data) via .csv

Nice & easy: http://www.mysqltutorial.org/import-csv-file-mysql-table/

So you can import Excel sheets by saving as *.csv before or if you have files, just put some delimiters between it.

 

[manhof]

This works also with sqlite?

 

[KMatle]

This works also with sqlite

If you have a shell where you can use sqlite commands it's similar. On Android it can be done by generating insert commands

It's all about reading the *.csv each line and generate the insert commands. Stringutils.LoadCSV might help to read it into a list.