{"id":1497,"date":"2017-04-23T11:18:13","date_gmt":"2017-04-23T09:18:13","guid":{"rendered":"http:\/\/www.ybierling.com\/v2\/?p=1497"},"modified":"2018-05-31T12:55:41","modified_gmt":"2018-05-31T10:55:41","slug":"how-to-import-an-excel-file-in-a-mysql-database-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.ybierling.com\/v2\/en\/how-to-import-an-excel-file-in-a-mysql-database-in-phpmyadmin\/","title":{"rendered":"How to import an Excel file in a MySQL database in PHPMyAdmin"},"content":{"rendered":"

It is sometimes easier to work on some data in Excel<\/a><\/strong>, before importing in a MySQL<\/a><\/strong> database.<\/p>\n

In order to do so, here are a few simple steps.<\/p>\n

In short : export the Excel<\/strong> file to CSV<\/strong>, and import<\/a> the CSV<\/strong> in a new table using the PHPMyAdmin<\/a><\/strong> interface.<\/p>\n

Starting with an Excel<\/strong>, in below example one sheet containing some data<\/p>\n

\n
\"How<\/a>
Excel sheet with data<\/figcaption><\/figure><\/blockquote>\n

Select Save As<\/a><\/em> to be able to select another format<\/p>\n

\n
\"How<\/a>
Excel option Save as<\/figcaption><\/figure><\/blockquote>\n

Scroll down to the CSV (Comma delimited) (*.csv)<\/em> format<\/p>\n

\n
\"How<\/a>
Finding the CSV comma separated format<\/figcaption><\/figure><\/blockquote>\n

Confirm that some features will be lost – CSV<\/strong> being a text format, no Excel<\/strong> specifics will be exported (functions, programs, …)<\/p>\n

\n
\"How<\/a>
Confirm the loss of Excel specific functions<\/figcaption><\/figure><\/blockquote>\n

In PHPMyAdmin<\/strong>, go to the Import<\/em> menu<\/p>\n

\n
\"How<\/a>
Import menu in PHPMyAdmin<\/figcaption><\/figure><\/blockquote>\n

Browse for the CSV<\/strong> file recently saved, and select the appropriate format<\/p>\n

\n
\"How<\/a>
Browse for local file and select appropriate CSV format<\/figcaption><\/figure><\/blockquote>\n

Look for other options that might apply, for example, if columns have names, check the corresponding option “The first line of the file contains the table column names<\/em>“, and click Go<\/em><\/p>\n

\n
\"How<\/a>
CSV import specific options<\/figcaption><\/figure><\/blockquote>\n

Import confirmation should be displayed, and links to the resulting database and table will be shown<\/p>\n

\n
\"How<\/a>
Import results with links to database and table<\/figcaption><\/figure><\/blockquote>\n

It is now possible to browse through the table !<\/p>\n

\n
\"How<\/a>
Database display<\/figcaption><\/figure><\/blockquote>\n

Using the diverse options, it is also possible to work on the table structure, content, or to move it to another database<\/p>\n

\n
\"How<\/a>
Database structure<\/figcaption><\/figure><\/blockquote>\n

More Excel tutorials<\/h3>\n

40 Life-Changing Excel Tutorials – digital.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

It is sometimes easier to work on some data in Excel, before importing in a MySQL database. In order to<\/p>\n","protected":false},"author":1,"featured_media":1505,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[576],"tags":[709,770,499,33,303,5683,1928,5691,5685,5687,620,1357,624,892,2036,1042,618,5689],"class_list":["post-1497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web","tag-content","tag-data","tag-database","tag-en","tag-excel","tag-how-to-import-an-excel-file-in-a-mysql-database-in-phpmyadmin","tag-import","tag-import-excel-file-in-mysql","tag-import-excel-in-mysql","tag-import-excel-in-phpmyadmin","tag-mysql","tag-option","tag-phpmyadmin","tag-sheet","tag-structure","tag-table","tag-web","tag-worksheet"],"_links":{"self":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/1497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/comments?post=1497"}],"version-history":[{"count":3,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":2266,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/posts\/1497\/revisions\/2266"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/media\/1505"}],"wp:attachment":[{"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/media?parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/categories?post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ybierling.com\/v2\/wp-json\/wp\/v2\/tags?post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}