When I export app data to a CSV file and open it in Excel, the values are changed
When you look at the data that is exported from an app, the data might be converted to a different data. This is because of Excel specifications.
Value entered in app | Value displayed in Excel cell | Actual value in Excel cell |
---|---|---|
000123 | 123 | 123 |
0343060808 | 3.43E+08 | 0343060808 |
-9:05 | #VALUE! | =-5:9 |
-5:5 | 0 | =-5:5 |
Solutions (Actions to Be Performed in Excel)
You can display the same values as the original ones in kintone by importing the exported app data into Excel.
To import text data into Excel, follow the steps below. The menus and steps described here might be different depending on the Excel version you are using.
-
Open a new Excel workbook.
-
Click Options from the File menu in the upper left corner of the Excel, and open Data.
-
In "Show legacy data import wizards," select "From Text (Legacy)" and click OK.
-
Open the Data tab in the Excel file, and click Get Data.
-
In Legacy Wizards, click From Text (Legacy).
-
When the "Import Text File" screen is displayed, select a file exported from kintone and open it.
-
Select a character encoding as necessary (such as Japanese (Shift-JIS)), and go to the next step.
If there are no garbled characters, you don't need to take any action. -
Select Comma as a separator, and go to the next step.
-
On the "Text Import Wizard - Step 3 of 3" screen, look at the data in preview and select the columns containing the values that are converted to different ones, then select Text for column data format.
You can select multiple columns by clicking columns while pressing the Ctrl key or the Shift key. -
Click Done.
-
On the "Import Data" screen, click OK.
Check if the data exported from the app is displayed properly in the Excel file.