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!
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.
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.
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).
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
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.
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
@@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.
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.
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.
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
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!
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.
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
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
Until this moment, only knew I couldn’t ever open these files.
Saaaame
Why did you think you coulnt open them🤨
Very easily understandable and useful!
Thanks very much, Gary, for this very interesting and informative video!
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).
Thank you! I’m very happy to have learned about this! 😊
Thumbs up before even listening ❤
Great explanation...Thanks so much...
Very helpful, thank you!
Great thing also about csv and text files is that they are very small files
Nice beginner tutorial
Interesting. Useful.
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!
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.
Great video
Thank you!
Thanks bunches
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.
thankss..
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.
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...
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.
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.
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 ❤️👍
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 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
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.
Kirk Trail
I am worried that i am in trouble understand
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