Import csv and create table at once on sequel pro

If you have a csv file, you can easily import the csv and create a table in mysql using Sequel Pro.

As usual, choose File > Import

Choose a csv file

And click on the “New” button to create a new table based on the file structure.

Screen Shot 2014-01-14 at 3.01.16 PM

2 thoughts on “Import csv and create table at once on sequel pro

  1. SB

    As soon as I click the New button all the fields appear as expected in the window correctly mapped ready for Import, but the Import button becomes greyed out so that I cannot proceed. What’s going on?

  2. invtr Post author

    Maybe there are some fields not correctly matched. Or some field names consist of empty space.
    Anyway the issue must be due to some errors on the field names

Leave a Reply

Your email address will not be published. Required fields are marked *