This is legacy documentation maintained for backward compatibility. For the most up-to-date information, please refer to the current documentation.
In Flatfile, mapping describes the process of getting data from an uploaded
file into a destination worksheet in your application.
The Ghost of Mapping Past
Historically mapping in Flatfile has consisted of two pieces:
A field mapping which describes which columns in the source data
corresponds to which fields in the destination worksheet. For example, maybe
the “fname” column in the source data should be mapped to the “First Name”
field in the destination worksheet.
For every destination field of type enum, an
enum mapping describing which values in the source column correspond to
which allowable enum values in the destination column. For example, you could
have an enum column of country codes, and you might need the source value
“United States” to map to the enum value “US”.
Flatfile has developed machine-learning models trained on millions of historical
mappings that can suggest both field and enum mappings based on the column names
and values in the source data. You can of course override these suggestions. The
Flatfile platform remembers your previously chosen mappings and will suggest
them when it sees similar schemas / data in the future.
The Ghost of Mapping Present
Many users of Flatfile need more control over the mapping process than just
assigning source fields to destination fields. For example, you might need to
concatenate multiple source fields into a single destination field, or you might
need to choose the first non-empty value from a set of source fields.To this end, we’ve recently introduced a wider variety of
mapping rules
that specify these more complex mapping-related transformations on your data,
and the notion of a mapping program that selectively applies these rules to
your dataset.As of right now the only rule type supported by the Flatfile application is the
assign rule, as described above.However, we have introduced a
Python SDK that
allows you to create your own mapping rules and mapping programs and apply them
to your own datasets outside of Flatfile (e.g. in an ETL pipeline). The SDK is
currently in extreme beta, but we would love to hear your feedback on it. It
supports the full complement of mapping rules, as described on its website.If you have a Flatfile secret key, the SDK also exposes an “automapping” feature
that uses the previously-described machine learning models to suggest mapping
programs for a given source and destination schema. As with the Flatfile app,
this feature currently only provides assign rules (and also ignore rules
that don’t do anything but just communicate that a source field was not mapped).
The Ghost of Mapping Future
In the near future we will be expanding mapping in several ways:
Richer Mapping Rules in the Flatfile application
We are working on adding support for the full set of mapping rules in the
Flatfile application. This will allow a user mapping an incoming file to create
complex mapping programs, save them, and reuse them.
Richer AI Assist for Mapping Rules
Currently our machine learning algorithms only suggest “assign” rules. In the
future they will also be able to suggest more complex mapping rules; for
instance, if your incoming data had a “first name” and “last name” field, and
your destination sheet only a “full name” field, the AI might suggest a
“concatenate” rule that combines the two source fields into the destination
field.In addition, we are working on a natural-language interface for creating mapping
rules; for instance, you could type “concatenate first name and last name into
full name” and the AI would produce the appropriate rule.
JavaScript SDK
We are working on a JavaScript SDK that has similar functionality to the Python
SDK, the most notable difference being that it can’t interact with Pandas
dataframes. It will be available soon.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Flatfile Developer Docs","colors":{"primary":"#4C4ED9","light":"#ACD8FC","dark":"#113264"},"logo":{"light":"https://mintcdn.com/flatfileinc/z5XZrucoygPxgKQc/static/logo/logo-black.png?fit=max\u0026auto=format\u0026n=z5XZrucoygPxgKQc\u0026q=85\u0026s=16fd3e9dd6f6d554a2dc94c69aa2a082","dark":"https://mintcdn.com/flatfileinc/z5XZrucoygPxgKQc/static/logo/logo-white.png?fit=max\u0026auto=format\u0026n=z5XZrucoygPxgKQc\u0026q=85\u0026s=713d5a31637ce27daaadb8edf049a53e"},"favicon":"/static/favicon.png","background":{"color":{"dark":"#1B1B1E"}},"navbar":{"links":[{"icon":"slack","href":"https://flatfile.com/join-slack/","label":"Community"},{"icon":"mail","href":"mailto:support@flatfile.com","label":"Contact Us"}],"primary":{"type":"button","label":"Platform","href":"https://platform.flatfile.com"}},"footer":{"socials":{"x":"https://x.com/flatfile","github":"https://github.com/FlatFilers","linkedin":"https://linkedin.com/company/flatfile"}},"fonts":{"heading":{"family":"Flatfile Diatype","source":"https://flatfile.com/fonts/FlatfileDiatypeVariable.woff2","format":"woff2"},"body":{"family":"Flatfile Diatype","source":"https://flatfile.com/fonts/FlatfileDiatypeVariable.woff2","format":"woff2"}},"icons":{"library":"lucide"},"styling":{"latex":false},"banner":{"content":"**Welcome to the new Flatfile Developer Docs!**\n\n [Learn more](https://flatfile.com/docs/welcome-to-new-docs).","dismissible":true},"errors":{"404":{"redirect":true}},"contextual":{"options":["copy","view","chatgpt","claude"],"display":"header"},"integrations":{"koala":{"publicApiKey":"pk_6bf7c03b55e41304acf993aafa7e9d40c1d9"}},"navigation":{"global":{"anchors":[{"anchor":"API Reference","icon":"book-open","href":"https://reference.flatfile.com"},{"anchor":"Changelog","icon":"scroll-text","href":"https://flatfile.com/docs/changelog"},{"anchor":"Platform","icon":"rocket","href":"https://platform.flatfile.com"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"flatfileinc","hasAudioNarration":false,"actualSubdomain":"flatfileinc","customDomains":["flatfile.com"],"gitSource":{"type":"github","owner":"flatfilers","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"edits":true,"issues":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6ae914fde836d20f79ac6e8c:success","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"Plugins","count":46},{"language":"default","tag":"Docs","count":45},{"language":"default","tag":"Core Concepts","count":14},{"language":"default","tag":"Advanced Guides","count":14},{"language":"default","tag":"Embedding Flatfile","count":7},{"language":"default","tag":"Data Structure","count":6},{"language":"default","tag":"Reference","count":6},{"language":"default","tag":"Coding Tutorial","count":4},{"language":"default","tag":"Automation \u0026 Processing","count":4},{"language":"default","tag":"Listeners 101: Your First Listener","count":3}]},"assistantConfig":{},"basePath":"/docs","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"static/styles.css","content":"@font-face{font-family:'Flatfile Diatype Mono';src:url('https://flatfile.com/fonts/FlatfileDiatypeMono-Regular.woff2') format('woff2');font-weight:400;font-style:normal;font-display:swap}code,pre,.code{font-family:'Flatfile Diatype Mono', 'SF Mono', Monaco, Consolas, 'Courier New', monospace!important}div#banner{height:auto!important}div#banner p{margin:10 0}foreignObject{display:flex;align-items:center;justify-content:center;\u0026:has(.edgeLabel){background-color:transparent;.edgeLabel,\n .labelBkg {\n background-color: transparent !important;\n }\n\n p {\n margin-inline: auto !important;\n max-width: max-content;\n border-radius: 0.2rem;\n padding: 0.25rem 0.5rem;\n }}}.dark .tab-container{background-color:rgba(0,0,0,0.1);padding:0 1rem;border-radius:0.8rem;border:1px solid rgba(224, 224, 229, 0.1)}.light .tab-container{background-color:rgba(0,0,0,0.03);padding:0 1rem;border-radius:0.8rem;border:1px solid rgba(0, 0, 0, 0.1)}em{font-style:oblique 12deg}code[language=\"text\"]{font-family:'Flatfile Diatype Mono', 'SF Mono', Monaco, Consolas, 'Courier New', monospace!important;line-height:1rem;padding:0;margin:0;white-space:pre;display:block;font-size:1rem}"}]}
{"page":{"pagePath":"legacy-docs/concepts/mapping","slug":"/legacy-docs/concepts/mapping","pageMetadata":{"title":"Mapping","description":"Mapping","icon":"map","href":"/legacy-docs/concepts/mapping","hidden":false},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Mapping\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,ol:`ol`,p:`p`,..._provideComponents(),...props.components},{Heading,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Warning,{children:_jsx(_components.p,{children:`This is legacy documentation maintained for backward compatibility. For the most up-to-date information, please refer to the current documentation.`})}),`\n`,_jsxs(_components.p,{children:[`In Flatfile, `,_jsx(_components.em,{children:`mapping`}),` describes the process of getting data from an uploaded\nfile into a destination worksheet in your application.`]}),`\n`,_jsx(Heading,{level:`2`,id:`the-ghost-of-mapping-past`,children:`The Ghost of Mapping Past`}),`\n`,_jsx(_components.p,{children:`Historically mapping in Flatfile has consisted of two pieces:`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`A `,_jsx(_components.em,{children:`field mapping`}),` which describes which columns in the source data\ncorresponds to which fields in the destination worksheet. For example, maybe\nthe “fname” column in the source data should be mapped to the “First Name”\nfield in the destination worksheet.`]}),`\n`,_jsxs(_components.li,{children:[`For every destination field of type `,_jsx(_components.a,{href:`/legacy-docs/blueprint/field-types#enum`,children:`enum`}),`, an\n`,_jsx(_components.em,{children:`enum mapping`}),` describing which values in the source column correspond to\nwhich allowable enum values in the destination column. For example, you could\nhave an enum column of country codes, and you might need the source value\n“United States” to map to the enum value “US”.`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`Flatfile has developed machine-learning models trained on millions of historical\nmappings that can suggest both field and enum mappings based on the column names\nand values in the source data. You can of course override these suggestions. The\nFlatfile platform remembers your previously chosen mappings and will suggest\nthem when it sees similar schemas / data in the future.`}),`\n`,_jsx(Heading,{level:`2`,id:`the-ghost-of-mapping-present`,children:`The Ghost of Mapping Present`}),`\n`,_jsx(_components.p,{children:`Many users of Flatfile need more control over the mapping process than just\nassigning source fields to destination fields. For example, you might need to\nconcatenate multiple source fields into a single destination field, or you might\nneed to choose the first non-empty value from a set of source fields.`}),`\n`,_jsxs(_components.p,{children:[`To this end, we’ve recently introduced a wider variety of\n`,_jsx(_components.a,{href:`https://github.com/FlatFilers/flatfile-mapping/blob/main/README.md#mapping-rules`,children:`mapping rules`}),`\nthat specify these more complex mapping-related transformations on your data,\nand the notion of a `,_jsx(_components.em,{children:`mapping program`}),` that selectively applies these rules to\nyour dataset.`]}),`\n`,_jsxs(_components.p,{children:[`As of right now the only rule type supported by the Flatfile application is the\n`,_jsx(_components.code,{children:`assign`}),` rule, as described above.`]}),`\n`,_jsxs(_components.p,{children:[`However, we have introduced a\n`,_jsx(_components.a,{href:`https://pypi.org/project/flatfile-mapping/`,children:`Python SDK`}),` that\nallows you to create your own mapping rules and mapping programs and apply them\nto your own datasets outside of Flatfile (e.g. in an ETL pipeline). The SDK is\ncurrently in extreme beta, but we would love to hear your feedback on it. It\nsupports the full complement of mapping rules, as described on its website.`]}),`\n`,_jsxs(_components.p,{children:[`If you have a Flatfile secret key, the SDK also exposes an “automapping” feature\nthat uses the previously-described machine learning models to suggest mapping\nprograms for a given source and destination schema. As with the Flatfile app,\nthis feature currently only provides `,_jsx(_components.code,{children:`assign`}),` rules (and also `,_jsx(_components.code,{children:`ignore`}),` rules\nthat don’t do anything but just communicate that a source field was not mapped).`]}),`\n`,_jsx(Heading,{level:`2`,id:`the-ghost-of-mapping-future`,children:`The Ghost of Mapping Future`}),`\n`,_jsx(_components.p,{children:`In the near future we will be expanding mapping in several ways:`}),`\n`,_jsx(Heading,{level:`3`,id:`richer-mapping-rules-in-the-flatfile-application`,children:`Richer Mapping Rules in the Flatfile application`}),`\n`,_jsx(_components.p,{children:`We are working on adding support for the full set of mapping rules in the\nFlatfile application. This will allow a user mapping an incoming file to create\ncomplex mapping programs, save them, and reuse them.`}),`\n`,_jsx(Heading,{level:`3`,id:`richer-ai-assist-for-mapping-rules`,children:`Richer AI Assist for Mapping Rules`}),`\n`,_jsx(_components.p,{children:`Currently our machine learning algorithms only suggest “assign” rules. In the\nfuture they will also be able to suggest more complex mapping rules; for\ninstance, if your incoming data had a “first name” and “last name” field, and\nyour destination sheet only a “full name” field, the AI might suggest a\n“concatenate” rule that combines the two source fields into the destination\nfield.`}),`\n`,_jsx(_components.p,{children:`In addition, we are working on a natural-language interface for creating mapping\nrules; for instance, you could type “concatenate first name and last name into\nfull name” and the AI would produce the appropriate rule.`}),`\n`,_jsx(Heading,{level:`3`,id:`javascript-sdk`,children:`JavaScript SDK`}),`\n`,_jsx(_components.p,{children:`We are working on a JavaScript SDK that has similar functionality to the Python\nSDK, the most notable difference being that it can’t interact with Pandas\ndataframes. It will be available soon.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Mapping","description":"Mapping","icon":"map","href":"/legacy-docs/concepts/mapping","hidden":false}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"The Ghost of Mapping Past","slug":"the-ghost-of-mapping-past","depth":2,"children":[]},{"title":"The Ghost of Mapping Present","slug":"the-ghost-of-mapping-present","depth":2,"children":[]},{"title":"The Ghost of Mapping Future","slug":"the-ghost-of-mapping-future","depth":2,"children":[{"title":"Richer Mapping Rules in the Flatfile application","slug":"richer-mapping-rules-in-the-flatfile-application","depth":3,"children":[]},{"title":"Richer AI Assist for Mapping Rules","slug":"richer-ai-assist-for-mapping-rules","depth":3,"children":[]},{"title":"JavaScript SDK","slug":"javascript-sdk","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/flatfileinc/0885ab0a767493f4/tools/search-docs/src/advanced-search.js","/docs/_mintlify/custom/flatfileinc/3d93aadd993301a4/tools/search-docs/src/flatfile-docs-search.js","/docs/_mintlify/custom/flatfileinc/f0e30c5d5a2f7f3f/tools/search-docs/src/populate-search-results.js","/docs/_mintlify/custom/flatfileinc/88d0b42aecb7c482/tools/search-docs/tests/test-populate.js","/docs/_mintlify/custom/flatfileinc/76a5acafda6b2f4a/tools/search-docs/tests/test-search.js"],"subdomain":"flatfileinc","siteName":"Flatfile Developer Docs","title":"Mapping - Flatfile Developer Docs","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2025-08-07T02:42:34.356Z","originalFileLocation":"legacy-docs/concepts/mapping.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Mapping\">\u003cmeta data-mint-head name=\"application-name\" content=\"Flatfile Developer Docs\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Mapping - Flatfile Developer Docs\">\u003cmeta data-mint-head property=\"og:description\" content=\"Mapping\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Flatfile Developer Docs\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://flatfile.com/docs/legacy-docs/concepts/mapping\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://flatfileinc.mintlify.site/docs/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Mapping\u0026amp;description=Mapping\u0026amp;theme=1a8226b3069ecd536f43ada5\u0026amp;signature=9b77cbdc547a58bf5091fbf5830b084a31c3f9839936977e361735a68bf2bfd7\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Mapping - Flatfile Developer Docs\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Mapping\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://flatfileinc.mintlify.site/docs/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Mapping\u0026amp;description=Mapping\u0026amp;theme=1a8226b3069ecd536f43ada5\u0026amp;signature=9b77cbdc547a58bf5091fbf5830b084a31c3f9839936977e361735a68bf2bfd7\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/flatfileinc/eJAdNPO4HNQs9zZh/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Flatfile Developer Docs\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#4C4ED9\">\u003clink data-mint-head rel=\"canonical\" href=\"https://flatfile.com/docs/legacy-docs/concepts/mapping\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/legacy-docs/concepts/mapping.md\">","agentPointerHref":"/docs/legacy-docs/concepts/mapping.md","siteName":"Flatfile Developer Docs","nav":{"global":{"anchors":[{"anchor":"API Reference","icon":"book-open","href":"https://reference.flatfile.com"},{"anchor":"Changelog","icon":"scroll-text","href":"https://flatfile.com/docs/changelog"},{"anchor":"Platform","icon":"rocket","href":"https://platform.flatfile.com"}]},"groups":[{"group":"Getting Started","icon":"circle-play","pages":[{"title":"Welcome to Flatfile","href":"/index"},{"title":"Getting Started with AutoBuild","href":"/getting-started/quickstart/autobuild"},{"title":"Creating Your First Project","href":"/getting-started/quickstart/first-project"}]},{"group":"Core Concepts","icon":"lightbulb","pages":[{"title":"Overview","href":"/core-concepts/overview"},{"group":"Infrastructure \u0026 Organization","pages":[{"title":"Environments","href":"/core-concepts/environments"},{"title":"Apps","href":"/core-concepts/apps"},{"title":"Spaces","href":"/core-concepts/spaces"}]},{"group":"Data Structure","pages":[{"title":"Blueprints","href":"/core-concepts/blueprints"},{"title":"Documents","href":"/core-concepts/documents"},{"title":"Workbooks","href":"/core-concepts/workbooks"},{"title":"Sheets","href":"/core-concepts/sheets"},{"title":"Fields","href":"/core-concepts/fields"},{"title":"Records","href":"/core-concepts/records"}]},{"group":"Automation \u0026 Processing","pages":[{"title":"Events and Listeners","href":"/core-concepts/listeners"},{"title":"Jobs","href":"/core-concepts/jobs"},{"title":"Actions","href":"/core-concepts/actions"},{"title":"Plugins","href":"/core-concepts/plugins"}]}]},{"group":"Coding Tutorial","icon":"code","pages":[{"title":"Coding Tutorial","href":"/coding-tutorial/overview"},{"group":"Listeners 101: Your First Listener","pages":[{"title":"01: Creating Your First Listener","href":"/coding-tutorial/101-your-first-listener/101.01-first-listener"},{"title":"02: Adding Validation to Your Listener","href":"/coding-tutorial/101-your-first-listener/101.02-adding-validation"},{"title":"03: Adding Actions to Your Listener","href":"/coding-tutorial/101-your-first-listener/101.03-adding-actions"}]}]},{"group":"Plugins","icon":"puzzle","pages":[{"title":"Overview","href":"/plugins/index"},{"group":"Docs","pages":[{"title":"Autocast Plugin","href":"/plugins/autocast"},{"title":"Automap Plugin","href":"/plugins/automap"},{"title":"Boolean Validator","href":"/plugins/boolean"},{"title":"Constraints Plugin","href":"/plugins/constraints"},{"title":"Currency Conversion Plugin","href":"/plugins/currency"},{"title":"Date Format Normalizer","href":"/plugins/date"},{"title":"Deduplicate Sheet Records","href":"/plugins/dedupe"},{"title":"Delimited File Zip Exporter","href":"/plugins/delimited-zip"},{"title":"Delimiter Extractor Plugin","href":"/plugins/delimiter-extractor"},{"title":"Email Validation Plugin","href":"/plugins/email"},{"title":"Export Workbook Plugin","href":"/plugins/export-workbook"},{"title":"Foreign Database Extractor for Microsoft SQL Server","href":"/plugins/foreign-db-extractor"},{"title":"Geocode Address Data","href":"/plugins/geocode"},{"title":"GPX File Parser and Analyzer","href":"/plugins/gpx"},{"title":"GraphQL Schema to Flatfile Blueprint Converter","href":"/plugins/graphql-schema"},{"title":"HTML Table Extractor","href":"/plugins/html-table"},{"title":"ISBN Validator Plugin","href":"/plugins/isbn"},{"title":"Job Handler Plugin","href":"/plugins/job-handler"},{"title":"JSON Extractor","href":"/plugins/json-extractor"},{"title":"JSON Schema Converter","href":"/plugins/json-schema"},{"title":"Markdown File Extractor","href":"/plugins/markdown"},{"title":"Merge.dev Connection Plugin","href":"/plugins/merge-connection"},{"title":"Number Validation Plugin","href":"/plugins/number"},{"title":"OpenAPI Schema to Flatfile Blueprint Converter","href":"/plugins/openapi-schema"},{"title":"PDF Extractor Plugin","href":"/plugins/pdf-extractor"},{"title":"Phone Number Validation and Formatting Plugin","href":"/plugins/phone"},{"title":"Pivot Table Exporter","href":"/plugins/pivot-table"},{"title":"Record Hook Plugin","href":"/plugins/record-hook"},{"title":"Rollout: Automatic Workbook Updates","href":"/plugins/rollout"},{"title":"Sentiment Analysis Plugin","href":"/plugins/sentiment"},{"title":"Space Configure from Template","href":"/plugins/space-configure-from-template"},{"title":"Flatfile Space Configuration Plugin","href":"/plugins/space-configure"},{"title":"SQL DDL to Flatfile Blueprint Converter","href":"/plugins/sql-ddl-converter"},{"title":"Stored Constraints Plugin","href":"/plugins/stored-constraints"},{"title":"String Validator Plugin","href":"/plugins/string"},{"title":"Text Summarization and Key Phrase Extraction Plugin","href":"/plugins/summarize"},{"title":"Field Translation using Google Translate API","href":"/plugins/translate"},{"title":"View Mapped Data Plugin","href":"/plugins/view-mapped"},{"title":"Webhook Egress","href":"/plugins/webhook-egress"},{"title":"Webhook Event Forwarder","href":"/plugins/webhook-event-forwarder"},{"title":"What3Words Converter Plugin","href":"/plugins/what3words"},{"title":"Excel Extractor","href":"/plugins/xlsx-extractor"},{"title":"XML Extractor","href":"/plugins/xml-extractor"},{"title":"YAML Schema to Flatfile Blueprint Converter","href":"/plugins/yaml-schema"},{"title":"Zip Extractor","href":"/plugins/zip-extractor"}]}]},{"group":"Advanced Guides","icon":"map","pages":[{"title":"Guides Overview","href":"/guides/overview"},{"title":"Authentication and Authorization","href":"/guides/authentication"},{"title":"Actions","href":"/guides/using-actions"},{"title":"Using Record Hooks","href":"/guides/using-record-hooks"},{"title":"Accepting Additional Fields","href":"/guides/accepting-additional-fields"},{"title":"Advanced Filters","href":"/guides/advanced-filters"},{"title":"Custom Extractors","href":"/guides/custom-extractors"},{"title":"Theming","href":"/guides/theme-your-space"},{"title":"Internationalization","href":"/guides/translating-your-space"},{"title":"Data Egress","href":"/guides/egress"},{"title":"Metadata","href":"/guides/utilizing-metadata"},{"title":"Multi-Part Jobs","href":"/guides/multi-part-jobs"},{"title":"Namespaces and Filters","href":"/guides/namespaces-and-filters"},{"title":"Secrets","href":"/guides/share-secrets"}]},{"group":"Embedding Flatfile","icon":"code","pages":[{"title":"Overview","href":"/embedding/overview"},{"title":"JavaScript Embedding","href":"/embedding/javascript"},{"title":"React Embedding","href":"/embedding/react"},{"title":"Angular Embedding","href":"/embedding/angular"},{"title":"Vue Embedding","href":"/embedding/vue"},{"title":"Advanced Configuration","href":"/embedding/advanced-configuration"},{"title":"Server Setup for Space Reuse","href":"/embedding/server-setup"}]},{"group":"Reference","icon":"book-open","pages":[{"title":"Event Reference","href":"/reference/events"},{"title":"Icon Reference","href":"/reference/icons"},{"title":"CLI Reference","href":"/reference/cli"},{"title":"Flatfile Query Language","href":"/reference/ffql"},{"title":"For LLMs","href":"/reference/for-llms"},{"title":"V2 Records API","href":"/reference/v2-records-api"}]}]},"basePath":"","title":"Mapping - Flatfile Developer Docs","deploymentId":"dpl_53YqbBPsHdrqSGqXiWPGU7csRVod","buildId":"dpl_53YqbBPsHdrqSGqXiWPGU7csRVod","dynamics":["10e4515597"],"chunks":["BannerMarkdown-Dk-T3rBp.js","dist-DYCPzQwJ.js","lib-DMeTj1gb.js","lib-B8HbPgcC.js","katex-Dbtb6Wk7.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}