EXCEL: How to import Data from Text File
I want to import this text file into excel: ftp://aftp.cmdl.noaa.gov/data/trace_gases/co2/flask/surface/co2_mlo_surface-flask_1_ccgg_event.txt
Every time I import it it puts everything in one column. Someone please help me organize this data into excel. Thank you for your time.
microsoft-excel import
asked Feb 6 at 6:45
user4289755user4289755
1
add a comment |
I want to import this text file into excel: ftp://aftp.cmdl.noaa.gov/data/trace_gases/co2/flask/surface/co2_mlo_surface-flask_1_ccgg_event.txt
Every time I import it it puts everything in one column. Someone please help me organize this data into excel. Thank you for your time.
microsoft-excel import
asked Feb 6 at 6:45
user4289755user4289755
1
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08
add a comment |
I want to import this text file into excel: ftp://aftp.cmdl.noaa.gov/data/trace_gases/co2/flask/surface/co2_mlo_surface-flask_1_ccgg_event.txt
Every time I import it it puts everything in one column. Someone please help me organize this data into excel. Thank you for your time.
microsoft-excel import
asked Feb 6 at 6:45
user4289755user4289755
1
I want to import this text file into excel: ftp://aftp.cmdl.noaa.gov/data/trace_gases/co2/flask/surface/co2_mlo_surface-flask_1_ccgg_event.txt
Every time I import it it puts everything in one column. Someone please help me organize this data into excel. Thank you for your time.
microsoft-excel import
microsoft-excel import
asked Feb 6 at 6:45
user4289755user4289755
1
asked Feb 6 at 6:45
user4289755user4289755
1
asked Feb 6 at 6:45
user4289755user4289755
1
asked Feb 6 at 6:45
user4289755user4289755
1
asked Feb 6 at 6:45
user4289755user4289755
1
1
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08
add a comment |
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08
add a comment |
2 Answers
2
active
oldest
votes
Just follow the instructions in the Microsoft article
Text Import Wizard,
and pay attention to:
- Use Data tab > External Data group > From Text > Import Text File
- Set Original data type to Delimited
- Set Start import at row to 71
- In the next step, set Delimiters to Space (you may also leave Tab),
leaving Treat consecutive delimiters as one as checked - In the next step, leave Column data format as General,
click Advanced and uncheck
Trailing minus, click OK - Click Finish
- In the next step, choose Existing worksheet, leave
=$A$1if you don't
wish a columns header or change to=$A$2if you you want a header - Click OK
- To add the header, select in the file the line starting the selection from
sample_site_code sample_year sample_month sample_day sample_hour ...
- Click the cell A1
- In the Home tab, click the down-arrow next to Paste and choose
Use text import wizard
- Follow the same steps as above to import into
=$A$1
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
add a comment |
As this is neither a comma separated nor a tab separated data, just values separated by multiple spaces, fields need to be defined by you manually.
This adds to what harry has defined above
Scroll down until you can see this actual data, then click at the end of each data point so that a line appears like this, if the click was not at the right place, you will be able to move line to left right by clicking and dragging it.
If you so wish you can even combine three fields so that entire date (1969 08 20) comes in a single cell and you can later on make them to your date format.
once you have drawn all lines till the right end of data, go ahead as is described above.
leading space will automatically be removed from each imported data.
As headers are of different width, those will not come correctly, so you can delete the top most line that has randomly broken headers.
answered Feb 6 at 15:29
VSRawatVSRawat
15512
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402540%2fexcel-how-to-import-data-from-text-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Just follow the instructions in the Microsoft article
Text Import Wizard,
and pay attention to:
- Use Data tab > External Data group > From Text > Import Text File
- Set Original data type to Delimited
- Set Start import at row to 71
- In the next step, set Delimiters to Space (you may also leave Tab),
leaving Treat consecutive delimiters as one as checked - In the next step, leave Column data format as General,
click Advanced and uncheck
Trailing minus, click OK - Click Finish
- In the next step, choose Existing worksheet, leave
=$A$1if you don't
wish a columns header or change to=$A$2if you you want a header - Click OK
- To add the header, select in the file the line starting the selection from
sample_site_code sample_year sample_month sample_day sample_hour ...
- Click the cell A1
- In the Home tab, click the down-arrow next to Paste and choose
Use text import wizard
- Follow the same steps as above to import into
=$A$1
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
add a comment |
Just follow the instructions in the Microsoft article
Text Import Wizard,
and pay attention to:
- Use Data tab > External Data group > From Text > Import Text File
- Set Original data type to Delimited
- Set Start import at row to 71
- In the next step, set Delimiters to Space (you may also leave Tab),
leaving Treat consecutive delimiters as one as checked - In the next step, leave Column data format as General,
click Advanced and uncheck
Trailing minus, click OK - Click Finish
- In the next step, choose Existing worksheet, leave
=$A$1if you don't
wish a columns header or change to=$A$2if you you want a header - Click OK
- To add the header, select in the file the line starting the selection from
sample_site_code sample_year sample_month sample_day sample_hour ...
- Click the cell A1
- In the Home tab, click the down-arrow next to Paste and choose
Use text import wizard
- Follow the same steps as above to import into
=$A$1
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
add a comment |
Just follow the instructions in the Microsoft article
Text Import Wizard,
and pay attention to:
- Use Data tab > External Data group > From Text > Import Text File
- Set Original data type to Delimited
- Set Start import at row to 71
- In the next step, set Delimiters to Space (you may also leave Tab),
leaving Treat consecutive delimiters as one as checked - In the next step, leave Column data format as General,
click Advanced and uncheck
Trailing minus, click OK - Click Finish
- In the next step, choose Existing worksheet, leave
=$A$1if you don't
wish a columns header or change to=$A$2if you you want a header - Click OK
- To add the header, select in the file the line starting the selection from
sample_site_code sample_year sample_month sample_day sample_hour ...
- Click the cell A1
- In the Home tab, click the down-arrow next to Paste and choose
Use text import wizard
- Follow the same steps as above to import into
=$A$1
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
Just follow the instructions in the Microsoft article
Text Import Wizard,
and pay attention to:
- Use Data tab > External Data group > From Text > Import Text File
- Set Original data type to Delimited
- Set Start import at row to 71
- In the next step, set Delimiters to Space (you may also leave Tab),
leaving Treat consecutive delimiters as one as checked - In the next step, leave Column data format as General,
click Advanced and uncheck
Trailing minus, click OK - Click Finish
- In the next step, choose Existing worksheet, leave
=$A$1if you don't
wish a columns header or change to=$A$2if you you want a header - Click OK
- To add the header, select in the file the line starting the selection from
sample_site_code sample_year sample_month sample_day sample_hour ...
- Click the cell A1
- In the Home tab, click the down-arrow next to Paste and choose
Use text import wizard
- Follow the same steps as above to import into
=$A$1
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
answered Feb 6 at 7:21
harrymcharrymc
262k14271578
262k14271578
add a comment |
add a comment |
As this is neither a comma separated nor a tab separated data, just values separated by multiple spaces, fields need to be defined by you manually.
This adds to what harry has defined above
Scroll down until you can see this actual data, then click at the end of each data point so that a line appears like this, if the click was not at the right place, you will be able to move line to left right by clicking and dragging it.
If you so wish you can even combine three fields so that entire date (1969 08 20) comes in a single cell and you can later on make them to your date format.
once you have drawn all lines till the right end of data, go ahead as is described above.
leading space will automatically be removed from each imported data.
As headers are of different width, those will not come correctly, so you can delete the top most line that has randomly broken headers.
answered Feb 6 at 15:29
VSRawatVSRawat
15512
add a comment |
As this is neither a comma separated nor a tab separated data, just values separated by multiple spaces, fields need to be defined by you manually.
This adds to what harry has defined above
Scroll down until you can see this actual data, then click at the end of each data point so that a line appears like this, if the click was not at the right place, you will be able to move line to left right by clicking and dragging it.
If you so wish you can even combine three fields so that entire date (1969 08 20) comes in a single cell and you can later on make them to your date format.
once you have drawn all lines till the right end of data, go ahead as is described above.
leading space will automatically be removed from each imported data.
As headers are of different width, those will not come correctly, so you can delete the top most line that has randomly broken headers.
answered Feb 6 at 15:29
VSRawatVSRawat
15512
add a comment |
As this is neither a comma separated nor a tab separated data, just values separated by multiple spaces, fields need to be defined by you manually.
This adds to what harry has defined above
Scroll down until you can see this actual data, then click at the end of each data point so that a line appears like this, if the click was not at the right place, you will be able to move line to left right by clicking and dragging it.
If you so wish you can even combine three fields so that entire date (1969 08 20) comes in a single cell and you can later on make them to your date format.
once you have drawn all lines till the right end of data, go ahead as is described above.
leading space will automatically be removed from each imported data.
As headers are of different width, those will not come correctly, so you can delete the top most line that has randomly broken headers.
answered Feb 6 at 15:29
VSRawatVSRawat
15512
As this is neither a comma separated nor a tab separated data, just values separated by multiple spaces, fields need to be defined by you manually.
This adds to what harry has defined above
Scroll down until you can see this actual data, then click at the end of each data point so that a line appears like this, if the click was not at the right place, you will be able to move line to left right by clicking and dragging it.
If you so wish you can even combine three fields so that entire date (1969 08 20) comes in a single cell and you can later on make them to your date format.
once you have drawn all lines till the right end of data, go ahead as is described above.
leading space will automatically be removed from each imported data.
As headers are of different width, those will not come correctly, so you can delete the top most line that has randomly broken headers.
answered Feb 6 at 15:29
VSRawatVSRawat
15512
answered Feb 6 at 15:29
VSRawatVSRawat
15512
answered Feb 6 at 15:29
VSRawatVSRawat
15512
answered Feb 6 at 15:29
VSRawatVSRawat
15512
15512
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1402540%2fexcel-how-to-import-data-from-text-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Does you import this file using the master or by VBA code? Does the header lines count can vary?
– Akina
Feb 6 at 7:11
refer to this article: support.office.com/en-us/article/…
– Lee
Feb 6 at 8:08