How I can convert or import a qif/ofx/qfx file to Excel file format. Could
you please help me about that.
--
Sam

Hi Sam,

Yes, you can definitely convert or import a qif/ofx/qfx file to Excel file format. Here are the steps you can follow:

1. Open Microsoft Excel on your computer.
2. Click on the "Data" tab in the top menu bar.
3. Click on "From Text/CSV" in the "Get & Transform Data" section.
4. Navigate to the location where your qif/ofx/qfx file is saved and select it.
5. Click on "Import" to open the "Text Import Wizard".
6. Select the file origin as "Windows (ANSI)" and the file type as "Delimited".
7. Click "Next" and select the delimiter that separates the data in your file (usually a comma or tab).
8. Click "Next" and select the data format for each column (e.g. "Text" for a column with text data).
9. Click "Finish" to import the data into Excel.

Once the data is imported, you can manipulate it as needed using Excel's various functions and tools. You can also save the file in Excel format by clicking "File" in the top menu bar, selecting "Save As", and choosing "Excel Workbook" as the file type.

Hi Sam,
There is an online converter from qif to csv here . http://shamikshah.com/code/qif2csv/Converter.html

And an Excel add-in here.http://www.macgyver.org/software/quickaccess.html


John



"Sam" wrote in message ...
How I can convert or import a qif/ofx/qfx file to Excel file format. Could
you please help me about that.
--
Sam

I found one program, Financial File Converter, that more or less does the job
(have only tried the 20-entry freeware version), but the date comes out in
European style (14/10/2009) for October 14 -- my other excel files are all
10/14/2009, and I don't think the data will date-sort properly if the day
comes before the month.

I'm unclear how to use the online conversion program. Wlhen I open the qif
file with a program like notepad and paste it into the left hand column, it
doesn't seem to understand how to return a document in rows and columns
format.

An elusive program called qif2csv.exe seems to exist, but I can't find a
site that will download it -- I can get to various sites that promise
downloading, but then I get redirected to some other software instead.

Any help? The idiotic bank (Barclay's?) where we've opened a new credit
card account won't download in CSV format!

Thanks,

Peter

"jaf" wrote:

Hi Sam,
There is an online converter from qif to csv here . http://shamikshah.com/code/qif2csv/Converter.html

And an Excel add-in here.http://www.macgyver.org/software/quickaccess.html


John



"Sam" wrote in message ...
How I can convert or import a qif/ofx/qfx file to Excel file format. Could
you please help me about that.
--
Sam

Try Bank2CSV at http://www.bank2csv.com

It does a great job recognizing various date and numeric formats in your source files. CSV files it creates are Excel compatible.