Turn your exports into the import file your system actually wants.

FlatConvert is a web app from Rooted Software that reshapes your data exports from one system to another, like a Giving or Events platform to CRM and/or a CRM to Accounting system. Build the mapping once, save it as a template, and reuse it every time.

INCLUDED Free with Systems Success
Request a demo →

Not on Systems Success? Get FlatConvert standalone for $35 per month per organization, with unlimited users.

Stop rebuilding the same spreadsheet every month

Lean teams, real missions, and tools like Virtuous, Planning Center, and SiteStacker already in the mix. We focus on your CRM and the data around it. (Businesses are welcome too, the same playbook works.)

FINANCE

Finance teams

Finance and bookkeeping staff who import gifts and transactions into accounting software.

DEVELOPMENT

Development & database managers

Development and database staff who move donor and contact data between systems.

ADMINISTRATION

Church & school administrators

Administrators who prepare lists for mailings, email campaigns, and reports.

MIGRATIONS

Teams changing systems

Organizations mid-migration who need to clean and reshape exports before loading them into a new platform.

What We Help You Build

Real examples of the automations and simple apps we support under LastMile AI

BUILD YOUR OUTPUT

Build your output visually

Upload your source data, design exactly what your destination system needs, and see the results as you build.

↓
Drag and drop upload

Drop in any CSV export and start working immediately.

◫
Source data preview

See a sample of the raw data (5, 25, or 100 rows) before you decide what to change, so you are never guessing at column contents.

+
Column by column output design

Add output columns one at a time and name them exactly what the receiving system expects. Every column shows a live preview of its result.

✓
Inline validation

Row-level error counts appear as you build, so a bad date format or unmatched value is caught before you download.

↳
Multi-step transformations

Stack multiple operations on a single column (for example, map a value, then trim it, then change its case).

TRANSFORMATION TYPES

Reshape your data without code

Clean, combine, reformat, and translate your data using simple building blocks. Flip any card to see exactly what each transformation can do.

→
Direct mapping & renaming
Copy and rename source columns.
Flip for details →
DIRECT MAPPING
Direct mapping & renaming

Copy a source column straight to the output under a new name.

⇄
Split columns
Turn one field into multiple fields.
Flip for details →
SPLIT
Split columns

Break one field into several using any delimiter, such as turning Full Name into First Name and Last Name.

+
Concatenate
Combine multiple fields into one.
Flip for details →
COMBINE
Concatenate

Combine multiple fields into one, with your choice of separator (comma, pipe, space, and so on). Useful for building note or memo fields from an ID, a gift type, and a check number.

◷
Date reformatting
Convert dates into the required format.
Flip for details →
DATES
Date reformatting

Convert dates from the format your source uses to the format your destination requires, including ISO (YYYY-MM-DD) and regional day-first formats.

#
Number & currency formatting
Format numbers, decimals, and currency.
Flip for details →
NUMBERS
Number & currency formatting

Turn text amounts into properly formatted numbers, set decimal places, and add a currency symbol before or after the value.

↔
Find & replace
Replace values across a column.
Flip for details →
REPLACE
Find & replace

Standard find and replace across a column.

⌕
Lookup & value mapping
Translate codes using lookup tables.
Flip for details →
LOOKUP
Lookup & value mapping

Translate codes from one system to another with a lookup table (for example, project codes to accounting codes) and set a default value for anything blank or unmatched.

=
Constant value columns
Add the same value to every row.
Flip for details →
CONSTANTS
Constant value columns

Add a column that contains the same value on every row, such as a source tag or campaign label.

Aa
Trim & case cleanup
Clean spaces and standardize casing.
Flip for details →
CLEANUP
Trim & case cleanup

Trim leading and trailing spaces and apply consistent casing.

Σ
Group by
Group, sum, or count your data.
Flip for details →
GROUP & SUMMARIZE
Group by

Pick specific columns to group by unique values and sum or count other columns accordingly. Great for accounting systems.

TEMPLATES & SHARING

Build it once. Reuse it everywhere.

Save transformations as reusable templates, share them at the right level, and turn repeat data cleanup into a simple workflow.

Save templates

Store any transformation as a named template and run it again with a single click.

Column check before you run

When you select a template, the app confirms that every required source column is present in the uploaded file before it runs.

Share at the right level

Keep templates private, share them with your organization, or publish them globally so every Rooted client can benefit.

Fork and customize

Start from a shared template, fork it, and adjust it for your own needs without affecting the original.

Edit and archive

Template owners can update or archive their templates at any time.

TEAM & ACCOUNT MANAGEMENT

Built for the whole office

