---
title: "Data, formats and functions"
url: "https://wpimportexport.com/import-export-video-tutorials-for-wordpress/data-formats-functions/"
description: "When to use CSV, JSON, XML, XLSX or ODS, how transformation functions work and how to export and import MySQL table data."
---

Tutorial topic

# Data, formats and functions

File formats, transformation functions and MySQL tables: the building blocks behind every import and export.

 **7** guides

  **6** written guides

  **1** video lesson

 [Latest added Excel Shows #### or Wrong Dates, Lost Leading Zeros and Scientific Notation: Fixing an Exported CSV](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)

 [![Export step 3, Export File Structure with Title, zip_code, customer_number, tracking_number, barcode, size_range, total and Date columns](https://wpimportexport.com/wp-content/uploads/2026/11/01-columns-codes-and-numbers-768x642.webp)](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)

 Export Guides

## [Excel Shows #### or Wrong Dates, Lost Leading Zeros and Scientific Notation: Fixing an Exported CSV](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)

You export orders, products or posts with custom fields from WordPress, open the CSV in Excel, and the values change: the ZIP code 02108 becomes 2108,…

 [Read article](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)

 [![Export step 4, CSV Options: Delimiter set to Semicolon, Include Header Row checked, UTF-8 BOM unchecked](https://wpimportexport.com/wp-content/uploads/2026/11/01-delimiter-semicolon-768x182.webp)](https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/)

 Export Guides

## [Exported CSV Opens in One Column in Excel: Delimiter Fixes](https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/)

You export posts or products from WordPress, double-click the CSV, and Excel puts everything into column A: ID,post_title,post_date in one cell, every row the same. Nothing…

 [Read article](https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/)

 [![Export step 4, CSV Options: Delimiter set to Semicolon, Include Header Row checked, UTF-8 BOM checked with the text Add a byte order mark so Excel shows accented letters and emojis correctly](https://wpimportexport.com/wp-content/uploads/2026/11/01-csv-options-utf8-bom-768x182.webp)](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/)

 Export Guides

## [Broken Characters and Emojis in an Exported CSV: UTF-8 and BOM for Excel](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/)

You export posts or products to CSV, open the file in Excel, and “Café crème” turns into “CafÃ© crÃ¨me”. Emojis become three or four strange characters.…

 [Read article](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/)

 [![Title field pipeline with whitespace cleanup followed by uppercase conversion](https://wpimportexport.com/wp-content/uploads/2026/11/wordpress-field-transformations-03-export-chain-768x432.webp)](https://wpimportexport.com/content-transformation-functions-for-wordpress-import-and-export/)

 Video lesson

## [Content Transformation Functions for WordPress Import and Export](https://wpimportexport.com/content-transformation-functions-for-wordpress-import-and-export/)

A partner wants uppercase titles in a CSV feed, but your editors want readable titles in WordPress. With the PRO transformation functions in Import Export by…

 [Watch and read](https://wpimportexport.com/content-transformation-functions-for-wordpress-import-and-export/)

 [![WP Import Export format selector with CSV JSON XML XLSX ODS and ZIP options](https://wpimportexport.com/wp-content/uploads/2026/09/illustration_3-768x432.webp)](https://wpimportexport.com/csv-json-xml-xlsx-and-ods-what-data-formats-are-and-when-to-use-them/)

 WordPress Data Guides

## [CSV, JSON, XML, XLSX, and ODS: What Data Formats Are and When to Use Them](https://wpimportexport.com/csv-json-xml-xlsx-and-ods-what-data-formats-are-and-when-to-use-them/)

Data formats are the containers we use to move information between websites, apps, spreadsheets, APIs, and databases. Some formats are made for people, some are made…

 [Read article](https://wpimportexport.com/csv-json-xml-xlsx-and-ods-what-data-formats-are-and-when-to-use-them/)

 [![Six MySQL table columns selected for CSV export](https://wpimportexport.com/wp-content/uploads/2026/10/mysql-02-fields-1-768x432.webp)](https://wpimportexport.com/how-to-export-or-import-mysql-database-table-data-with-wp-import-export/)

 Export Guides

## [How to Export or Import MySQL Database Table Data in WordPress](https://wpimportexport.com/how-to-export-or-import-mysql-database-table-data-with-wp-import-export/)

Plugins and custom code often keep their data in their own MySQL tables, outside posts and post meta, and WordPress has no screen to export them.…

 [Read article](https://wpimportexport.com/how-to-export-or-import-mysql-database-table-data-with-wp-import-export/)

 [![WP Import Export import field mapping screen with function assignment options](https://wpimportexport.com/wp-content/uploads/2026/09/assign-transformation-function-768x576.webp)](https://wpimportexport.com/what-are-transformation-functions-and-how-to-use-them-during-import-or-export/)

 Import Export Guides

## [What Are Transformation Functions and How to Use Them During Import or Export](https://wpimportexport.com/what-are-transformation-functions-and-how-to-use-them-during-import-or-export/)

Messy import and export data often needs one last cleanup step before it is safe to save or share. Transformation functions handle that step by changing…

 [Read article](https://wpimportexport.com/what-are-transformation-functions-and-how-to-use-them-during-import-or-export/)

## More tutorial topics

- [Getting started 4](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/getting-started/)
- [Video lessons 17](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/video-lessons/)
- [Using with AI agents 11](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/ai-agents/)
- [Import guides 68](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/import/)
- [Export guides 65](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/export/)
- [Sync and migration 35](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/sync-migration/)
- [WooCommerce 28](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/woocommerce/)
- [Media workflows 13](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/media/)
- [Bulk updates and automation 19](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/bulk-updates-automation/)
- [Plugin comparisons 7](https://wpimportexport.com/import-export-video-tutorials-for-wordpress/plugin-comparisons/)

## Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

 [Download Now](https://wordpress.org/plugins/import-export-by-rockstarlab/)
