Will Grant

User Experience Consultant & Author with over 20 years experience delivering powerful web & mobile products that have reached over a billion users.

Convert Microsoft Excel files into SQL databases

If you've ever needed to migrate data from a 'flat file' format into a relational database, you'll wish you already knew about 'sqlizer'.

sqlizer.io is a web-based tool that takes a file (Excel xlsx, comma-separated, tab-separated, XML or JSON) - automatically determines the structure - then generates an SQL script, complete with table definitions and insert statements.

It's free for personal use (up to 5,000 rows of data) and there's a $10 paid subscription that gives you unlimited usage (if you do this kind of thing a lot).