Give your team the access they need without adding administrative work or paying for individual seats.

Unlimited
users on every plan

Every plan includes unlimited users, so the whole office can share templates without counting seats.

+
Invite and manage your users

Client administrators can invite new team members, view their team, activate or deactivate users, and set user permissions. No need to go through Rooted to add someone.

→
Simple experience for everyday users

Standard users get a focused view: upload, pick a template, transform, download.

◎
Rooted-supported

Rooted's support team can see your organization and templates when you ask for help, so troubleshooting does not require screen shares and email chains.

OUTPUT

From messy export to import-ready CSV.

Run your transformation and download a finished CSV that is ready to import into your destination system.

Upload CSV → Transform → Validate → Download
Format fidelity: Dates and numbers are written exactly as configured, so they survive the trip into your destination system. Open the file outside Excel to verify formatting, since Excel reformats dates on open.
USE CASES

Where FlatConvert fits

Here are the data flows we built FlatConvert around. Each one takes minutes to set up the first time and seconds every time after. If your systems are already integrated, keep using the integration; FlatConvert is for the gaps in between.

Scenario
The problem
With FlatConvert
01
Online giving into your donor database
Gifts and new contacts arrive in Fundraise Up, WeGive, Qgiv, or another giving tool, but that platform is not integrated with your CRM, so someone re-keys or hand-edits every batch.
Split names, map fund names to CRM fund codes, reformat dates and amounts, and tag each batch with a Source column so the export imports cleanly. Works with any giving tool that can export contacts and gifts to CSV (or to Excel saved as CSV). We recommend this only where a native integration is not already available.
02
File-based imports into other accounting systems
Blackbaud Financial Edge NXT, Sage Intacct, and Microsoft Dynamics 365 Business Central each expect their own journal or receipt import layout.
Build one template per system that renames columns, formats dates and amounts, and maps fund or project codes to the right general ledger accounts, then reuse it every close.
03
Virtuous gifts into QuickBooks
Your Virtuous export uses Full Name, a US date, a text amount, and project codes that mean nothing to your accounting system.
Split the name, reformat the date, convert the amount to currency, map project codes to accounting codes with a default for blanks, and build a memo field from gift ID, gift type, and check number.
04
Bloomerang, DonorDock, Neon One, or CharityEngine exports to accounting or reporting
Each platform exports its own column names, date styles, and code sets. Month-end means rebuilding the same spreadsheet.
Save one template per export type. Finance drops in the new file, picks the template, and downloads an import-ready result.
05
Mailing and email lists
Your mail house or email platform needs specific headers, trimmed values, and a consistent source tag.
Rename columns to match, trim whitespace, normalize casing, and add a constant Source column so you can track results.
06
Feeding your reporting tool
Exports from different systems arrive with different headers and formats, so the monthly report breaks or needs hand cleanup before it refreshes.
Standardize every export into one consistent layout so your reporting tool loads the same schema each time, with no manual reshaping.
07
Church and school data feeds
Giving, attendance, or enrollment data has to move between a ChMS or SIS and finance or communication tools on a schedule.
Build the transformation once, share it with the office team, and let anyone run it without touching a formula.

How it Works

1.     Upload: Drag your CSV export into the app and preview the raw data.

2.     Build: Add output columns and choose how each one is built: mapped, split, combined, reformatted, looked up, or set to a constant.

3.     Check: Watch live previews and row-level error counts, then adjust until the output is right.

4.     Save: Save the process as a template and share it with your team or organization.

5.     Reuse: Next time, upload, pick the template, and download the finished file.

Pricing

Two ways to get FlatConvert. Both include unlimited users, unlimited templates, and access to the shared template library.

SYSTEMS SUCCESS CLIENTS

Included at

$0

additional cost

FlatConvert is included with every Rooted Systems Success package.

WHAT YOU GET

  • ✓ Unlimited users
  • ✓ Unlimited templates — private, shared, or global
  • ✓ Template setup help included in your package

BEST FOR

Organizations already on Rooted managed systems.

STANDALONE

Flat rate

$45

/ month
per organization

One flat price covers your entire team with no per-user fees.

WHAT YOU GET

  • ✓ Unlimited users — invite your entire team
  • ✓ Unlimited templates — private, shared, or global
  • ✓ Template setup help available on request

BEST FOR

Any nonprofit, ministry, church, or school with a CSV problem.

Frequently Asked Questions

Spend your time on the mission, not the spreadsheet.

FlatConvert is included free with Rooted's Systems Success package and just $35 per month per organization for everyone else, with unlimited users either way. Let us show you how quickly your most painful import becomes a one-click template.