How to Create a Database, Add Tables and Import Data in MySQL Workbench

Рет қаралды 593,681

4 жыл бұрын

#mysql #workbench #database
alphabench.com/data/mysql-cre...
Please SUBSCRIBE:
kzfaq.info_...
Get up and running quickly with MySQL Workbench how to import csv files. How to create tables directly from Excel files. Video tutorial demonstrating database creation, table definition and importing data in MySQL
Link to Data file(data.csv): github.com/mjmacarty/mysql.git
#mysql #workbench #database

Пікірлер: 367

@markward8483 2 жыл бұрын

Thanks Matt, great tutorial easy to follow. All what I needed to learn for my course! Love KZfaq, just keeps giving!

@MattMacarty 2 жыл бұрын

Glad it helped

@banjoomotola8583 3 жыл бұрын

This was so useful to my learning. So happy I found this. Great job!

@MattMacarty 3 жыл бұрын

Glad it was helpful!

@simonadong4512 2 жыл бұрын

This is SUPER HELPFUL thank you!! I glanced through so many articles which all made no sense to me...but this video is so on point

@MattMacarty 2 жыл бұрын

Thank you. Glad it helped

@benlall215 2 жыл бұрын

This was extremely helpful. Thank you! All the other videos say its for beginners and then fail to explain the most rudimentary steps... Thank you!

@MattMacarty 2 жыл бұрын

Thank you. Glad it helped.

@Bella_Noches_ 9 ай бұрын

WOW! This video is absolutely awesome! Never had such clear instructions on using the MySQL workbench and you helped me avoid a headache for my homework assignment. Your instructions worked like a charm!!

@MattMacarty 9 ай бұрын

Glad it helped

@BellTollsForThee 2 жыл бұрын

This tutorial is amazing! Thank you a bunch! I loved the explanation of issues with data types!

@MattMacarty 2 жыл бұрын

Thank you. Glad it helped.

@emekaukwuoma3359 3 жыл бұрын

Thanks Matt, this was super explanatory. I can create a database table thanks to you.

@MattMacarty 3 жыл бұрын

Glad it helped!

@maverickpeck6012 3 жыл бұрын

This is extremely helpful, just doing an intro database design class and this video helped me a ton!

@MattMacarty 3 жыл бұрын

Thanks. Glad it helped.

@ashleybattiata8912 10 ай бұрын

I feel like I've learned more in this video than all semester. You rock!

@MattMacarty 10 ай бұрын

Glad it helped

@kothon1 3 жыл бұрын

Dude, your tutorial is just so simple to understand. Thank you!!!

@MattMacarty 3 жыл бұрын

Glad it helped!

@nitinkymar9468 2 жыл бұрын

One of the best tutorial on mysql. Thank you very much!!

@MattMacarty 2 жыл бұрын

Thank you. Glad it helped.

@mikaeluhl 3 жыл бұрын

Thanks! i had to import a csv that my teacher made and i was struggling with the 'date' situation.. his file had the year coming last and i was using date :P when you explained that years in date should come first you gave me the answer i couldn't find after hours of search

@MattMacarty 3 жыл бұрын

Glad it helped!

@Skjoldr16 10 ай бұрын

Hi Matt, thanks so much for the clear and beginner-friendly tutorial, this definitely helped me a lot.

@MattMacarty 10 ай бұрын

Glad it helped

@derelictmanchester8745 Жыл бұрын

Thanks, Matt, really clear and concise..

@MattMacarty Жыл бұрын

Glad it helped

@oyewoleayorinde7864 11 ай бұрын

This is one of the best tutorials on this subject matter. Thanks so much

@MattMacarty 11 ай бұрын

Thank you. Glad it helped

@jonlbs7 3 жыл бұрын

Best tutorial I've seen .. Thank you !! ✨✨👍😊

@MattMacarty 3 жыл бұрын

Thanks very much. Glad it helped.

@browngift3408 2 жыл бұрын

You are a life saver Matt. Thanks so much

@MattMacarty 2 жыл бұрын

Glad it helped

@waxtin48 2 жыл бұрын

This is exactly what I needed thanks a million

@MattMacarty 2 жыл бұрын

Glad it helped

@Cpeters0 Жыл бұрын

Very easy to follow and understand... 2 thumbs up!!

@MattMacarty Жыл бұрын

Glad it helped

