I am trying to import CSV/TSV file using CSV module. I have gain a little success in doing so as I am able to import the CSV/TSV data which is in notepad (.txt format) but I am not able to import directly from the Excel sheet (.csv/.tsv). In order to import I have to first copy the data from the sheet to notepad and then from the notepad (.txt file) I am able to import that data. Please help
asked
Praveen Nehra
1 answers
0
Hi Praveen,
Have a look on the line breaks in the .csv/.tsv file. They will most likely differ from what you set as line break delimiter. Use a rich text editor to see them (I think notepad++ could do that)