Home

Automatically start Excel & open csv file using _auto.csv

%3CLINGO-SUB%20id%3D%22lingo-sub-103651%22%20slang%3D%22en-US%22%3EAutomatically%20start%20Excel%20%26amp%3B%20open%20csv%20file%20using%20_auto.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103651%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20with%20earlier%20verions%20of%20MS%20Excel%20when%20a%20file%20with%20the%20filename%20extension%20_auto.csv%20or%20.auto.csv%20was%20download%20or%20copied%20on%20my%20PC%20Excel%20would%20automatically%20open%20and%20import%20the%20csv%20file.%20Now%20with%20365%20it%20starts%20Excel%20but%20does%20not%20open%20the%20file%20...%20I%20assume%20there%20is%20a%20setting%20or%20assocation%20issue%20here%20but%20I%20cannot%20find%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EIvan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-103651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103807%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20start%20Excel%20%26amp%3B%20open%20csv%20file%20using%20_auto.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103807%22%20slang%3D%22en-US%22%3E%3CP%3EIvan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see.%20Can%20say%20nothing%20about%20auto-opening%2C%20as%20for%20the%20empty%20window%26nbsp%3Bon%20opening%20such%20issue%20exists%20with%20Excel%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F2994633%2Fexcel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F2994633%2Fexcel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a%3C%2FA%3E%20if%20something%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103795%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20start%20Excel%20%26amp%3B%20open%20csv%20file%20using%20_auto.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%20%2C%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20response%2C%20but%20no%2C%20I%20don't%20think%20you%20did%20understand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20If%20a%20file%20name%20contains%20the%20_auto.csv%20or%20.auto.csv%20as%20the%20filename%20suffix%20....%20as%20an%20example%3C%2FP%3E%3CP%3Esomefilename_auto.csv%20as%20opposed%20to%20somefilename.csv%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20On%20older%20versions%20(Excel%20even%20with%20W10)%20when%20such%20a%20file%20is%20downloaded%20onto%20the%20C%3A%20drive%20from%20an%20external%20source%20MS%20Excel%20automatically%20starts%20and%20opens%20the%20file%20in%20the%20first%20sheet.%20This%20also%20works%20for%20files%20like%20somefilename_auto.pdf%20(opens%20Acrobat%20and%20the%20file%20automatically).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%26nbsp%3B%20With%20a%20new%20system%20with%20current%20versions%20of%20Windows%2010%20%26amp%3B%20Excel%20265%20this%20no%20longer%20happens.%3C%2FP%3E%3CP%3EWhen%26nbsp%3B%20the%20file%20(somefilename_auto.csv)%20is%20downloaded%20Excel%20opens%20but%20with%20an%20empty%20window%20not%20even%20a%20blank%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%26nbsp%3B%20The%20file%20can%20then%20be%20opened%20manually.%20Alternatively%20once%20the%20file%20has%20downloaded%20and%20Excel%20closed%20double%20clicking%20on%20the%20file%20opens%20Excel%20and%20the%20file%20as%20expected%2C%20or%20if%20Excel%20is%20already%20open%20before%20downloading%20the%20file%20then%20the%20file%20opens%20in%20a%20new%20Excel%20sheet%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%26nbsp%3B%20So%20the%20question%20is%20why%20would%20Excel%20open%20automatically%20on%20the%20download%20of%20the%20file%20BUT%20NOT%20open%20the%20file%20itself%20as%20happens%20with%20older%20versions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20explains%20the%20issue%20better%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregards%3C%2FP%3E%3CP%3EIvan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103722%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20start%20Excel%20%26amp%3B%20open%20csv%20file%20using%20_auto.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103722%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ivan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20special%20settings%2C%20Excel%202016%20works%20with%20.csv%20files%20as%20all%20previous%20versions.%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20I%26nbsp%3Bunderstand%20correctly%20-%20you%20double%20click%20on%20csv%20file%2C%20Excel%20starts%20but%20after%20that%20you%20see%20only%20empty%20window%20without%20any%20messages%3F%3C%2FP%3E%3CP%3EAnd%20-%20can%20you%20open%20the%20same%20file%20from%20within%20opened%20Excel%3F%20Did%20you%20try%20to%20open%20csv%20from%20other%20locations%20on%20your%20PC%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, with earlier verions of MS Excel when a file with the filename extension _auto.csv or .auto.csv was download or copied on my PC Excel would automatically open and import the csv file. Now with 365 it starts Excel but does not open the file ... I assume there is a setting or assocation issue here but I cannot find it.

 

Please advise.

Thank you

Ivan

3 Replies
Highlighted

Hi Ivan,

 

No special settings, Excel 2016 works with .csv files as all previous versions. 

Did I understand correctly - you double click on csv file, Excel starts but after that you see only empty window without any messages?

And - can you open the same file from within opened Excel? Did you try to open csv from other locations on your PC?

 

Hi Sergei ,

Thank you for the response, but no, I don't think you did understand.

 

1.  If a file name contains the _auto.csv or .auto.csv as the filename suffix .... as an example

somefilename_auto.csv as opposed to somefilename.csv

 

2.  On older versions (Excel even with W10) when such a file is downloaded onto the C: drive from an external source MS Excel automatically starts and opens the file in the first sheet. This also works for files like somefilename_auto.pdf (opens Acrobat and the file automatically).

 

3.  With a new system with current versions of Windows 10 & Excel 265 this no longer happens.

When  the file (somefilename_auto.csv) is downloaded Excel opens but with an empty window not even a blank sheet.

 

4.  The file can then be opened manually. Alternatively once the file has downloaded and Excel closed double clicking on the file opens Excel and the file as expected, or if Excel is already open before downloading the file then the file opens in a new Excel sheet correctly.

 

5.  So the question is why would Excel open automatically on the download of the file BUT NOT open the file itself as happens with older versions?

 

I hope this explains the issue better?

 

regards

Ivan

Highlighted

Ivan,

 

I see. Can say nothing about auto-opening, as for the empty window on opening such issue exists with Excel 2016.

 

Please check this https://support.microsoft.com/en-us/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-... if something helps.

Related Conversations
Excel Help with If formula
Mightyxr8 in Excel on
0 Replies
Removing unnecesary characters
Ocasio27 in Excel on
2 Replies
Excell spread sheet
CDeyzel1600 in Excel on
1 Replies