@mariaalejandraperpinanbarr3535 3 жыл бұрын

Thaaanks! One of the best tutorials I've seen

@MattMacarty 3 жыл бұрын

Thanks very much. Glad it helped.

@ThuHuongHaThi 3 жыл бұрын

Thanks a lot, I have been in trouble with it for so long

@MattMacarty 3 жыл бұрын

Glad it helped

@keithlamontdavis8047 Жыл бұрын

Well done. Very useful and very clearly explained. Newly subbed!

@MattMacarty Жыл бұрын

Thank you. Glad it helped

@daniel3897 3 жыл бұрын

Great tutorial. Thanks a lot Matt!!

@MattMacarty 3 жыл бұрын

Than kyou. Glad it helped.

@felipecruz3061 11 ай бұрын

I am so glad i found this video... amazing. Thank you buddy

@MattMacarty 11 ай бұрын

Glad it helped

@reeseverschelde758 Жыл бұрын

Incredibly helpful video, thank you.

@MattMacarty Жыл бұрын

Glad it helped

@lugonzales8980 Жыл бұрын

Thank you for making this easy!

@MattMacarty Жыл бұрын

Glad it helped

@casperj4784 3 жыл бұрын

Thank you very much for this video. I'll have a look at your others, but I'd be interested to know how to import data that needs to be separated into different tables.

@MattMacarty 3 жыл бұрын

There are a couple of options. You could import it all at once and then separate into tables or just import one on by one and add relationships when you have imported everything.

@lukewilliams4758 3 жыл бұрын

thanks for teaching us what you know I can finally make my website

@MattMacarty 3 жыл бұрын

Glad it helped

@rriimt1556 2 жыл бұрын

Excellent tutorial to learn database....thankyou very much sir..

@MattMacarty 2 жыл бұрын

Thanks. Glad it helped

@BabaYAGA_OW Жыл бұрын

Thanks man! Really good tutorial

@MattMacarty Жыл бұрын

Glad it helped

@marcelojunior4301 3 жыл бұрын

Thank you so much for this!

@MattMacarty 3 жыл бұрын

Glad it helped.

@surgiokilla1011 3 жыл бұрын

Great tutorial. Thanks!

@MattMacarty 3 жыл бұрын

Glad it helped.

@jayshree144 3 жыл бұрын

very helpful in importing an excel file. thankyou

@MattMacarty 3 жыл бұрын

Glad it helped

@greenblue980 3 ай бұрын

thanks alot! i forgot about that lightning thing 😂

@MattMacarty 3 ай бұрын

Glad it helped

@the9263 Жыл бұрын

This is amazing. I'm following here with my laptop haha

@MattMacarty Жыл бұрын

Nice. Glad it helped

@jayanthim2039 3 жыл бұрын

Nice explaination, and very understandable... Thank you bro..

@MattMacarty 3 жыл бұрын

Glad it helped

@fact4education 2 жыл бұрын

Thank you!

@MattMacarty 2 жыл бұрын

Glad it helped

@leniorrb 3 жыл бұрын

Very helpfull! Great tutorial.

@MattMacarty 3 жыл бұрын

Glad it helped

@mansitomar8549 Жыл бұрын

great great great video.........

@MattMacarty Жыл бұрын

Thank you. Glad it helped.

@Bakemono10 Жыл бұрын

Life Saver tutorial!!!

@MattMacarty Жыл бұрын

Glad it helped

@mannahidruhidru812 2 жыл бұрын

thank you so much you are just amazing, perfect explanation

@MattMacarty 2 жыл бұрын

Glad it helped

@MattMacarty 2 жыл бұрын

Glad it helped

@augustusprime0_o 2 жыл бұрын

great tutorial, thanks!

@MattMacarty 2 жыл бұрын

Glad it helped

@adrijesus1981 3 жыл бұрын

Oh God, you have a database called "Frodo"! Cool :-D

@MattMacarty 3 жыл бұрын

Yes it's not my server, but yes a friend for sure.

@ayanchakraborty76 11 ай бұрын

Samwise was not wise 😂

@armelmahunan851 3 жыл бұрын

Thank you so much. You save me

@MattMacarty 3 жыл бұрын

Glad it helped

@christv0811 Жыл бұрын

Nice this is so clear

@MattMacarty Жыл бұрын

Thank you. Glad it helped

@zhiqiangzheng5985 2 жыл бұрын

Thank you, it helps a lot

