+ Reply to Thread
Results 1 to 2 of 2

Importing selected data from a CSV file to excel

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Seattle, WA
    MS-Off Ver
    excel 2010
    Posts
    1

    Post Importing selected data from a CSV file to excel

    Hi all, this is my first post here.

    Like the title states, is it possible to import just a portion of a csv file into my excel workbook? For example:

    My csv file has data from 2010-2015. I want to somehow import only data between 2013-2015 from the csv file into my excel workbook every time I click refresh.

    I cannot delete data from the source file because many other people are using the same file. Is there some sort of "SQL" for excel that makes it possible to trim csv file?

    Thanks,
    Jon

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Importing selected data from a CSV file to excel

    In Excel 2003, and probably in your version there is an external data 'Import Wizard'.

    1. Go to Data > Import External Data > Import Data
    A 'Select Data Source' screen will appear.

    2. At the bottom of the screen 'Files of Type', select the Folder that contains your data,
    select 'Text files (*.txt; *.prn; *.csv; ...', then 'double click' on the file you want to Import.

    3. Import Wizard Screen 1 should be self explanatory (delimited or fixed width; starting row).
    Click on 'Next' when you are done with Screen 1.

    4. Import Wizard Screen 2 lets you select one or more delimiters (tab, comma,...) if a
    delimited file, or the width of each field if a fixed width file.
    Click on 'Next' when you are done with Screen 2.

    5. Import Wizard Screen 3 lets you select the format of each column, and which columns to SKIP.
    Click on one column at a time and make your selections.
    Click on 'Finish'. The Wizard then asks where you want the data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing data ranges from an Excel file with VBA into a another excel file
    By Jay1357 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2013, 06:06 PM
  2. need help with importing data from another excel file
    By truebluesubaru in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-03-2013, 06:29 AM
  3. help importing data from word file into excel
    By BBLANCOBRNX in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-11-2012, 04:25 PM
  4. Importing data from one Excel file to another
    By Trainee in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 07:37 AM
  5. Importing Filenames and Other File Data into Excel
    By martin_b in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 09:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1