62 votes29 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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.
I 'screenshotted' the wanted process when opening CSVs:
>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:
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:
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)
94 votes5 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
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.
John [MS XL]
Yes - Thats how i currently do that - But its annoying if one needs this regularly ;D
9 votes2 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →