Hey community i have a question for you. Im doing a literature review and i want to put the relevant literature in an excel table to check it later. Whenever i am exporting something in CSV (using excel) it puts all Categories (e.g. Author, date, title...) in one column. But at the same time the keywords will get put in different columns (each keyword in one column). So i am asking myself: is it possible that by exporting it excel puts every category in one column, seperated from the others. And for keywords that it exports all keywords into one column. Maybe I can change a setting in excel? I have found nothing on google yet and i hope someone maybe has had a similiar problem. Thank you :)
Somehow I believe that the your problem occurs because you are using commas in your .csv file, and not semicolons...
I had the same problem. Try opening the CSV file on google sheets - for some reason, google sheets automatically separates everything into columns, while Microsoft Excel doesn't.
- Badges
- Science topic