The BEST Way to Read a CSV File in C# | CsvHelper Tutorial 

We've now made an updated video that addresses some of your questions about handling semicolon delimiters and CSV files with no header row, check it out! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-f5bzNh7hVhk.html

This has been truly educational and useful. Thank you so much for sharing!

Keep making videos! As simple as CSV readers seem to be this concept has eluded me. Until now... You've got a new subscriber.

The best I've seen! Just FLAWLESS! Thank you!

This was way more concise than anything google threw at me! Thank you very much!

Thank you so much sir! Finally understood how to use that lib! You're talented to teach us, clear didactic.

Brilliant. Thank you. Such a good teacher!!

Thank you very much for the tip, we from Brazil are grateful for your video.

Loved one thanks.it very helpful for me

This is so helpful many thanks mate!

Great video. What if comma embedded in the one of the column.

Thank you for the clear explanation! Do you know how I can change the csv path to the downloads folder

Great video, quick question, where can I find the CSV used for this example?, Rocket launches I think is called, sorry for the trouble, and keep up the good work!👍🏼

Need to get this csv thing working !! Thanks

Hey, thanks for this video. It was really informative and helped me out/solved my issue where my csv had a mixture of comma only and comma with quoted data eg 22, 5 , "abc", 6 , "def" . Thanks Great video :)

Thanks. Video was easy to understand and got me going.

great Tutorial!

Thank you, very helpful video! Can you tell me what extension do you use to preview csv files in vscode?

wonderful video, Love from Pakistan !

Great tutorial, thank you very much!

This video helped me a lot! You've got a new subscriber.

How can I deal with column name changes? If over time column names change and maybe their order. Or some are removed. Then I need some backwards compatibility between old reports in my app and new reports with the ever changing new format. When I download different formats that must map to the same class. 1. If the column header is dynamic in name then I can use regex. 2. If some columns are removed in the future I can use nullable properties.

Hi Robert, This content is owesome. Thanks for your help. I have one query: Currently my import code using MemoryStream and this CsvReader, to import CSV file. It is fine for small size file but when it reaches 40 MB the application crashes. I m using blazor tech. Someone said that import it in small batches one by one. But I don't know how. Can u please help me.

well done. delivered very clearly and easy to follow. cheers, mate!

Great video! Very direct to the point and easy to follow. Only one question: Is there a place where I can download this CSV file you're using? I cheked the description of the video and couldn't find it.

Great tutorial! If I need some help with this, can I request your assistance?

Hi Robert, nice videos you have here. Im using CSVHelper and ran into a problem. How can I make it read a string like this (This "is" a string). CSVHelper is breaking when getting double quotes in a string and i can't even handle anything because im only passing the file path. Thanks

This video helped me. I am learning C#. So as a project I have taken on to help me do this, I am trying to make an app that can take any datalog type CSV file, and plot the data on a livechart cartesian chart. But one thing i am trying to figure out, I want to be able to load any csv file with any number of columns. how can I create a dynamic class that can accommodate this?

HI! Great talk, BUT do you have the software someplace so I can download it? Trying to copy it while you talk is very hard. Thanks! JIM

Hi Roberts, I'm with a problem. I have a csv file with simple information, 1 column with a Name, 1 column with a Adress and 1 column with 1 ModbusFuction Name. I did like your tutorial, indeed I added the csv file to the directory of my visual studio project. I need to use this information forward in the project, so it's important to read correctly all the data so I can compare the names and adresses so I can do something, adding the information to a list is simple and effective, the problem is that one exception is launched when I run the program: "header with name 'Name'[0] was not found." .. I imagine that is because csv files begin in index 1 right ? Is there any command or solution so I can discard the reading of the index 0 ? Or some command that will start the reading at index 1 ? I was reading the documentation of the CsvHelper and I did not find any concrete solution. I thought that the Mapping solved this problem.

great quality!

Thanks for this good tutorial.

Hello Roberts Dev Talk, What if all of our fields of the CSV are separated by ";" how can we get rid of it to create the database? I mean something like id;contract;phoneNumber; ... and the data is 2;332321;7541233; ... P.S I really like the video.

I've used powershell for years and im just now starting to try and learn other languages. It honestly baffles me how difficult it is to do such simple things like writing to a file or importing a csv. Powershell has cmdlets for everything and all the real complexities are abstracted away. I'm finding learning another language to be really difficult. Especially since i have no teacher and im just learning little bits and pieces from youtube and stackoverflow.

Hi my register is ;...;"name "mr" robot"; ...; double quote is erros. How do I adjust to not give an error with this double quote?

Great tutorial, thanks! Can you tell, please, how convert "$2.34" to "2.34"( cut currency sign)?

I have files that header names are not consistent. Sometimes an extra '_' or year is added anywhere. PrepareHeaderForMatch = args => args.Header.Replace("_", " "), but it doesn't work. even if I just set the header value to lowercase and then when I read csv headers it still shows me the original column names of the file. Any idea what am doing wrong here ?

its showing error" You must call read on the reader before accessing its data." like this ,and which data type should i use i want to read the data that is in japanese language

Hi Robert, your video is informative. Can you please tell me which version of visual code you are using and what other dlls you installed and can I try with CSOM to update the records to sharepoint list. Your information is appreciated 😊

How can you read csv with duplicate headers using dynamic class in

I'm rather new to the .Net scene, so my question is a bit easy to resolve. - I was wondering if we can rely on a console app and insert it into an API to run the code while receiving requests from an online interface (or webpage). would that be possible?

Hey..can you suggest what will be the changes in code if my csv file have no header

Robert, is there a way to work with positional data in text files instead of comma separators?

Does anyone know how to skip headers? I have two headers that's causing issues with the CsVReader..

Peng music 👍🏻

I cant make it work with a MemoryStream =( using (var MemoryStreamReader = new StreamReader(memoryStream, System.Text.Encoding.UTF8, true)) { var wholeText = MemoryStreamReader.ReadToEnd(); using (var csvReader = new CsvReader(MemoryStreamReader, CultureInfo.InvariantCulture)) { var records = csvReader.GetRecords().ToList(); _logger.LogInformation($"Finished downloading file [rom [{remoteFilePath}]"); } }

Hi, any idea how to handle this error when trying to add the CsvHelper package? error: There are no versions available for the package 'CsvHelper'. Using Visual Studio Code and SDK net5.0

what if you dont have column names . how will you determine headernames can u tell us little solution please. I believe it has something to do with CsvConfiguration but I am not sure

awesome video. Could you please try to convert csv files that have double quotes inside. Thanks

how do you do this with blazor 5.0 with file upload?

How to convert a CSV file into TXT file using c#.. Pls help

I love you

thank you for the tutorial! it helps a lot.