Reading csv file and uploading the data

CSV is a rather useless outdated concept to be honest. It would be better to use DSV (delimiter separated values) instead. You can just take any separator you like (and agree on) and escape special characters using a backslash.

If you still are going to use csv you can agree on the number decimal being a point and numbers separated using a comma. Another solution is to simply surround each value with quotes.

Good luck!

The way I approach this scenario little differently. I would write my own text processor to read non standard csvs I recieve. It's very simple and you can always read any such stuffs using "Regular Expressions"

1. Read the file using C# by line by line.
2. Split the records into columns using RegEx

I will explain with small sample working code:

Regex _Expression;
private StreamReader textReader;
private string CSVSourceFeedPath;

textReader = new StreamReader(CSVSourceFeedPath);
string _Statement = String.Format
        ("{0}(?=(?:[^{1}]*{1}[^{1}]*{1})*(?![^{1}]*{1}))",
                        Regex.Escape(";"), Regex.Escape("\"")); //define your delimeters i used semicolon ; here

RegexOptions _Options = RegexOptions.Compiled | RegexOptions.Multiline;
_Expression = new Regex(_Statement, _Options);

string nextLine;
string[] columns;



nextLine = textReader.ReadLine();
while (nextLine != null)
{
    columns = _Expression.Split(nextLine);
    if (columns.Length >= 20//your expected number of columns)
    {
//process here. columns[0] will be your first column
    }
nextLine = textReader.ReadLine();
}

for reading excel/csv refer following link
Read Excel in ASP.NET[^]