I'm working with Moodle to export a csv file. The file is encoded as UTF-8 but Excel doesn't recognise it and so displays odd characters.
I've modified the code to insert a BOM as per //stackoverflow.com/a/16231345/1603711
But I am unable to test it because I haven't got Excel installed.
I was hoping to use Excel online at //office.live.com/start/excel.aspx but I can't find a way to import a csv file.
Is this possible?
ale
51.4k40 gold badges157 silver badges301 bronze badges
asked Sep 4, 2014 at 17:01
Russell EnglandRussell England
2511 gold badge3 silver badges6 bronze badges
Is this possible?
Nope. The Excel Online App currently does not support importing/opening CSV files.
You'll have to convert it to XLSX first, which you could do using Libre/OpenOffice, or one of many online file converter services.
answered Sep 4, 2014 at 17:30
6
The following steps worked for me:
- open csv file in notepad++
- replace all commas with tabs (you may have to enable search mode extended with \t)
- Select all and copy to the clipboard.
- open a blank excel file online
- copy contents of the clipboard.
- Excel should properly separate the tabs into separate cells
serenesat
9,71230 gold badges30 silver badges48 bronze badges
answered Dec 15, 2018 at 19:57
1
I just upload the csv to OneDrive, then open it up. It will automatically be converted to Excel and saved as an .xlsx. It is pretty easy.
answered Feb 25, 2021 at 15:41
1
You can copy the CSV file contents and paste it on your online sheet and then use the "Text to column" feature. It is pretty easy actually.
answered Jun 16, 2021 at 13:52
Ran into the same issue a few moments ago and was somewhat surprised to find Excel Online doesn't support this. Was equally surprised to find this StackExchange post returned pretty high atop search engine results for keywords "excel for web import csv" and no mention of Google Sheets here.
Google Sheets (in-browser) supports importing CSV via File → Import and subsequently exporting via File → Download → Microsoft Excel (*.xlsx) once you've finished setting it up the way you want: which you can then open it in Excel Online from there.
Alternatively, you could look over the Add-Ins via Insert → Add-Ins within Excel Online directly and search for something that might work for you. There seems to be one in there called "CSV Import+Export" but I prefer not to install third-party software or plugins from an unrecognized source if I can get the same thing done with software I do recognize and trust (as outlined above).
answered Jul 31 at 11:26
Matt BorjaMatt Borja
1631 gold badge1 silver badge7 bronze badges
1
Not really a solution per say, but if you can open your CSV file locally, you can just copy-paste it into Office Excel Online and it will properly format all the columns.
answered Dec 15, 2017 at 0:07
you can do it by uploading the CSV file to your drive and then drive will detect the format for you and open it with excel
answered Feb 7, 2020 at 6:57