Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

(80% Discount Ends Soon!)

Import Data into Excel

Want to import a bunch of financial data that's in Excel into Quicken.
Can I create a QIF file from Excel?

I have a text file with over 2,000 names that look like the following:

Mr. Benoit Smith
120 Adam Street
Dorchester, MA 02124

Marcus Darbouze
1553 Blue Hill Avenue
Boston, MA 02126

American Public Health Initiatives
10 Fairway Street
Mattapan, MA 02126

Most consist of 3 lines some as many as 5. The text file has no
delimiters so that when I import/open it in Excel it becomes just one
very long column. I need to convert it or parse it into any other
database friendly importable format i.e., .dbf, .xls, .csv etc. What I
need is to convert it into a table with up to five header rows:

head1 head2 head3 head4 head5

Please help, I've been at it for way too many hours.

P.S. Please keep it simple if possible, Excel is all new to me.


From within Excel, I would like to import MS Project data from a particular
project file. I do not want to go into Project and export data or perform a
copy-and-paste. I do want to do this from within Excel and presume that it
requires a DB query...


Does anyone know how to increase the number of rows that Excel can import or
read? My version is XP pro. Now the limit is about 65000 rows. I have data
sheet that is much more than that. Thank you.


I have a data set that consists of approximately 235,000 rows. How do I
import 65000 rows into an Excel spreadsheet and then the next set of 65000
rows into a second Excel spreadsheet and so on and be sure that I'm not
importing rows from the previous spreadsheet into the new spreadsheets?

Hi everyone,

I've referred to this forum for help a few times now, but this is my first post. Here goes...

I've got a folder with approx 25-30 files in it. Each file is a list of clients (1 per row), and I've manually gone through each list and color coded the rows based on client status. What I'd like to do now is create a "master" workbook for this folder, with each sheet in the master dedicated to a color. That way I have one central place where I can see all clients with the same status for the month.

So, I guess my questions a
a) Is it feasible to do an import from this many sources?
b) How do I filter the import query based on row color?

Thanks for your help!


Is it possible to set an xsd schema to import data in excel from an xml
Excel "intelligent" way to import data from xml is too "smart"!
We have phone numbers that begin with 0, and excel thinks that are numbers
and trim the first zero.

Thanks for any help

On my companies host system we store dates with only two digit years and we
use pivot dates to interpret correctly. When I create an extract of these
dates and import into excel they are not interpreted as the correct century.
I have already changed the regional settings to accomodate this and when I
just key a date into excel cell such as 12/1/30 it comes back correctly as
12/1/2030. However, the same date in my import will come out as 12/1/1930. I
think it has something to do with the import but I am not sure what.

Thanks for any suggestions.

Usually the paragraph is split into different cells during import and what is
the best way to ensure they copy onto a single cell.


Is it very complicated to set up a template in excel to import data from an
E.D.I. (Electronic Data Interchange) file? I have a pretty extensive
knowledge of basic excel functions, and a beginner's knowledge of VBE. Any
advice as to where I could start?


Hi there!

I'm using Excel 2003 to do analyse large textfiles, to do this I regularly
imports text to Excel, but unfortunately I've realized that there are some
limitations when importing text files.

