Need help to input data into Excel

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

Hello! I am trying to import data of library references
resulting from various library searches of electronic
databases (Social Science Abstracts, MedLine, etc.). I can
export the data in a text file. However it includes
additional information that I do not need. And I need to
create some type of database or spreadsheet (Excel,
preferably) to manage the data. Any suggestions on how to
get the data from the text file to Excel? There are
approx. 25,000 data references that I need to export so
cut/paste would be too time-consuming.
 
Trish,
Data > Get External data > Import text files You may have
to change the file type to show all files depending on
your text file type.
Good luck
ray
 
Back
Top