Import Excel spreadsheets into your database using PostgreSQL

[@bryan1377]

Thanks, Learning SQL at the moment and I’m using postgresql and this was really helpful. Some more sql, excel and other data analysis tools tutorials will be helpful

[@M78ST]

Learnt more of use from this than in about 3 hours of a Udemy 'course'!! Excellent and thanks!!

[@Polaynka_Bolgarka]

The simple and clearly. Thank you

[@olukoniseun]

This was exactly what I needed thanks!!!

[@franccaroline4873]

Thank you. This really helped. Thou I had challenges with the character length… but it’s fixed now.

[@gianfrancocipollari8708]

Love you man!

[@abhishekshishodia7767]

thanks buddy! keep it up

[@JoviSatriaadam]

thanks for the knowledge

[@ExcelHelps]

What other SQL & Or database concepts would you be interested in seeing?

[@franccaroline4873]

Duck db, I honestly don’t know how to use it.

[@ExcelHelps]

@@franccaroline4873 Thanks for the idea! I've never used Duck DB but i think it will be interesting to learn more about! I will take a look at the documentation in the near future.

[@franccaroline4873]

@@ExcelHelps Alright

[@friendsforever715]

Big query tutorial too..also Data Lake or other data warehouse..thanks

[@SieanElpidama]

whats the difference with ssms and postgresql also is it needed to be a CSV when you import it to postgres?

[@ExcelHelps]

Hello! SSMS is similar to Postgresql or pgAdmin which is the database management system for Postgresql. And the data does typically need to be a CSV/text or binary for importing into the database. Thanks for the comment!

[@mycheaplife1900]

how can i import the file with the columns my dataset have 36 columns and its tiring writing it down

[@ExcelHelps]

To still import it in this way, I would recommend using Excel to format the column names and data types in a separate file to copy them into the Query! Thanks for the comment!

[@abhishekshishodia7767]

can you help me with this type of error : missing values in particular column type???

[@ExcelHelps]

I believe this would happen if a JOIN can't find matching values in the tables, or if a column has NULL values. Maybe try to do something like [ UPDATE table_name SET column_name = 'some value' WHERE column_name IS NULL; ] and retry executing the query. Let me know how you go about fixing the error! Thanks for the comment!

[@ExcelHelps]

If is from a JOIN then it could be that the JOIN is not compatible with the two Tables/Columns selected.

[@abhishekshishodia7767]

@@ExcelHelps well idk but still face the issue? can you please tell me whats wrong and how to correct it in this dataset : drive.google.com/file/d/1sn_kc312omvWv2_QBMaWmYV0ulRMJCdA/view?usp=sharing

[@darthrevan6861]

I always got this error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0x70 0x75 Even when I change the encoding to WIN1250 (which is the encoding my Excel file has) Any suggestions anyone?

[@darthrevan6861]

I've realised what's the problem, i'll write it down if somebody has the same problem in the future: You have to change the encoding of the database itself as well (which is UTF8 by default), selecting the encoding only in the Import/Export panel won't be enough.

[@alcaponezxc]

Hello, thanks for video 😊, I have an commas on my voters table like 38,333 . And i tried to import it but it doesn't worked. It's giving syntax error and i have description table which has more words and this one also giving error. Can you help me please, how should i create these column properly ?

[@ExcelHelps]

Hello! Saving the file as a Text(tab delimited file) can help with avoiding the unwanted comma separation. And for the description you can create a varchar() data type with more characters allowed such as varchar(150) or varchar(200). Thanks for the comment!

[@alcaponezxc]

@@ExcelHelps Thanks !

[@nishitagoel1154]

Thanku so much

[@Cruen_Media]

Hey! What can I do when I got accents in names in the csv's?

[@ExcelHelps]

Hey Christopher! VARCHAR allows different types of characters to be used.

[@ektatomar5567]

Thank you

[@parthshete772]

Thanks