@MattMacarty 2 жыл бұрын

Glad it helped

@nayaroni Жыл бұрын

Thank you for this tutorial!!!

@MattMacarty Жыл бұрын

Glad it helped

@nayaroni Жыл бұрын

@@MattMacarty can you do a video on Stored Procedures? I am struggling with it:/

@Spark_Bite 9 ай бұрын

Greate Job Sir

@MattMacarty 9 ай бұрын

Glad it helped

@Cebuanoontwowheels 2 жыл бұрын

Felt like i was listening to vin Diesel. Thank you dude!!

@MattMacarty 2 жыл бұрын

LOL. Someone else said the same thing. Glad it helped.

@Mr.nikk62 Жыл бұрын

thank you so much sir

@MattMacarty Жыл бұрын

Glad it helped

@sagetimmy6310 4 ай бұрын

Well explained ❤

@MattMacarty 4 ай бұрын

Glad it helped

@devconnie Жыл бұрын

Tks Matt. Appreciate it.

@MattMacarty Жыл бұрын

Glad it helped

@pratyushsinha374 3 жыл бұрын

Thank you so much!

@MattMacarty 3 жыл бұрын

Glad it helped

@lyjunsay2852 3 жыл бұрын

you sound like the guy from Khan Academy. Great job on this! Very helpful tutorial!

@MattMacarty 3 жыл бұрын

Thanks. Glad it helped.

@crystella1450 3 жыл бұрын

That's true , he sounds like Sal khan

@grannah2050 7 ай бұрын

Very helpful, thank you

@MattMacarty 7 ай бұрын

Glad it helped

@stephy95 2 жыл бұрын

Thank you very much!

@MattMacarty 2 жыл бұрын

Glad it helped.

@orleanralia3297 2 жыл бұрын

Thank you.

@MattMacarty 2 жыл бұрын

Glad it helped

@bushidoGF 2 жыл бұрын

Thank you for this

@MattMacarty 2 жыл бұрын

Glad it helped

@babacarmane5434 2 жыл бұрын

Thanks you so much !

@MattMacarty 2 жыл бұрын

Glad it helped

@mehdighomshe2346 3 жыл бұрын

thank you for your video

@MattMacarty 3 жыл бұрын

Glad it helped

@dwest889 2 жыл бұрын

Excellent tutorial

@MattMacarty 2 жыл бұрын

Thanks. Glad it helped.

@charleskp947 3 жыл бұрын

thanks so much.... your voice is awesome too... should be voice over artist

@MattMacarty 3 жыл бұрын

Thanks for the compliment. I am glad it helped.

@ajeetdubey1308 3 жыл бұрын

Really so helpful ❤️

@MattMacarty 3 жыл бұрын

Thanks. Glad it helped

@statisticstutorial6053 Жыл бұрын

tq sooooo much

@MattMacarty Жыл бұрын

Glad it helped

@vinaybora617 2 жыл бұрын

Awesome!! Dude

@MattMacarty 2 жыл бұрын

Glad it helped

@MattMacarty 2 жыл бұрын

Glad it helped

@hoormallick879 2 жыл бұрын

Amazing it helped alott💓

@MattMacarty 2 жыл бұрын

Glad it helped

@yogesh9149 2 жыл бұрын

Thanks....

@MattMacarty 2 жыл бұрын

Glad it helped

@granand 3 жыл бұрын

Thank you Matt. Great tutorial and help. Please may I know where is this database stored which we are creating in the localhost. Can we change that location to external drive? 2. How to load .bak datasets, I have downloaded?

@MattMacarty 3 жыл бұрын

In Windows you can find your database files here: C:\ProgramData\MySQL\MySQL Server 8.0\Data The programdata folder is hidden by default so go to file explorer and open This PC, then click the view tab at the top and check the Hidden items check box on the right of the ribbon

@padmakarlohatkar343 Жыл бұрын

thanks matt..

@MattMacarty Жыл бұрын

Glad it helped

@aparise1 2 жыл бұрын

Great video! Is it possible to import more than 1000 rows with the wizard? Does creating the DB manually allow for more?

@MattMacarty 2 жыл бұрын

Thanks. Yes you can import much larger files it just may be a little slow. The limit on output can also be changed to allow more or less results to display in your result set.

@divyanshupawar8069 2 жыл бұрын

Very helpful

@MattMacarty 2 жыл бұрын

