Title: Importing Data with decimals
Last modified: March 7, 2019

---

# Importing Data with decimals

 *  Resolved [gtexeira](https://wordpress.org/support/users/gtexeira/)
 * (@gtexeira)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/importing-data-with-decimals/)
 * Is it possible to import data containing values with decimals points?
 * For example, having a file containing, 23.28,25.17
    -  This topic was modified 7 years, 2 months ago by [gtexeira](https://wordpress.org/support/users/gtexeira/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fimporting-data-with-decimals%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/importing-data-with-decimals/#post-11286208)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Yes, that should not be a problem, TablePress does care about the used decimal
   separator at all. Are you having trouble with this? Have you tried the CSV import
   format?
 * Regards,
    Tobias
 *  Thread Starter [gtexeira](https://wordpress.org/support/users/gtexeira/)
 * (@gtexeira)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/importing-data-with-decimals/#post-11286349)
 * When I import a CSV file containing just 23.28, the table shows 2 columns (A 
   and B) instead of just A
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/importing-data-with-decimals/#post-11286450)
 * Hi,
 * and in those columns, the value is 23 and 28, respectively? I guess the script
   is recognizing the `.` as the CSV separator then.
 * One way around this might be to either add another (dummy) column that you delete
   after the import, or to escape the values in quotation marks, i.e. `"23.28"`.
   This should then be recognized as one cell.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Importing Data with decimals’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/importing-data-with-decimals/#post-11286450)
 * Status: resolved