6
votes
How to import a csv file into Excel on Microsoft Office Live
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 ...
- 252
4
votes
Accepted
Filtering doesn't work right in Excel online
I figured it out, almost by accident. You see how in the original screenshot, the row colors alternate but then stop at row 23. That's because the "table" part of the worksheet only included the top ...
- 299
3
votes
Does Excel Online support filtering columns by value?
I'm late in the party but not empty handed.
Yes, Excel online does support filtering.
Just format your column as table and then select the kind of filter you want to apply.
Refer to this technet ...
- 151
3
votes
How to import a csv file into Excel on Microsoft Office Live
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 ...
2
votes
Hide the contents filled by each anonymous user on Excel Online
You should create an Excel survey so that nobody knows who else is filling out the form and they can't edit anyone else's responses.
Go to OneDrive
Select New > Excel survey
You will then go through ...
- 15.9k
2
votes
Is it possible to set up conditional formats using Excel Online?
I have just been using an online Excel spreadsheet and it is now possible to setup conditional formatting in Online Excel.
- 121
2
votes
Keeping a cell formula set to the same cell even when a row is inserted
Use INDIRECT to reference a specific cell. You can write the sheet/cell references longhand in the formula, or build it using variables.
Let's say that you have a sheet "Working", and a ...
- 4,868
1
vote
Accepted
Bulk Search Or Find a bunch of values at once
You want a fast, effienct way to find matches between two sets of order numbers.
Let's assume that one set of order numbers are in Sheet1 and this sheet is to be compared to those on Sheet2, and that ...
- 4,868
1
vote
Copying a cell and pasting in another app pastes the formula not the value
A day later and my excel-online spreadsheets are pasting as expected. Feels like A/B test.
- 261
1
vote
Office 365 Excel set region
The regional settings for Excel online will be determined by the online host, i.e. OneDrive for Business or SharePoint, not by Excel.
In OneDrive for Business, click the cog wheel at the top right, ...
- 251
1
vote
Format Google Analytics Date
You need to use TEXT, instead of TO_TEXT:
=TEXT('90diaspessoas'!A16,"dd-mm-yyyy" )
As long as underlying date number is correct, This will work.
OR
Set formatting in '90diaspessoas'!A16 ...
- 3,098
1
vote
Is it possible to set up conditional formats using Excel Online?
Support: YES
Set up: NO
Edit: NO
Excel Online supports Conditional Formatting with Data Bars, Color Scales and Icon Sets. Select a range to be formatted, and go to Home > Conditional Formatting > ...
- 24.9k
1
vote
Accepted
Using an Excel survey in Office 365 for business
We had the same concern. So we created a new site collection specifically for surveys. Then we turned on the setting "Allow both external users who accept sharing invitations and anonymous guest ...
- 26
1
vote
How to import a csv file into Excel on Microsoft Office Live
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 ...
- 163
1
vote
How to import a csv file into Excel on Microsoft Office Live
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.
- 11
1
vote
How to import a csv file into Excel on Microsoft Office Live
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.
- 11
Only top scored, non community-wiki answers of a minimum length are eligible