English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In


Issues With Excel Import Formatting

See how you can fix excel import issues. Just use OpenOffice in order to save with right formatting

We have decided to do a blog post about this topic due to the increasing amount of issues that users are experiencing when uploading from Excel to QuintaDB.


Excel has been adding decimal points in the number columns and alterations to our time feature that are unseen until after it is uploaded.


I have included instructions below on how to prevent this.


Step 1: Go to http://www.openoffice.org/


Step 2: Download the version pertaining to your operating system and install it.


Step 3: Open your Excel file WITH the new Open Office program (Right click on it and select "Open with". See the screenshot below:




Step 4: Let the file open and then click "Save as" in the top left corner. 


Step 5: Select the folder or location you want to keep your file and then in the drop down for file type, select "text CSV(.csv)". See screenshot:




Step 6: A message will appear letting you know that the some of the information may not be able to be saved in CSV format. Click the "Keep current format" box. Please see screenshot:




Step 7: A window will open. In the "Character set" dropdown, select "Unicode (UTF-8). It should default with a comma (,) as the default "Field delimiter" and with qutoation marks (") as the default "Text Delimiter". It should also default with "Save cell content as shown" checked. These settings are fine and do not need to be changed. Click "OK". Please see screenshot:




Step 8: A warning will appear letting you know that it only saved the active sheet. IMPORTANT - If you have multiple sheets within your workbook that need to be uploaded to QuintaDB you ill need to repeat this process for all of them. Please see screenshot:




Step 9: Upload that file to QuintaDB the same way you would any other file.


We hope this helps solve the mystery of the additional text and bad formatting.


Thanks for using QuintaDB!