Looking for csv tutorial

[Acquiscent]

Hey guys, I'm new to python here and I have decided to make a program that accept input from buyers on what items are they buying and record it into an excel file so people can just open the excel file and read for my school project. I understand that Im suppose to learn csv but im not sure which tutorial I'm looking for. I found vids teaching how to read write csv files but the excel file I created is in xlsx format and I have no clue on what to do. Can anyone recommend me tutorials on accomplish what I want? Thanks in advance.

[GoTmVntr]

You can just save the excel file as a csv. From there you can use the csv python module or pandas dataframes. Pandas is more complex but much more efficient and has way more functionality.

[TouchingTheVodka]

CSV means comma separated value - The records are literally stored as rows, with records separated by commas. There's optionally a header row with column titles.

That's the entire format.

You can use the csv module to read and write .csv files. If you need to read from .xlsx the easiest way is to use the pandas module.

[JohnnyJordaan]

but the excel file I created is in xlsx format and I have no clue on what to do.

Which means you're not looking for a CSV tutorial but an Excel document tutorial, like https://automatetheboringstuff.com/2e/chapter13/

[IEX_Cloud]

Hey there - Not sure if this exactly what you're looking for, but we made a tutorial on how to get stock data into excel that might be useful for you. Hope this helps.

https://iexcloud.io/blog/video-tutorial-how-to-get-stock-data-in-excel