Welcome to Geeklog, Anonymous Thursday, July 17 2025 @ 02:57 pm EDT
Geeklog Forums
Useful tool - CSV to MySQL
Page navigation
Status: offline
Forum User
Junior
Registered: 10/18/06
Posts: 21

You may have covered this elsewhere but I couldn't find it.
I had spreadsheets set up in Excel that I wanted to use as the basis for content in the Contacts plug in. After hours messing about getting the data into the right format (all columns identical to the table headings) I then found that it would not let me import the CSV file into my database.
I searched for ages to find something to import CSV into MySQL, then stumbled across here - it picks up your csv file off your computer and quickly translates it into MySQL (save as a .txt file) so that you can then run the MySQL command into your database.
This may be of use to someone.
Anon
I had spreadsheets set up in Excel that I wanted to use as the basis for content in the Contacts plug in. After hours messing about getting the data into the right format (all columns identical to the table headings) I then found that it would not let me import the CSV file into my database.
I searched for ages to find something to import CSV into MySQL, then stumbled across here - it picks up your csv file off your computer and quickly translates it into MySQL (save as a .txt file) so that you can then run the MySQL command into your database.
This may be of use to someone.
Anon
78
38
Quote
Thanks for that! Saved me a bunch of work.
48
40
Quote
Thank you for your time and trouble .
Should have looked for this earlier. I have been trying to import a CSV for the last 6 hrs :banghead:
Should have looked for this earlier. I have been trying to import a CSV for the last 6 hrs :banghead:
40
42
Quote
Great! Thanks :chestslam:
Good topic name, easy to found on google
Regards!
Good topic name, easy to found on google

Regards!
42
46
Quote
DUUUUDE :banana:
THANKS A LOT>.. can;t belive how usefull this was.
Congrats for the post... i'll ship you a 6pack of beer
THANKS A LOT>.. can;t belive how usefull this was.
Congrats for the post... i'll ship you a 6pack of beer

37
51
Quote
Thank you so much! Awesome find, saved me a ton of time!
47
45
Quote
Hi,
Thanks a lot.
It rescued me from long sleepless nights.
thanks a lot for sharing.
34
43
Quote
any other "csv2mysql" or "xls2mysql" freeware-tool that you know of?
my file is larger than 2MB
thx
my file is larger than 2MB
thx
53
42
Quote
Status: offline
Forum User
Newbie
Registered: 11/21/09
Posts: 1
I use for such cases software called BK ReplaceEM. It can replace some part of the text by another parts. Sure, if you found something special which converts CSV to MySQL it is better, however, many people often need similar changes and it may be easier to do it with such software than spending a lot of time by searching for something special.
41
37
Quote
Holy crap that is awesome. saved me soooo much time.
BTW captcha on this site SUCKS. makes some better images.
BTW captcha on this site SUCKS. makes some better images.
56
34
Quote
Thanks mate :-)
You're post came right on top off google :-)
You're post came right on top off google :-)
33
45
Quote
very very thanks.
Anon.
You done a great thing.
Anon.
You done a great thing.
43
39
Quote
Dear
another good tool for Excel7CSV import is http://www.dbTube.org
You can draw your import definition online with an workflow
editor. The generated improt definition can be used for your further
imports.
greetings
Andreas
another good tool for Excel7CSV import is http://www.dbTube.org
You can draw your import definition online with an workflow
editor. The generated improt definition can be used for your further
imports.
greetings
Andreas
43
36
Quote
http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server/
35
43
Quote
Nice! Couple more methods: http://giantdorks.org/alain/export-mysql-data-into-csv-or-psv-files/
42
50
Quote
Hmm, let's see if I can get a link going: Export (and Import) MySQL data into CSV or PSV files
:banghead:
41
46
Quote
Please send me the correct link for your post so that I can use it.
I have also the same problem. Thanx
I have also the same problem. Thanx
53
36
Quote
mysql dbu is closed.
Any other alternative ?
Any other alternative ?
37
46
Quote
You might try this link. There are a number of links to real software to suit this conversion requirement.
http://mysql-import-multiple-text-files-softwar.software.informer.com/
Often these sites are dynamic in nature so there's no guarantee as to how long the link will work.
http://mysql-import-multiple-text-files-softwar.software.informer.com/
Often these sites are dynamic in nature so there's no guarantee as to how long the link will work.
38
41
Quote
If you have access to the data folder a simple alternative is to make a table of type CSV. (normally you have isam or innodb). Instantly you have the csv file in the folder. Just copy your data into it and its available in mysql or insert data into it using mysql and you have it in csv formt.
hope this helps,
hope this helps,
33
37
Quote
Page navigation
All times are EDT. The time is now 02:57 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content