Jump to content
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically. 

Sign in to follow this  
BhupendraSingh

Import and Export Data

Recommended Posts

Hello,

I'm using Window 7 operating system. I have a problem; actually I want to import excel data with some filteration and then export it into csv file, I don't have idea that how to do it ; Is this possible? if it is possible then tell me, is there any tool which could performed this task.

Please give me your valuable suggestion.

Thanks in advance!!

Share this post


Link to post
Share on other sites
jaclaz    925

You do not "export" data in .csv format, you actually "Save as" .csv the actual spreadsheet (single sheet).

About importing it greatly depends on HOW EXACTLY the soource data is formatted, no way to give you any "meaningful" answer without some DETAILS.

Excel has a built-in import filter for either "fixed length" or "delimited" data, but it's behaviour may be influenced by a number of factors, including repeated separators and what not.

Also in some cases Excel "automagically" determines *something* to be text or date or number and makes the importing procedure more difficult/prone to error.

You may need to use a "more dedicated2 program such as:

http://record-editor.sourceforge.net/Record02.htm

to do an intermediate conversion.

jaclaz

Share this post


Link to post
Share on other sites

Actually it is not my exactly problem, I want a such type of tool which import any type of file such as .csv, .txt, .sql etc. and export that data in any file extension whatever you want.

Please help me.

Share this post


Link to post
Share on other sites
CoffeeFiend    0

import any type of file such as .csv, .txt, .sql etc. and export that data in any file extension whatever you want.

So it only has to be able to read any format and save in any format? You should have said so sooner, we'd have let you know that magic software doesn't exist?

If you set the bar a little lower, than Excel will do just that (if you know how to use it, much like jaclaz said) with most common formats (or some other programs, for specific given tasks). Anything beyond that will pretty much require you to write your own specialized software for specific jobs.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×