Flatfile Portal 2.0 - Normalizing imported CSVs with data hooks

Posted by David Boskovic on Jan 29, 2020 5:26:03 PM
David Boskovic
Find me on:

Flatfile.io - Normalizing imported CSVs with data hooks

Normalizing with data hooks.

This is part 2 of a 7-part deep dive into Flatfile Portal 2.0, view other parts here!

Data Hooks™ are the most powerful new addition to Flatfile: they allow nearly infinite extensibility and customization of import flows. Today’s focus is on how you can use Data Hooks to normalize the data your customers are dropping into the Portal. Two common cases we see are names and dates.

Schedule a 15-min demo

Normalizing human names Flatfile.io - CSV importer - Example use-case for blog

A common data problem we see emerge when importing is when original sources have a full name and your system requires a first and last name (or the opposite). Using data hooks, you can easily employ awesome libraries like split-human-name to normalize values and save users hours of work.

Flatfile.io - Normalize names (split first name or last name) on a CSV import.

ISO formatted dates Flatfile.io - CSV importer - Example use-case for blog

We've all seen the thousands of ways that users provide date values. Thankfully there's awesome libraries like moment.js or date-fns to help normalize human written dates into ISO formats. With data hooks you can not only normalize the values but also run complex analysis - like preventing dates in the future.

Flatfile.io - CSV importer with ISO date formatting

Get started with data hooks

...and so many other use-cases.

A. Convert countries to their ISO codes.
B. Normalize zip and postal codes.
C. Convert monetary values into their currency syntax.
D. Automatically format product codes.
E. Convert values to database reference IDs.
F. Tokenize PII for compliance with products like VGS.
G. Append additional data automatically from an external file.
H. Send us your ideas!
Request access

Flatfile Portal 2.0

Want to get started with the Portal 2.0 public beta? Grab 15 minutes with Eric or myself to review the features you need and make sure they're enabled for your account.


PS. Flatfile is built on your feedback. We appreciate you for helping us build a better experience every day. If you ever have ideas or suggestions, share them with us, or you can even schedule a call with Randy (our product lead) to discuss them.

Flatfile for your CS team? flatfile-io-request-for-input

Does your success or services team spend time on-boarding customer data?

We've got something special in the works, and would love to get your early feedback! Sign-up here to chat with our product team.


Flatfile for Customer Success - Request for input.


Topics: Flatfile, Product Updates, Major Releases, Portal 2.0