8

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?

8 Answers 8

8

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.

6
  • Besides making sure the file works with Excel. Why doesn't he just not use Libre/OpenOffice instead of Office?
    – Ramhound
    Sep 4, 2014 at 17:38
  • @Ramhound Why are you asking me? :) Maybe he just REALLY wants to use the Excel Online app. :)
    – techie007
    Sep 4, 2014 at 17:41
  • I was just curious the reason you didn't suggest it.
    – Ramhound
    Sep 4, 2014 at 17:43
  • 4
    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, 2014 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, 2014 at 19:53
4

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.

using text to columns feature

3

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
1
  • Thank for your answer, apologies for the delay, but this was for a client who wanted to import a csv from Moodle into Excel. I needed to test the csv import in Excel. Jul 31, 2022 at 15:45
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.

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.

1
  • 1
    Did you do this using a web browser? Was you able to open the.xlsx file in Excel Online? Feb 25, 2021 at 22:27
1

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).

1
  • Thank you for the answer :) But this was originally for a client organisation that was using Excel. They would export the csv from Moodle, download locally, then import into Excel. But had funny characters so I needed to test this in Excel. Jul 31, 2022 at 15:46
0

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

0

I made this script to convert csv data into a format with powershell that you can just paste into excel, I use this to graph my temperatures captured with iCUE...

#folder that contains iCue log files
$FOLDER = "D:\iCueLogs\*.csv"
#only select the single most recent log file
$recent = gci $folder | sort modifieddate | select -last 1

#import the csv into powershell object
$array = import-csv $recent.FullName
#sort the data by timestamp
$DataArray = $array | sort Timestamp


#convert the data into a format that excel accepts pasting
$a=$DataArray
$a=$a|ConvertTo-Csv -NoTypeInformation
#remove the celcius from temperature values so data is charted correctly in excel
$a=$a.Replace('°C','')
$a=$a.Replace('"','')
$a=$a.Replace(",","`t")
$a|clip

#now paste into Excel and ctrl+a in your data and it all gets selected then add chart

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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