Uploading CSV files to Investing.com.

[Eamonn100]

I'm having problems with CSV files. I save the sheet as a CSV file but when I try to upload it on to the website I get this message.

"Please choose a valid CSV file. The file must use ";" or "," separators."

The site in Investing.com and they only take CSV files. I'm using Excel 2013. Has anyone experienced for this or can anyone give advice. I've been through Youtube videos to make sure I'm saving as CSV file properly.

 

[AliGW]

Are you choosing the correct CSV option in the Save As dialog in Excel?

 

[Eamonn100]

Yes I think so. CSV (Comma delimited).

In excel, when saving a message pops up. "Saving a CSV some features might be lost, do you still want to".

 

[AliGW]

Sounds fine. Are there formulae in the file? If so, have you tried copying the sheet to a new file as values and saving that to .csv? Does it make a difference?

 

[Eamonn100]

no there are no formulas, just letters and names.

 

[Eamonn100]

could you read this and say what you think.

How to correctly display CSV files (Excel 2013) | Alvin Poh

 

[AliGW]

What does that have to do with saving a .csv file from Excel? It is about READING a .csv file in Excel.

 

[Eamonn100]

Good point, sorry.

I just thought that maybe Excel 2013 night have other CSV problems.