Our great sponsors
-
CSVLint
CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
I think the least time consuming way to import a CSV file is using the CSV Lint plug-in for Notepad++. It automatically detects the columns and datatpes, and can simply convert the CSV data into an SQL insert script, including a CREATE TABLE part with the correct datatypes.