CSV format is very useful. Also useful is separating the data in the columns on each line with the tab character. Numbers and most spreadsheets handle this with no problems.
Thanks for this. For some reason, I was always a bit afraid of these type of documents. You helped to really demystify them with this video. Kind thanks!
Nobody makes such clear videos full of useful information (even though you think you know everything about a certain topic already). Thanks Gary. It's always worth watching.
It is very convenient to have this simple CSV format that is not tied to a particular spreadsheet app for storing data. Some programming languages, such as Python, have some functionality, in the form of additional packages, that enable you to read CSV files, analyze them, and generate plots from them. For example, if the first column is Date and the second column is High Temperature, you can create a plot that shows high temperature as a function of date.
Thank you! I did not know about the plaint text mode in TextEdit. I use a backslash (\) to delimit, and I find LibreOffice helpful when opening a CSV file because it prompts me up front to specify how the fields are separated (fixed length or what delimiters).
thanks for explaining about the quotes and commas for values - do you know anything about syntax errors from csv into consumer ui like mailchimp? couldn't import from csv because of syntax errors
In windows 10, I often make a folder full of movies, or other MP4 files. I do not create a CSV file, but when I list the files in the folder, there is a good CSV file among all these MP4s, listing all of the MP4s. I’m not sure if Windows creates that, or if the downloading software I use creates it. Has anyone else experienced this automatic appearance of a CVS file?
It seems rare to find in references, directions on how to represent an EMPTY field within a record. If anyone needs to know, the way to do that is by using 2 adjacent commas. The empty field would be between those, if it were present. For two adjacent empty FIELDS you would use 3 adjacent commas, and so on.
The best way is usually copy and paste. You can sometimes do it right into Numbers. If that doesn't work paste it into a text document and clean it up there first.
Please do a tutorial on Merging csv files into a master csv where quantities are combined if all headers are the same. Ie 2 quantity in one sheet, 3 on the next. Same headers, so combines to 5
I would just import them all into Numbers (or Excel) and combine them there using formulas and other techniques. How easy that is depends on your spreadsheet skills.
A sample? Just to test this? You can do to a data site (US Census, etc) and download some CSVs if you like. Or just type one out in a TXT file with TextEdit. Just commands and returns, like this would work. A,B,C 1,2,3 4,5,6
I have a CSV file and instead of a percentage I am just trying to increase the overall price of every item by one pound only but struggling to get it to work, I used to be able to do this years ago but just cannot recall how I did it, any help would be massively welcome.
I created a AI training on all system processes and predict data...then is ran through another process to save all the predicted data to another csv file to the specific columns I am now in the phase of creating the metadata for the predicted values for better overall system performance it's gonna be a game changer and I'm using python on a RTX 4090
@@Land-of-reason That's fine. You can do that. But put yourself in my shoes. Wikipedia and every single page on the first page of Google search results for "what does csv stand for" says it is "values." If I say "values" I get one complaint. But if I said "variables" I would definitely get more. I can't win, but I can at least go with the consensus. Oh, and here is another page at the same site (IBM) that says it is values: www.ibm.com/docs/en/bpmoc?topic=SS964W/com.ibm.wbpm.wid.data.doc/topics/ccsv.htm
A CSV file is a table where the fields that make up that table are delimited with a ‘comma’. Within the context of a programme a ‘value’ will have a specific meaning. Within the context of a 70’s HP2100 or 21MX computer the value ‘102077’ octal meant ‘stop’. If you have a table of ‘Comma Separated Values’ each line within that file would represent the same thing - the stop code which would be nonsense. Despite what Wikipedia may claim the fields within the table must be variables and not values.
When someone who's never used anything like that gets a notice to say, put your passwords into csv files and they've all been removed from you by Google; what do you then? There's a box to click for CSV and when I click it, all I get are files from my photo album. No good.
CSV format is very useful. Also useful is separating the data in the columns on each line with the tab character. Numbers and most spreadsheets handle this with no problems.
Thanks for this. For some reason, I was always a bit afraid of these type of documents. You helped to really demystify them with this video. Kind thanks!
I have a Job interview that is requiring CSV knowledge and before watching this video I didn't know anything about it. Thanks.
Nobody makes such clear videos full of useful information (even though you think you know everything about a certain topic already). Thanks Gary. It's always worth watching.
Thanks!
@@macmost My pleasure. I also like that your videos do without effects and annoying music. Thanks again man.
thank you i used them in the past but your explanation was better than any other i have had. so thank you
It is very convenient to have this simple CSV format that is not tied to a particular spreadsheet app for storing data. Some programming languages, such as Python, have some functionality, in the form of additional packages, that enable you to read CSV files, analyze them, and generate plots from them. For example, if the first column is Date and the second column is High Temperature, you can create a plot that shows high temperature as a function of date.
Until this moment, only knew I couldn’t ever open these files.
Saaaame
Why did you think you coulnt open them🤨
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Very useful. Thanks for the tips. Quotes around text fields is definitely the way to go
Very easily understandable and useful!
Thank you! I did not know about the plaint text mode in TextEdit.
I use a backslash (\) to delimit, and I find LibreOffice helpful when opening a CSV file because it prompts me up front to specify how the fields are separated (fixed length or what delimiters).
Nice beginner tutorial
Thank you! I’m very happy to have learned about this! 😊
Thanks very much, Gary, for this very interesting and informative video!
thanks for explaining about the quotes and commas for values - do you know anything about syntax errors from csv into consumer ui like mailchimp? couldn't import from csv because of syntax errors
You'd have to talk to MailChimp support about that...
Thumbs up before even listening ❤
Do you have a video on how to take CSV file and have them print on Avery address labels with an iMac
You'd either need to import it into an Avery template and work with it there. Or, get some label-printing software that handles it.
Very helpful, thank you!
Great video. How would you import CSV data into an existing Numbers spreadsheet that has formulae within it? Thanks again. Martin
Import into a table. Have the formulas that work on the data in other tables.
Great explanation...Thanks so much...
Great thing also about csv and text files is that they are very small files
In windows 10, I often make a folder full of movies, or other MP4 files. I do not create a CSV file, but when I list the files in the folder, there is a good CSV file among all these MP4s, listing all of the MP4s. I’m not sure if Windows creates that, or if the downloading software I use creates it. Has anyone else experienced this automatic appearance of a CVS file?
It seems rare to find in references, directions on how to represent an EMPTY field within a record. If anyone needs to know, the way to do that is by using 2 adjacent commas. The empty field would be between those, if it were present. For two adjacent empty FIELDS you would use 3 adjacent commas, and so on.
Interesting. Useful.
Great video
Great ! Question how do I take a pdf and change it into a csv file which can then open in numbers?
Just google "convert PDF to CSV"
The best way is usually copy and paste. You can sometimes do it right into Numbers. If that doesn't work paste it into a text document and clean it up there first.
@@macmost thanks - love your courses and YT videos ❤️👍
Please do a tutorial on Merging csv files into a master csv where quantities are combined if all headers are the same.
Ie 2 quantity in one sheet, 3 on the next. Same headers, so combines to 5
I would just import them all into Numbers (or Excel) and combine them there using formulas and other techniques. How easy that is depends on your spreadsheet skills.
Thank you!
How do I have a sample of CSV for the first step?please
A sample? Just to test this? You can do to a data site (US Census, etc) and download some CSVs if you like. Or just type one out in a TXT file with TextEdit. Just commands and returns, like this would work.
A,B,C
1,2,3
4,5,6
I have a CSV file and instead of a percentage I am just trying to increase the overall price of every item by one pound only but struggling to get it to work, I used to be able to do this years ago but just cannot recall how I did it, any help would be massively welcome.
So what app are you using? In most spreadsheet apps, you just add one. Like B2+1
Using softmaker at the moment and it really has me scratching my head, old age must be kicking in lol@@macmost
How do I paste text into extreme CSV? I can't make it work...
Not sure what you mean by "extreme" CSV.
Why formulas are missing when saved as csv??
CSV documents aren't full spreadsheets and just have the values in them, not formulas. Formulas would be specific to an app like Excel or Numbers.
I created a AI training on all system processes and predict data...then is ran through another process to save all the predicted data to another csv file to the specific columns I am now in the phase of creating the metadata for the predicted values for better overall system performance it's gonna be a game changer and I'm using python on a RTX 4090
I use CSV files to create Anki flashcards quickly!
Thanks bunches
Comma Separated Variables!
Values. See en.wikipedia.org/wiki/Comma-separated_values
@@Land-of-reason That's fine. You can do that. But put yourself in my shoes. Wikipedia and every single page on the first page of Google search results for "what does csv stand for" says it is "values." If I say "values" I get one complaint. But if I said "variables" I would definitely get more. I can't win, but I can at least go with the consensus. Oh, and here is another page at the same site (IBM) that says it is values: www.ibm.com/docs/en/bpmoc?topic=SS964W/com.ibm.wbpm.wid.data.doc/topics/ccsv.htm
A CSV file is a table where the fields that make up that table are delimited with a ‘comma’.
Within the context of a programme a ‘value’ will have a specific meaning.
Within the context of a 70’s HP2100 or 21MX computer the value ‘102077’ octal meant ‘stop’. If you have a table of ‘Comma Separated Values’ each line within that file would represent the same thing - the stop code which would be nonsense.
Despite what Wikipedia may claim the fields within the table must be variables and not values.
thankss..
I thought it stood for comma separated VARIABLES.
Nope. en.wikipedia.org/wiki/Comma-separated_values
@ Thank you.
When someone who's never used anything like that gets a notice to say, put your passwords into csv files and they've all been removed from you by Google; what do you then? There's a box to click for CSV and when I click it, all I get are files from my photo album. No good.
Not sure what you are dealing with there. This is about CSV files, but has nothing to do with Google passwords.
I am worried that i am in trouble understand
Kirk Trail
This is all a foreign language to me and Google took my passwords away from me. All of them.
You miss-spelled Google, as goggle
46736 Beer Union