Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an issue with importing .xls file into SQLite database. I am working on windows xp and using a SQLite manager for maintain the database. I can import the .csv file to the database by using availabel options in menu bar but I can't import the .xls file into this. I want to directly import the .xls file without converting into .csv file.

If I use the .csv file for import the data then it doesn't give the proper output due to comma separation.

Is there any way to import like this? Please give me the proper solution

I already googled but no solution I got.

share|improve this question
You could save it as a csv (or use a tool to that) and do [this][1] [1]:… – Rohan Jun 11 '13 at 11:16
Rohan@: I already checked that link and I maintioned that I want to directly import from .xls file – Ghost Answer Jun 11 '13 at 11:26
you can first convert it to a csv (using a tool like this one…) and then import the csv.. I don't think there is a direct way.. – Rohan Jun 11 '13 at 12:14

1 Answer 1

This online tool can convert from xls or xlsx to SQLite:

Full Disclosure: I wrote it - hope it helps!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.