Glad it helped

@AjayKumar-id7mb 2 жыл бұрын

Thanks man

@MattMacarty 2 жыл бұрын

Glad it helped

@devconnie Жыл бұрын

Matt, tks for your reply and tried to download the file. However, the data file did not open and link with the database, and maybe I was doing something wrong. If you put a video about downloading and linking the data that would be great. tks.

@MattMacarty Жыл бұрын

OK. You have a couple of options here. You can download the files as a .zip and then extract them or you can clone the github repository. Let me see if I can get a tutorial together.

@joycewang7373 2 жыл бұрын

Thank you Matt, the vedio did help me to learn mysql as a beginner. Could you please advise if you have more vedio of mysql on KZfaq? I would like to study mysql with your further vedioes. Looking forward to more vedioes

@MattMacarty 2 жыл бұрын

Hi I have a few videos for beginners: kzfaq.info/sun/PLiPFKCVZWHKq3RvwDxosNm5Ny7cHyfc4o

@joycewang7373 2 жыл бұрын

@@MattMacarty Thank you very much!

@tiagoaicapital 2 жыл бұрын

Hi Matt, how could we upload csv files using an sql script to upload instead of doing need manually?

@MattMacarty 2 жыл бұрын

This tends to be problematic due to security settings in MySQL. You are looking for LOAD DATA INFILE [filename]. Here's a link to the documentation: dev.mysql.com/doc/refman/8.0/en/load-data.html

@tiagoaicapital 2 жыл бұрын

@@MattMacarty Thank you for the feedback

@pavitras6058 Жыл бұрын

Do u have video on how install n setup MySQL pls share me and I need it on 6.3ce workbench

@MattMacarty Жыл бұрын

I have a document if you email me I will send it to you. Tell me if you are using MAC or Windows

@partabparmar5537 2 жыл бұрын

thank you

@MattMacarty 2 жыл бұрын

Glad it helped

@partabparmar5537 2 жыл бұрын

@@MattMacarty 😇😇

@adekunleshokunbi9541 10 ай бұрын

Thank you Matt for this comprehensive video. I still have issues on trying to set up my workbench and server😢 How can I go about this?

@MattMacarty 10 ай бұрын

Which version of MySQL are you trying to install? Windows or MAC?

@renancatan 3 жыл бұрын

Very nice! Mysql community version is free, right? Do you know how much space can I use? Another question, I saw that youre importing your connection from a local server, is it really on the cloud, how do I do to store my data/retrieve it through a cloud connection without being "local" in python through mysql?

@MattMacarty 3 жыл бұрын

Yes MySQL is free to download and use, community edition. I have both localhost connection and remote, (cloud or network server). You will just need the address for the remote connection to set it up and a username and password to connect with.

@devconnie Жыл бұрын

Hi Matt, tks for the great video. However, how to download the data file and upload

@MattMacarty Жыл бұрын

Here is a link to all the MySQL files: github.com/mjmacarty/mysql

@matthewgonzalez2051 3 жыл бұрын

Hey great tutorial this really helped. Quick question and I hope you can get back to me soon, when I try to import my data, I keep getting a row import failed. Do you know how or why and if so please feel free to explain. Thanks

@MattMacarty 3 жыл бұрын

This could be any number of things. It is probably something like a data type or size problem. Difficult to say exactly without seeing the data.

@colinz7234 3 жыл бұрын

hi, thanks for sharing this tutorial. But I encounter an issue when I importing the database. I lost some database after upload but there are no error shows. Do you know how to fix it?

@MattMacarty 3 жыл бұрын

Hi, I will need a bit more to go on. What database are you trying to upload?

@colinz7234 3 жыл бұрын

@@MattMacarty hi, thank you for replying. I’m using a database called “Biden NY state all contributions”

@sareenasanil4053 3 жыл бұрын

Can you tell how to treat the blank cells while importing from excel to mysql workbench. I want them to be null and converting datatype from text to int .

@MattMacarty 3 жыл бұрын

You probably have to do the manipulation after you import. If values are blank they should automatically come in as Null

@SINNER460 2 жыл бұрын

OMG .. Perfect ...well explained. You really helped me. Thank you.

@MattMacarty 2 жыл бұрын

Glad it helped!

@user-wv5ef9bp5j 3 жыл бұрын

Thank you a lot, it's the best tutorial! However, I've faced the problem: 0 records imported. Please, can u say me how to fix it?

