{"id":2196,"date":"2021-09-23T08:41:22","date_gmt":"2021-09-23T08:41:22","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2196"},"modified":"2021-09-23T08:41:22","modified_gmt":"2021-09-23T08:41:22","slug":"how-to-import-csv-files-in-the-database-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/","title":{"rendered":"How to import .csv files in the database from phpmyadmin"},"content":{"rendered":"<p>You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don&#8217;t save it as a workbook or the other format, check it with a text reader like notepad or similar. You&#8217;ll be able to see that every column is separated by a comma (,). this is often needed when we import the file with PHPmyAdmin. Please take away column headings, blank areas and make sure that there&#8217;s an entry of some kind in every row and column. the information within the table should represent identically within the CSV file. If your table has \u2018n\u2019 columns you need to have \u2018n\u2019 columns within the CSV file as well.<\/p>\n<h3>Follow the steps as given below in order to import .CSV file into database.<\/h3>\n<p>1. Using ftp Upload .csv file in public_html .<br \/>\n2. Access your phpmyadmin &gt;&gt; Choose database &gt;&gt; Click on SQL tab.<br \/>\n3. Type the SQL query as follow:<br \/>\nInto table city load data local in file \u2018Full path for .CSV file\u2019<\/p>\n<p>fields terminated by \u2018,\u2019<\/p>\n<p>enclosed by \u2018\u201d\u2018<\/p>\n<p>lines terminated by \u2018\\n\u2019<\/p>\n<p>Then actual full path should be replaced with \u201cFull path for .CSV file\u201d (\/home\/username\/public_html\/filename.csv)<\/p>\n<p>4. Then Click on Go.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don&#8217;t save it as a workbook or the other format, check it with a text reader like notepad or similar. You&#8217;ll be able to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-2196","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to import .csv files in the database from phpmyadmin - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to import .csv files in the database from phpmyadmin - OWS KB\" \/>\n<meta property=\"og:description\" content=\"You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don&#8217;t save it as a workbook or the other format, check it with a text reader like notepad or similar. You&#8217;ll be able to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OWN-WEB-SERVERS-107052961577434\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-23T08:41:22+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@OwnWebservers\" \/>\n<meta name=\"twitter:site\" content=\"@OwnWebservers\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#\\\/schema\\\/person\\\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"headline\":\"How to import .csv files in the database from phpmyadmin\",\"datePublished\":\"2021-09-23T08:41:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/\"},\"wordCount\":226,\"publisher\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#organization\"},\"articleSection\":[\"Web Hosting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/\",\"name\":\"How to import .csv files in the database from phpmyadmin - OWS KB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#website\"},\"datePublished\":\"2021-09-23T08:41:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/how-to-import-csv-files-in-the-database-from-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to import .csv files in the database from phpmyadmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/\",\"name\":\"OWS KB\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#organization\",\"name\":\"Own Web Servers\",\"url\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/OWS-Logo-with-punchline-front-scaled.png\",\"contentUrl\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/OWS-Logo-with-punchline-front-scaled.png\",\"width\":2560,\"height\":994,\"caption\":\"Own Web Servers\"},\"image\":{\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/OWN-WEB-SERVERS-107052961577434\",\"https:\\\/\\\/x.com\\\/OwnWebservers\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ownwebservers.com\\\/kb\\\/#\\\/schema\\\/person\\\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/ownwebservers.com\\\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to import .csv files in the database from phpmyadmin - OWS KB","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to import .csv files in the database from phpmyadmin - OWS KB","og_description":"You have to keep in mind few things to import successfully .csv files within the database from phpmyadmin. Make sure that you save your Excel file as a csv file. Please don&#8217;t save it as a workbook or the other format, check it with a text reader like notepad or similar. You&#8217;ll be able to [&hellip;]","og_url":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/","og_site_name":"OWS KB","article_publisher":"https:\/\/www.facebook.com\/OWN-WEB-SERVERS-107052961577434","article_published_time":"2021-09-23T08:41:22+00:00","author":"admin","twitter_card":"summary_large_image","twitter_creator":"@OwnWebservers","twitter_site":"@OwnWebservers","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/"},"author":{"name":"admin","@id":"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2"},"headline":"How to import .csv files in the database from phpmyadmin","datePublished":"2021-09-23T08:41:22+00:00","mainEntityOfPage":{"@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/"},"wordCount":226,"publisher":{"@id":"https:\/\/ownwebservers.com\/kb\/#organization"},"articleSection":["Web Hosting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/","url":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/","name":"How to import .csv files in the database from phpmyadmin - OWS KB","isPartOf":{"@id":"https:\/\/ownwebservers.com\/kb\/#website"},"datePublished":"2021-09-23T08:41:22+00:00","breadcrumb":{"@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ownwebservers.com\/kb\/how-to-import-csv-files-in-the-database-from-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ownwebservers.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to import .csv files in the database from phpmyadmin"}]},{"@type":"WebSite","@id":"https:\/\/ownwebservers.com\/kb\/#website","url":"https:\/\/ownwebservers.com\/kb\/","name":"OWS KB","description":"","publisher":{"@id":"https:\/\/ownwebservers.com\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ownwebservers.com\/kb\/#organization","name":"Own Web Servers","url":"https:\/\/ownwebservers.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ownwebservers.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2026\/07\/OWS-Logo-with-punchline-front-scaled.png","contentUrl":"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2026\/07\/OWS-Logo-with-punchline-front-scaled.png","width":2560,"height":994,"caption":"Own Web Servers"},"image":{"@id":"https:\/\/ownwebservers.com\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OWN-WEB-SERVERS-107052961577434","https:\/\/x.com\/OwnWebservers"]},{"@type":"Person","@id":"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/ownwebservers.com\/kb"]}]}},"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2196"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2196\/revisions"}],"predecessor-version":[{"id":2197,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2196\/revisions\/2197"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}