Home

Importing Text/CSV data into current worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-744428%22%20slang%3D%22en-US%22%3EImporting%20Text%2FCSV%20data%20into%20current%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744428%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20choosing%20Data%20%26gt%3B%20From%20Text%2FCSV%2C%20after%20choosing%20an%20CSV%20file%20that%20I'd%20like%20to%20merge%20into%20the%20worksheet%20I'm%20currently%20selected%20in%20the%20preview%20window%20comes%20up%20and%20I%20have%20the%20option%20to%20choose%20'Open'%20or%20can%20change%20to%20'Open%20to'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20is%2C%20when%20choosing%20'Open'%20it%20always%20opens%20a%20new%20worksheet%20and%20imports%20the%20data%20into%20that%2C%20rather%20than%20importing%20to%20the%20current%20worksheet%20that%20is%20selected.%20This%20doesn't%20seem%20like%20the%20correct%20behaviour%20according%20to%20the%20support%20page%20for%20this%20function%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fimport-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba%23ID0EAAFAAA%3DNewer_versions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fimport-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba%23ID0EAAFAAA%3DNewer_versions%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Select%26nbsp%3B%3CSTRONG%3ELoad%3C%2FSTRONG%3Eif%20you%20want%20to%20load%20the%20data%20directly%20to%20the%20current%20worksheet.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20above%20statement%20doesn't%20seem%20to%20be%20the%20case.%20By%20choosing%20'open%20to'%20you%20can%20then%20select%20a%20existing%20worksheet%20although%20these%20are%20extra%20steps%20that%20don't%20follow%20the%20support%20page%20instructions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746363%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Text%2FCSV%20data%20into%20current%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746363%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373242%22%20target%3D%22_blank%22%3E%40kylewatson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20that%20is%20correct%20behavior%20which%20allows%20to%20prevent%20unintentional%20inserting%20of%20the%20imported%20data%20within%20already%20existing%20one%20in%20the%20current%20sheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20my%20point%20of%20view%20support%20page%20is%20not%20quite%20correct.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3B%2C%20what%20do%20you%20think%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746390%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Text%2FCSV%20data%20into%20current%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYou're%20correct.%20Load%20will%20send%20the%20data%20to%20a%20new%20worksheet.%20I've%20updated%20the%20support%20topic%20to%20reflect%20that%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3ESelect%26nbsp%3B%3CSTRONG%3ELoad%20%3C%2FSTRONG%3Eif%20you%20want%20to%20load%20the%20data%20directly%20to%20a%20new%20worksheet.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746396%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Text%2FCSV%20data%20into%20current%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3B%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
kylewatson
Occasional Visitor

Hello,

 

When choosing Data > From Text/CSV, after choosing an CSV file that I'd like to merge into the worksheet I'm currently selected in the preview window comes up and I have the option to choose 'Open' or can change to 'Open to'.

 

Problem is, when choosing 'Open' it always opens a new worksheet and imports the data into that, rather than importing to the current worksheet that is selected. This doesn't seem like the correct behaviour according to the support page for this function:

 

https://support.office.com/en-ie/article/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-9....

 

"Select Load if you want to load the data directly to the current worksheet."

 

This above statement doesn't seem to be the case. By choosing 'open to' you can then select a existing worksheet although these are extra steps that don't follow the support page instructions.

 

 

3 Replies

@kylewatson 

IMHO, that is correct behavior which allows to prevent unintentional inserting of the imported data within already existing one in the current sheet.

 

From my point of view support page is not quite correct.

 

@Smitty Smith , what do you think?

 

@Sergei Baklan You're correct. Load will send the data to a new worksheet. I've updated the support topic to reflect that:

 

Select Load if you want to load the data directly to a new worksheet.

 

Thanks!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies