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
Highlighted
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
Highlighted

@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?

 

Highlighted

@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!

 

Highlighted