4

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 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?

migrated from superuser.com Sep 7 '14 at 18:40

This question came from our site for computer enthusiasts and power users.

4

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.

  • Besides making sure the file works with Excel. Why doesn't he just not use Libre/OpenOffice instead of Office? – Ramhound Sep 4 '14 at 17:38
  • @Ramhound Why are you asking me? :) Maybe he just REALLY wants to use the Excel Online app. :) – techie007 Sep 4 '14 at 17:41
  • I was just curious the reason you didn't suggest it. – Ramhound Sep 4 '14 at 17:43
  • 3
    Ahh gotcha... It was because the question was "How do I import CSV into Excel Online?". That and the fact that he first says Excel shows odd characters, followed by "I don't have Excel installed", so I'm assuming he needs it working in Excel because that's what the person he's preparing it for is using... :) – techie007 Sep 4 '14 at 17:46
  • 1
    Yep, I use Linux and LibreOffice - everything recognises that its a UTF-8 file except Excel :) The client uses Excel and is saying there are odd characters but I can't test it. – Russell England Sep 4 '14 at 19:53
0

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.

0

The following steps worked for me:

  1. open csv file in notepad++
  2. replace all commas with tabs (you may have to enable search mode extended with \t)
  3. Select all and copy to the clipboard.
  4. open a blank excel file online
  5. copy contents of the clipboard.
  6. Excel should properly separate the tabs into separate cells

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.