I have a text file which has more that 65536 lines (which is the maximum row
numbers in one Excel worksheet), when I import this in Excel I first fill one
Now - the great thing is that I should be able to import the rest of the
textfile on another worksheet, so I start the "Text Impor Wizard", but when
using the feature "Start import at row" - the maximum row number I can type
is 32767... :-(

Of course I can start deleting lines from my textfile - but...

Please - Would you plan on changing this, so that this scenario would be
possible to solve?

Best Regards!
Mikkel Randorff Hegnhøj

I am trying to import a table, separated by delimiters, from the web. The
table's data changes frequently. I can use text-to-columns to sort the table
into the proper columns, but don't want to have to do this every time I
refresh the data. Is there any way around this? Heres the table I'm talking


Thank you,

When I import a csv file with fields in the format "n/n" where n is any
integer, Excel automatically converts that field into a date, i.e. "Jan-01."
How do I stop Excel from doing the automatic conversion? I want to keep the
data in its original format. I'm using Excel 2000 9.0.3821. Thanks.


Which options do I have to import a text file to Excel, with more than
200.000 records.



I would like to import data from a com port into an excel spreadsheet.
I can not find an example in help either on line or local.
Would I have to capture the data fisrt in a text file or can I import
I am using Excel2003.

I have a database written in programme called Paradox and I would like to
fransfer it into Excel.

I frequently have to import data from an accounts report txt file into Excel
2K, via the Text Import Wizard, fixed width mode. Is there any way to save
the column width settings for future re-use?

Can you import data from a scanner into an excel spreadsheet?

Does anybody know of a way to automatically fire the Text Import Wizard
in excel. What I am trying to do is create an asp page for my users
which contains links to reports. These reports are text files which
need to be imported into excel. By clicking on the link my users will
open the file in excel and be prompted with the Text Import Wizard to
format the columns. As we run many thousands of different reports I
think that it would be impossible to predefine the columns, so this
must be done by the end user when they open it.
I have tried naming the text file as .csv and .xls, but they just open
with everything in the first column.

I received a file with an extension snp, is there any way I can convert or
import to MS Excel format?


I need to import a text file of data where the delimiter between fields is a
carriage return.
Gordo T

Hi!,,, this is my situation. I have a user level password protected Access
Database and an Excel spreadsheet in which I need to load a query from the DB.
I am following these steps in excel: Data - Import External Data - Import
Data. But when I select the .mdb I want to import data from, and I fill the
fields user name and password, this happen with two different scenarios:

1- If the test connection button is pressed, the error message is "Test
connection failed because of an error in initializing provider. Cannot start
your application. The workgroup information file is missing or opened
exlucsively by another user." Well, I have a workgroup file, but don't know
how to load it during the import process.

2- If I simply press Ok, a second window appears with the legend "Please
enter MS JET OLE DB Initialization Information", I leave the fields with the
default data (the field "Provider String" is blank by defult) and press Ok,
then nothing happens, nor error message nor data imported.

If somebody has a suggestion, it would be highly appreciated!

I'm having some trouble in Excel. If I create a plain text file like the following:

=sum(a1:a2), =sum(b1:b2)

Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and so on. This really sucks as I can't just install other software on the server nor make other modifications.

I don't know what Microsoft was thinking when they translated the versions; any Excel version should accept it's language commands and English commands, but well, that's too much to ask for...

Any good sugestions?


If I am in an excel spreadsheet and I try to open a .txt file, the test
Import wizard used to open so I could determine columns and data etc. Now,
when I try to open the file, the wizard does not open..excel opens with a new
spreadsheet. How do I get the wizard to open again? My firm re-imaged my
machine and all kinds of things are off.
Old Bob

I am trying to import data from RightFax into Excel. Any ideas?


This is probably wishful thinking, but is there a way to import one text file into Column A, for example, and another text file into Column B, so they line up next to each other ? They are large files, so I don't want to have to cut and paste, if possible.

Thanks for any help !

I can NOT import a simple comma delimited file below in to Excel, althought I
used " as text qualifier, and COMMA as delimiter. Excel (version 2003)
persistenly parse it as having 3 fields rather than having only 2 fields.

"Income - $10,000 - $19,999", "Income - $20,000 - $29,999"

Could you please enlighten me? Thanks!


I have an application that creates CSV files that I need to convert to EXCEL
format. I'm looking for a method that will enable my app to use some tool to
do the convertion in a batch mode. For example, I owuld like to be able to
invoke excel using some switches that will batch-convert the csv file into
excel format.

I looke at excel and the relevant help but to no avail. Does anyone here
know how to do that or have some idea? Or maybe there is some other tool that
can do this (I prefer a free tool)?



In IE, when I go to
http://ichart.finance.yahoo.com/tabl...=m&ignore=.csv ,
I get an Excel spreadsheet of monthly prices.

Is there some way (using the keyboard, not someone's tool)
that I can import that data directly into a spreadsheet?

When I tried to go to that URL using New Web Query,
nothing happened after I responded to the prompt to open
or save. (I clicked "open".)

I have a large mailing of about 65,000 pieces. I need to print variable
addresses and other variable data onto the forms. So, I basically need to
create a template in Microsoft word and import variable data (such as unique
address and account numbers) onto the form. I will then need to store the
data in a standard file type to send to the printers.

I am trying to set up gradebooks for school teachers. I have an Access
parameter query that returns the students in a particular class when the user
enters the class name. I would like to use that query to insert the student
names in an Excel template. I have found multiple examples of how to import
data from Access if I am willing to use a blank database, but I need to
import to a template set up to keep track of grades and absences.

Thank you!

Thanks Lakebum

I tried to change where excel looks for files and messed up.
Now when i open excel it tries to open all my excel files and i get 2 error msgs
1. html import errors problem came up in the following areas during load. missing file
2. microsoft excel first.pps file form is not valid.
I all cases all of the excel files are frozen and i cannot get to any of them. If i click on ok or cancel it goes thru the open
all files again with same results.
I trie to uninstall excel and reinstall but get same results.
can anybody help me and show me how to make excel point
to the folder i want?

I have a CSV file and I wish to cretae a pivot table out of this.
I have written a macro to import this csv to access and then another
macro to create pivot.

My problem is that I run first macro from access and second from excel.

Is it possible to create a VBA code which will ask me name of the
access databse , location of the CSV file and the name of the excel
work book and do the all three task by using above macros?

A code example will be a great help.

How can I rename or change the labels on my pivot using VBA so that
code goes in my second macro .

So I have a folder with over 100 pdf files, and I have to create a spreadsheet with all those filenames...just the names of the files, no data from the actual files. I had to do this a long time ago (like a year ago), and I found an Excel Add-in that did it for me. I just selected the folder and it would import all the filenames for me.

Anyone know a way to do this? I can't seem to find that add-in. I really need this to save a lot of time on this project.

Thanks in advance for any help!!

I used the macro published but the added recordset will show only if I close and reopen the Access database.
Is it possible (and how) to show immediately the added recordset?

Thanks a lot in advance.

I need to import a big list of file names that are .jpg into a Excel sheet but cant seem to find a way of doing it.

I just need the file names, not the picture.

Regards BVG

Is there a method in Excel 2003 to open a blank workbook and then open or import several small text files in a folder (about 200 files) and have Excel automatically create multiple sheets in one workbook that contains data for each text file per sheet?

I remember my original Excel, when I opened a txt file, I would be allowed to delineate where columns ended, and move the column markers around. I am using Execl 2000, and I am not allowed to set column separators, other than by specifying the delimiter character.

My problem is that I am importing an error log that only has spaces to separate columns, but also has spaces in the descriptive section that should be one column.

What happened to Excel allowing you to combine columns? Is there any way around this problem?

Hi all,

I am importing/exporting calendar data between my Outlook calendar and an Excel (.csv) file. I would like to automate this process with macros, ideally run from Excel.

The importing/exporting function is in Outlook. When I record a macro in Excel, it stops recording when I switch to Outlook. Outlook has macro functionality but no record option.

Can anyone offer a suggestion or provide code that will enable this?

Export Process
File > Import/Export
Choose an action to perform: Export to file
Create a file of type: Comma Separated Values (Windows)
Select folder to export from: Calendar
Save exported file as: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
Replace Existing file?: Yes
Set Date Range 1/2/2008 and 30/12/2010

Import Process
File > Import/Export
Choose an action to perform: Import from another program or file
Select file type to import from: Comma Separated Values (Windows)
File to import: C:\Documents and Settings\Robert\Desktop\CalendarImport3.csv
Options: Replace duplicates with items imported
Select destination folder: Calendar

The automation is complicated by the need to save and close the excel file prior to importing or exporting to/from it.

Happy to elaborate further if required.

Thank you in advance for any assistance.



I want to import text files into excel. I need all columns to be imported as text, so as to keep them looking exactly as they are in the text file. I had no problem at all doing this manually, by choosing, in the import text wizard to import all columns as text, and not as general, which is the default. But I would like this to be done automaticaly. Is there any way to change the default for importing text to "text" instead of "general"?
Thanks to anyone who can help me on this.


I think this time a have a special little problem to figure out for our excel lords in here ^^

I have around 200 files, all named from 001.xls to 200.xls, all containing the same format, the same number of colums, but a different number of lines.

Now I have the great task to actually open all these files and copy each files data into one file and start analyzing it. Well, since I personally have no interest to open, copy and paste 200 hundred times, I am wondering if there is any faster way to let excel automatically copy the data into this master file?
I am thinking about somehing like *='001.xls'Sheet2!B2:E20*

One thing is that each file never has more than 20 entries, thus i would only need excel to import the from line 2 to 20 from a certain file and then do same thing all over again with the next file.

Every suggestion is welcomed!
Thanks a lot!


I am trying to use MS Query to first combine text files into one table of data and then import it to Excel. I have a data with identical amount of columns and with identical column headers in every file.. what would be the best way to do this..? thanks!

Hi All,

I am imporiting data into eXcel sheet from access database. And when i use simple SUM functionality on one of the column its not working.

Its working fine when i myself write somedata ( doesnt matter if its all number or not ).. I tried converting them into Number format too but still no luck.

Does anyone have any idea about this ?

I want to import several columns from a workbook (closed) into a new workbook and be able to refresh the data every time the new workbook is open. Is this posible using import or I must use formulas?

I'm trying to get real-time updates of a golf leaderboard, and I tried using a web query, but it didn't show the golfers' info in Excel. I have Office 2000 (yeah I know it's ancient). Can someone please help me? Here is the web address:


Thanks in advance!

Check out www.youtube.com/mycsula for our newly completed series of online SPSS (now IBM Statistics) video tutorials.

Learn how to: define variables, import/export data to SPSS, enter data, run a paired samples t test, perform frequency analysis, use scripting and syntax files, create and edit charts and graphs, and much more.

Training modules cover a wide range of topics aimed at beginners to more advanced users. All videos include examples and instructions to help you with whatever area of research or analysis you are working on.

You can find these videos at mycsula. Check them out and subscribe to our channel today!

The ITS Online Training team

Hi everyone,
I have imported a tab delimited text file into excel. One of the columns consists of a string of text - a comment section. Within this column, there are periods and for some reason it seems that Excel is treating these periods as row separators. Does anyone know how I can prevent Excel from separating the text into rows?
Thanks in advance for any insights.

I'm trying to import a text file into excel. The file is tab delimited and uses double quotations as a text qualifier. One of the fields in the text file is a note field and every now and then the person entering the note uses a carriage return (hits the enter key) while doing so. When this comes through in the text file it looks like this...

"this is a note.
this is the second line of the note"

My understanding is that everything between the two instances of text qualifers should be treated as a single value and the carriage return disregarded. However when I import it the data comes in exactly as it is above which causes field types and column headings to not match up.

Can anyone tell me a way around this short of manually deleting each carriage return?

How do you import a color scheme from another workbook in Excel 2010? I could do it in previous versions....now I don't know what to do. Thanks.