Feedback by UserVoice

RS

My feedback

  1. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  2. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  3. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    RS commented  · 

    allow to make it negative e.g for date format yyyy-mm-dd.

    Currently 0 equal to 1900-01-00 (which is technically wrong, Excel 2019).

    Make -2 = 1899-12-31. Down to -99,999.

    RS supported this idea  · 
  4. 51 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  5. 117 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  6. 100 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – CSV hasn’t been an area we’ve been looking into recently, but we’ll reconsider. It looks like this is starting to get some votes fairly quickly. If you like the idea, then please keep the votes coming! That’s the best way to help get this onto our engineering schedule.

    Thanks,
    John [MS XL]

    An error occurred while saving the comment
    RS commented  · 

    Perhaps the best solution will be to use templates (formatted and saved as text with extension e.g. xlsxt or so) with instructions as to how to handle particular csv file, store templates in Excel templates folder.

    At an attempt to open a csv Excel should check for the templates, and offer a list of them to the user. There should be a default template, as an example filled with all available options. When user opens csv for a first time (or 3 times), there should be a message that default template (in folder... ) is being used. If only default template is used, after a few times the message will not bother users anymore. Yet, everyone will learn about the feature.

    Templates should indicate handling of all possible situations:
    - at opening: show / hide this template warning
    conversion/preserving of numbers to dates,
    dropping/keeping of leading zeroes,
    use of column separator ( , or. or other ASCII, who cares?),
    use of decimal point in csv
    preserving of ‘ as entered,
    preserving spaces in csv (formatting as text),
    preserving REAL formats as entered (e.g. 1.200000E-2),
    - saving (to csv): saving columns with numbers (specify col.#) with leading zeroes,
    formatting any real as prescribed (e.g. -1.10000E2),
    use of encoding (if saved as csv)

    Template should also indicate rules to save standard xlsx file as csv (appropriate dialog required).

    Benefits:
    1. Satisfy to virtually any weird formatting setup of original csv files
    2. Easy to share particular csv pattern between customers / team members
    3. Allow to handle differently csv files from different vendors (I do know a few of those cases).
    4. Allow user’s company to write and use own template for their csv files
    5. System is adaptable for future needs, if any.

    Some false thought: this system, if implemented will promote all kind of weird csv formats in the world.
    Answer: perhaps this concern can be dismissed because xlsx format is far more useful vs. csv. CSV is only used only when really needed. Any vendor, once csv format is chosen, will strictly maintain it – if you work with that vendor – adapt for formatting. To be done just once, quite simple, not a problem.

    Far better than today’s need (in my case) to open csv with Word (set as default) then use macros to reformat it into something “unhurtable”, only then open with Excel. And reverse process to save as csv. I did it quite a few times… Time consuming… Expensive… It should be fixed…

    RS supported this idea  · 
  7. 169 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    RS commented  · 

    double-click to move is very useful feature for me.
    i'm working with quite large files almost daily.
    often need to move to last row / top row of data.

    please do not remove it yet make it optional for those, who do not want it.
    may be selectively for moving by columns and moving by rows.

  8. 223 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  9. 728 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.

    Sorry that we’ve been slow to comment and update the status on this one.

    Steve K [Excel]

    RS supported this idea  · 
  10. 1,489 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

    RS supported this idea  · 
  11. 1,868 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  12. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  13. 33 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  14. 52 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  15. 61 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  16. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  17. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  18. 615 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    RS commented  · 

    @John [MS XL] 61322055-excel-team-msft
    John, you responded in Nov 2015; since then you guys released office 16 and office 19, and neither version have ANY of numerous suggestions implemented.
    Note, your competitors are continuously improving their products. It may be too late for msft to react when customers will turn away from msft considering office alternatives sufficiently featured.

    RS supported this idea  · 
  19. 68 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
  20. 237 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    RS supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base