Feedback by UserVoice

Bernd

My feedback

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

    We’ll send you updates on this idea

    Thanks for the feedback!

    Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?

    Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.

    Bernd commented  · 

    I 'screenshotted' the wanted process when opening CSVs:
    https://dl.dropboxusercontent.com/u/1761707/excel_csv.png

    >Can you comment on whether you expect this to basically import all the lines as text to column >A, or if you have some other expectation?
    Basically we want to be able to disable excels guessing of the column types for all columns: For example when importing a CSV with two columns "Zipcode" and "Country", a row might look like:
    "04057", "Leipzig"
    Excel will by default assume '04057' ist a number and remove the leading zero in this german zipcode, which basically destroys it (the leading zero is required here and normally software stores zipcodes as strings/text). For larger CSVs it takes a lot of time to set the column types correctly - it would be easier if 'text' instead of 'general' would be the default column-type.

    Also the "Data" > "From Text" Import should automatically be used when doubleclicking CSV-files in Windows Explorer - instead of the regular "File" > "Open" mechanism (which does not allow to set the correct file encoding, field seperator, etc. and will open most CSVs not created in Excel just totally broken)

    Probably duplicates/related suggestions:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13340274-method-for-csv-import-in-excel-2013-is-illogical
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8958493-show-data-from-text-wizard-by-default-when-d

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

    We’ll send you updates on this idea

    4 comments  ·  Excel for the web  ·  Flag idea as inappropriate…  ·  Admin →
    Bernd commented  · 

    Yes an "Add multiple new empty rows after/before selected row" option would be nice.

    Workaround: Create a new empty row and press F4 multiple times
    (F4 repeats the last action)

    Bernd supported this idea  · 
  3. 94 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]

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

    We’ll send you updates on this idea

    Bernd commented  · 

    Yes - Thats how i currently do that - But its annoying if one needs this regularly ;D

    Bernd shared this idea  · 
  5. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Bernd shared this idea  · 

Feedback and Knowledge Base