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. Show I've modified the code to insert a BOM as per https://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 https://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
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:
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
How do I open a CSV file directly in Excel?Opening CSV files in Microsoft Excel. Open a blank Excel workbook.. In the Data tab, click Get Data > From File > From Text/CSV.. Select the file to open and click Import.. In the File origin area, select 65001: Unicode (UTF-8) and Semicolon in the Delimiters area.. Click Load.. How do I open a CSV file online?How to view CSV files online?. Click inside the file drop area to upload a CSV file or drag & drop a CSV file.. Once upload completes, you'll be redirected to the viewer application.. Scroll down or use the menu to navigate between pages.. Zoom-in or zoom-out page view.. Download source file pages in PNG or PDF format.. How do I open a CSV file in Onedrive Excel?How to Open a CSV File in Excel (Office 365) Properly. Start by opening Excel and creating a blank spreadsheet (File->New). Under the [Data] main menu, click the [From Text/CSV] icon in the toolbar.. How do I open a CSV file in Excel with Office 365?Launch Microsoft Excel and open a blank workbook. Choose Data – Get External Data – From Text. folder, choose the . csv and then choose Import.
|