CSV import + data cleanup wizard

[joepio]

The problem

We have a table editor that is great for manual data creation and lots of ways to use that data, but importing tabular data is a different ballgame. We have support for copy / paste from Excel (using HTML tables in the background), but thats not perfect:

• Data can be lost if fields are not compatible
• Requires users to model the data before pasting it
• Difficult to use for large amounts of data

CSV importer

We should make a tool that:

• Imports a CSV file
• Recognizes column names
• Detects data types
• Shows a UI to make changes
• Walks over data
• Fixes issues / asks user for input on how to fix issues