@MattMacarty 3 жыл бұрын

This usually means there's a error in the data type you are trying to import. Try importing the data into a new table and then modify the definitions as needed.

@samratkundu2799 Жыл бұрын

What should I do with the large data having more than 20K rows with messy/NULL values..? I may not know if the data type has really maintained to the entire row or not (and not possible to check entire dataset manually).. It's getting very tough to import the data successfully to MySQL table. The Import Data Wizard is really slow in this task. Is there any other way to this more efficiently whithout loosing anything ? please let me know.. I'm unable to complete my portfolio projects 😥

@MattMacarty Жыл бұрын

You can try the import as a generic data type like text. Workbench is very slow with larger datasets. You may wan to try something like TablePlus

@Pollanese16 3 жыл бұрын

Hi. Thanks for this! I just went through this exercise but my chart is not appearing at all. Any idea what I am doing wrong? I did not even see a chart when I added in the headings. I'm a total newbie to MySQL

@MattMacarty 3 жыл бұрын

There is a little refresh icon in the upper right of the navigation pane. Click and the new database should display. They will also display the next time you connect to the server.

@Pollanese16 3 жыл бұрын

@@MattMacarty Thanks. I appreciate the reply. Yea, I wasn't refreshing and selecting the new database. I figured it would automatically recall it. I was going crazy. Lol

@jimmywheeler3601 2 жыл бұрын

Thanks Matt, I'm running into an issue in which the import wizard is taking a very long time. I'm using the owid covid data which comes out to around 33 MB. Is something wrong that it has been 10 minutes and the progress bar is still at 0? I had tried using the 'LOAD DATA INFILE...' command but kept ending at error 1290 and go stuck on 'secure_file_priv'. Is there a better way to get this data into MySQL? Thank you again

@MattMacarty 2 жыл бұрын

With a typical installation's security settings, it's nearly impossible to use LOAD data. In Workbench can take a very long time, but it is likely that there is something in your data set that MySQL is getting hung up on. Try taking a look at the data in a txt editor and see if there are any hidden characters that may be causing the problem.

@jimmywheeler3601 2 жыл бұрын

@@MattMacarty Thank you for the insight! I've made an attempt to split the data in half in R, change all my data types to text to avoid type errors. It's running now and I have yet to run into any errors in the message log but am not holding my breath. I've got 125K entries with 65 columns, could the upload go any smoother if I were to chop the main data set into 15 column chunks that I can join back together later?

@oluwafemihunsu6200 Жыл бұрын

Jimmy what do you mean by spliting it into half

@azimshikalgar69 Жыл бұрын

Hello, How to install DVD rental database in MySQL as it's in postgreSQL

@MattMacarty Жыл бұрын

It's probably not directly compatible. Even though most of the query language is the same, these two products diverge in database implementation. I would do a search to see if someone has created a MySQL version. I am not familiar with that databse, but it sounds suspiciously similar to Sakila in MySQL

@khong6460 3 жыл бұрын

A nice and clear intro to SQL workbench - MANY THANKS A qq, do I need to 'drop' the table every time when I wish to run the code before moving on to the next part? I never used the 'drop' trick, so workbench just returned a red cross with table already exists? TA !

@MattMacarty 3 жыл бұрын

Hi no you don't need to drop table unless you want to start over.

@khong6460 3 жыл бұрын

@@MattMacarty thanks for replying. I tried to re-run the whole program after inserting data into the table i created in part 1, but SQL workbench can't run that saying the table is already exist ? Cheers

@MattMacarty 3 жыл бұрын

@@khong6460 OK, just skip the line where you CREATE TABLE. You can run one line at a time in the Workbench editor, or just comment the CREATE line out.

@maheshdravidar3694 9 ай бұрын

Hi Matt, First of all thanks for brilliant videos. I am loving it. Now to the question, i am trying to import the file to change the date format but while loading the through import wizard, its loading zero data. I am following all your steps mentioned from 11:50, please advise what am i missing.

@MattMacarty 8 ай бұрын

So you mean the date is in some format other than ISO? I would try to import the date column as text and then convert it in MySQL to see if that works better.

@diazjubairy1729 3 жыл бұрын

could you make tutorial about how to make ER Diagram from excel files to mysql worbench ?

@MattMacarty 3 жыл бұрын

Sure. I will try to get to this soon.

