QuickConverter Instructions: Advanced CSV Import

2/17/2026

Learn about the advanced features available when importing your bank data as a spread sheet or CSV.

How to convert all positive amount column in 3 steps.

Here are some screen shots from Excel, but it also works the same with Google Sheets and other spreadsheet apps.

  1. Example formula:
    =IF(C2="credit",D2,-1*D2)
    Just change the cell references, in this case C2 and D2, to match your spreadsheet. Then copy it down for all rows.
Example formula to convert column of amounts to positive and negative numbers
  1. Copy the new amounts. Then, right click on first value of the old amount column. Select Paste Special > Values to write the new values as plain numbers.
Copy the amounts and paste special as values
  1. Remove all the extra columns, and save your work.
Remove extra columns and here is the final spreadsheet to import

Awesome. You're getting the Pro Plan

Let's start with your email address

Send a Message

If you had some trouble, make sure to include enough details about what is happening so we can reproduce the same situation and fix it. Thanks!

Your Name
Your Email Address*
Your message is too short
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Sign In

First time? A free intro account will be created for you.

We'll email you a passcode. Confirm it on the next screen.

Email sent to: . The code is valid for 20 minutes.

Didn't get an email? Click here to email another code

Account Settings

Email
Danger Zone

Are We Breaking Up?

By canceling your subscription you will not be charged again, and you can use QuickConverter until the current period end date..

Where did things go wrong?

Anything else you'd like to let us know?

Update Payment Method

Logging out

Warning: Logging out permanently erases all files and work stored on this device. This history is never uploaded to the server. Afterwards you won't be able to resume your work, and we'll only be able to tell you whether a file was imported before — not restore it.

QuickConverter Logo iconQuickConverter