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.
@CedricMcCay
Жыл бұрын
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!
@zoulhhh
Жыл бұрын
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.
@macmost
Жыл бұрын
Thanks!
@zoulhhh
Жыл бұрын
@@macmost My pleasure. I also like that your videos do without effects and annoying music. Thanks again man.
@rdfuhr
Жыл бұрын
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.
@brianbs7348
Жыл бұрын
thank you i used them in the past but your explanation was better than any other i have had. so thank you
@loisskiathitis8926
Жыл бұрын
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
@Whowhatwherewhy
Жыл бұрын
Until this moment, only knew I couldn’t ever open these files.
@heatherwoods528
Жыл бұрын
Saaaame
@garynagle3093
Жыл бұрын
Very useful. Thanks for the tips. Quotes around text fields is definitely the way to go
@adrienarseneault6457
7 ай бұрын
Very easily understandable and useful!
@argenisaguilar9045
5 ай бұрын
Great explanation...Thanks so much...
@carolinebarlow4795
Жыл бұрын
Thanks very much, Gary, for this very interesting and informative video!
@ivyvine755
Жыл бұрын
Thank you! I’m very happy to have learned about this! 😊
@jonny777bike
2 ай бұрын
Great thing also about csv and text files is that they are very small files
@issiewizzie
Жыл бұрын
Thumbs up before even listening ❤
@mnmleung
Жыл бұрын
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).
@Zugunru
Жыл бұрын
Very helpful, thank you!
@defel1
Жыл бұрын
Interesting. Useful.
@aljosavage
4 ай бұрын
Great video
@krinodagamer6313
Жыл бұрын
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
@Thyme2sea
Жыл бұрын
Thank you!
@desertpatient
Жыл бұрын
Thanks bunches
@Rubiksguy
9 ай бұрын
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
@macmost
9 ай бұрын
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.
@jacquiewpb1932
Жыл бұрын
Do you have a video on how to take CSV file and have them print on Avery address labels with an iMac
@macmost
Жыл бұрын
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.
@swimfast1234
10 ай бұрын
Great video. How would you import CSV data into an existing Numbers spreadsheet that has formulae within it? Thanks again. Martin
@macmost
10 ай бұрын
Import into a table. Have the formulas that work on the data in other tables.
@gordonslomba2532
11 ай бұрын
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
@macmost
11 ай бұрын
You'd have to talk to MailChimp support about that...
@CharlesMosely-w8p
3 күн бұрын
Kirk Trail
@lualejo2015
Жыл бұрын
I use CSV files to create Anki flashcards quickly!
@mRjewelrymine
Жыл бұрын
Great ! Question how do I take a pdf and change it into a csv file which can then open in numbers?
@JoshPeterson
Жыл бұрын
Just google "convert PDF to CSV"
@macmost
Жыл бұрын
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.
@mRjewelrymine
Жыл бұрын
@@macmost thanks - love your courses and YT videos ❤️👍
@EBOWARRIOR
11 ай бұрын
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.
@macmost
11 ай бұрын
So what app are you using? In most spreadsheet apps, you just add one. Like B2+1
@EBOWARRIOR
11 ай бұрын
Using softmaker at the moment and it really has me scratching my head, old age must be kicking in lol@@macmost
@xpertg91
Жыл бұрын
How do I paste text into extreme CSV? I can't make it work...
@macmost
Жыл бұрын
Not sure what you mean by "extreme" CSV.
@toni4729
11 ай бұрын
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.
@macmost
11 ай бұрын
Not sure what you are dealing with there. This is about CSV files, but has nothing to do with Google passwords.
@socorrohilis1704
Жыл бұрын
Why formulas are missing when saved as csv??
@macmost
Жыл бұрын
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.
@toni4729
11 ай бұрын
This is all a foreign language to me and Google took my passwords away from me. All of them.
@DanielStarkey-i1z
Жыл бұрын
You miss-spelled Google, as goggle
@BellamyEmily
3 күн бұрын
46736 Beer Union
@Land-of-reason
Жыл бұрын
Comma Separated Variables!
@macmost
Жыл бұрын
Values. See en.wikipedia.org/wiki/Comma-separated_values
@macmost
Жыл бұрын
@@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
@Land-of-reason
Жыл бұрын
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.
@a7xfanben
3 ай бұрын
Nice beginner tutorial
@iacosta79
5 ай бұрын
I have a Job interview that is requiring CSV knowledge and before watching this video I didn't know anything about it. Thanks.
@ronstubbs7937
11 ай бұрын
I am worried that i am in trouble understand
@shuangqiongxiong1962
Жыл бұрын
How do I have a sample of CSV for the first step?please
@macmost
Жыл бұрын
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
Пікірлер: 59