@diazjubairy1729 3 жыл бұрын

@@MattMacarty thank you sir

@samuelribeiro5022 3 жыл бұрын

Thanks for sharing, but you can make another tutorial showing how to integrate this data in a web page?

@MattMacarty 3 жыл бұрын

Thanks. Do you mean how to serve data from MySQL database to a webpage/site?

@samuelribeiro5022 3 жыл бұрын

@@MattMacarty Yeah, exactly.

@MattMacarty 3 жыл бұрын

@@samuelribeiro5022 OK, the problem is there are so many different ways to do this. It will depend on the server-side software you are going to use. One common implementation is PHP and MySQL.

@lesliee.4525 2 жыл бұрын

I'm getting an error that says "unhandled exception 'charmap' codec can't decode byte 0x9d in position 2155: character maps to " do u know how I could fix this?

@MattMacarty 2 жыл бұрын

This sounds like there are some characters in your data that MySql can't deal with. Try opening the data file in a simple text editor to see if you can find and remove any odd looking characters. They should be pretty obvious.

@lesliee.4525 2 жыл бұрын

@@MattMacarty ok thanks

@abdulazizamen8286 3 жыл бұрын

can you help me, how to read a list of values from a table and put them in a variable in CSV format

@MattMacarty 3 жыл бұрын

After you run your query, at the top of the results grid there is a button to export. That is probably the easiest way to do it.

@abdulazizamen8286 3 жыл бұрын

@@MattMacarty Thank you

@joseraphaelmarquez8189 Жыл бұрын

Hello! I just want to ask if it is possible to hide the unwanted database or can I just create new file/project to makd it look more organized? Thank you in advance!! 😊

@MattMacarty Жыл бұрын

The Workbench is really sort of a development environment for interacting with your databases. I don't think you can hid what you dont want to see unless you just close the schema pane. There are other tools you can try like Tables Plus that may do more of what you are looking for

@nanthacharee1114 2 жыл бұрын

What is double and why we have insert the text 'double'? is it because we have to repeat above and why we are not giving char for other columns and only gave for 1st column

@MattMacarty 2 жыл бұрын

Double is the data type specification. This is a general numeric type with decimals. There are other numeric types , but double is a pretty good choice for most numeric data that many have decimals.

@45_dzikrimufidtsaqif33 Жыл бұрын

Let me ask, how do we know the latest data that appears from the data that we have imported without importing it again, I mean if we change the data then the new table will also be replaced automatically, how can we do that sir? thank you Sir

@MattMacarty Жыл бұрын

You can either manually import or write a script in something like Python to automate this.

@nutsaboutnuts927 2 жыл бұрын

Hi, at about 11.30 in the video, if I try to update using the str-to-text function, I get an error message 1411 incorrect datetime value. The csv file I'm using looks just the same as the one in this demo video (the date format). Any idea what's going wrong? (me = complete newbie!) Thanks

@MattMacarty 2 жыл бұрын

Really hard to diagnose remotely. Can you try to alter the table to see if that works? ALTER [table name] MODIFY [data column] date; if this works you can skip the str_to_date( ) since the data is now defined as a date.

@nutsaboutnuts927 2 жыл бұрын

@@MattMacarty Thanks so much for replying. In fact what I did was to change the column header in the csv file, previously it was called 'date' so I changed it to something else and then the str-to-date worked. In the table it still has the Datatype as text though - is that right?

@MattMacarty 2 жыл бұрын

@@nutsaboutnuts927 Yes. To change the data type you run the ALTER table command from my previous response.

@philosophyandreligion 2 жыл бұрын

Great tutorial! 1 question. I’m new to the computer verse. Was that data sheet created in Excel?

@MattMacarty 2 жыл бұрын

Thanks. The data used started as an Excel file but was converted into .csv from within Excel.

@philosophyandreligion 2 жыл бұрын

@@MattMacarty “This file type is not supported. Valid options are: CSV, JSON” That’s the notification I keep getting - even after I converted the file to CSv format. Trust me, I tried all of the csv format and I keep getting the same disappointment. I don’t know what to do now. May there is a setting in excel..🤦🏾‍♂️

@MattMacarty 2 жыл бұрын

@@philosophyandreligion Are you on a MAC? Try installing a simple text editor like sublime text or atom. Open the file with the text editor and then copy and paste the data over itself and save. Try the upload then.